virtual cube

If you don't want a particular dimension from one of the two cubes to be available in the virtual cube, there is an option to hide it.

If the member exists in only one of the cubes, that member is simply added to the virtual cube.

If a dimension or member is renamed for the virtual cube, then the name available for the virtual cube is the user-specified one.

For a virtual cube, the dimensional security is inherited from its two cubes.

If you need to secure a virtual cube, you need to define security on the non-virtual cubes on which the virtual cube is based.

The virtual calculated members exist only in the context of the virtual cube and are not available from the dependent cubes.

If the two cubes that compose a virtual cube have dimensions with identical names, those dimensions are selected for merging.

A virtual cube is a superset of selected cubes in your database. Virtual cubes are similar to views in a relational database.

A virtual cube can be started or deployed only after both its direct cubes are started or deployed.

Each time the virtual cube is started, it checks the two cubes and performs the merge.

The calculated members need to be redefined for the virtual cube as needed.

Optionally define or add calculated members to the virtual cube by selecting Add MDX Calculated Member.

The virtual cube inherits the security definitions of its base cubes.

Merge operators are SUM, MINUS, PRODUCT, DIVIDE, MAX, MIN, and NOP (returns data from the first cube in the virtual cube definition).

This only affects the virtual cube, and not the cube that contains the dimension.

The virtual cube [SalesConversion] needs to define a calculated member that handles the actual currency conversion.

Note that you cannot define security on a virtual cube.

Sets whether drill through is enabled on this virtual cube.

Select the two cubes to be aggregated to form the virtual cube.

If a member is not to be included in the resulting virtual cube, it can be hidden.

The calculated members defined on the cubes are not available on the virtual cube.

You can then create a new virtual cube which contains the new dimension and the original source cube.

The virtual cube will have the time dimension [Time].

There are no specific security settings for a virtual cube.

The results are aggregated by the virtual cube according to the merge operator.

There is a virtual cube design option to hide dimensions from the cubes so they will not exist on the virtual cube.

The virtual cube contains the union of all available dimensions.

The virtual cube that aggregates these two cubes will have the members 2007 and 2008 merged from both cubes and also the member 2009.

Add a virtual cube to the model using the Add Virtual Cube option.

Listing 5 and Figure 7 show how virtual cube elements appear in Design Studio.

When do you want to process the virtual cube?

By renaming 2008_1 to 2008, the virtual cube has the members 2007 and 2008 merged from both cubes and also the member 2009.