Attaching Multiple Analytic Workspaces

You can attach more than one analytic workspace at a time. However, when working with multiple analytic workspaces, you must take care when you name objects. When you request an object by name, either with the DESCRIBE command or by referring to it in a command or program, all the active analytic workspaces are searched until the named object is found. When you intend to use several analytic workspaces together, do not give the same name to objects in different analytic workspaces, unless you are prepared to use qualified object names when you reference the objects.

Qualified Object Names

When you attach more than one workspace, and objects in more than one workspace have duplicate names, you must use qualified object names to indicate which objects you want to reference.

A qualified object name uniquely identifies an object by including the workspace name. By using a qualified object name, you can clearly indicate to Oracle OLAP which object (in which workspace) you want to access.

For example, if you have attached the NORTHEAST workspace, which has a variable called SALES, and you have attached the SOUTHEAST workspace, which also has a variable called SALES, you must specify these variables using the following qualified object names (QONs).

northeast!sales
southeast!sales

The first part of a QON is a workspace name, and the second part is the name of the object. An exclamation point (!) joins the two parts.

You can intermix the use of qualified and unqualified names. You only need to use the qualified name to identify a specific object in one workspace when an object that has the same name exists in another attached workspace. If you do not specify a QON for either duplicate, then Oracle OLAP might use one or the other; the results are undefined.

Multiple AUTOGO and Permission Programs

If you have AUTOGO or permission programs defined in analytic workspaces that are currently attached, then the one in the analytic workspace that you are attaching is executed. However, if you have analytic workspace permission programs in more than one currently attached analytic workspace, then you must use their qualified object names when you edit them or use them in any other way. This will ensure that you access the appropriate version.