Defining a virtual cube

You define a virtual cube at the project level.

Procedure

Select a namespace in the Project Explorer tree.
Click New Virtual Cube .
Select a maximum of two source cubes to merge into a virtual cube. You can include dynamic cubes from the current project, and dynamic cubes or virtual cubes deployed as data sources to the content store:
- To include a dynamic cube from the project, select the cube from the list.
- To include a dynamic cube or virtual cube from the content store, click Add Content Store Cube, select the required data source, then click OK.
Click OK.
Complete the virtual cube definition by using the Properties tab.
You can view the source cubes from which the virtual cube is derived.
From the Project Explorer tree, right-click the virtual cube and select Open Editor. You can perform the following tasks from here:
- To add a source cube, click Add Source Cube .
- To delete a source cube, select the cube name, and click Delete .
- To view the virtual measure dimension, click Measures .

What to do next

You can now fine-tune virtual objects and define further objects as required. For more information, see Model virtual dimensions, Model virtual hierarchies, Viewing virtual levels, Model virtual members, and Model virtual measures.

You can also add calculated measures or calculated members to a virtual cube. For more information, see Calculated members.

When you finish, you can test the validity of the virtual cube to check for errors, and then deploy and publish the virtual cube. For more information, see Validate a project and individual objects and Deploying and publishing dynamic cubes.

Tip: If a virtual cube contains a source cube deployed as a data source to the content store, the data source must be started before you can deploy the virtual cube.