Introduction to MSSQL Server 2000 Analysis Services: Manage Distinct Count with a Virtual Cube - Page 5
February 14, 2005
Creating a Virtual Cube to House Our Solution
We will now combine the cubes with which we have been working in this session within a virtual cube. The intent will be to create a "logical" cube that appears, from a browsing and reporting perspective, as a standalone physical cube. We will thus combine functionality into a single logical cube, accruing benefits that we will discuss as we encounter them.
As many of us know already, a virtual cube allows us to broaden both the scope and capabilities of the OLAP data contained within the participating MSAS cubes, while incurring no additional physical storage space requirement. Virtual cubes can be useful in many applications, one of which is the combination of standard cubes for the purposes upon which our practice example is focused.
Let's take the following steps to create the virtual cube to complete the assembly of our solution.
1. Right-click the Cubes folder.
2. Click New Virtual Cube on the context menu, as shown in Illustration 22.
The Virtual Cube Wizard Welcome Dialog appears as depicted in Illustration 23.
3. Click Next.
The Select the cubes to include in the virtual cube dialog appears.
4. Double-click the DISTINCT_CUSTOMERS cube, to select and move it from the Available cubes list to the Virtual cube includes list.
5. Double-click the Sales cube to add it to the Virtual cube includes list, as well.
The dialog appears as shown in Illustration 24, after our selections.
6. Click Next.
The Select the Measures for the Virtual Cube dialog appears.
7. Click the Add all measures (">>") button to add all measures to the Selected measures list on the right of the dialog.
The Select the measures for the virtual cube dialog appears as depicted in Illustration 25, with our selections appearing in the Selected measures list.
8. Click Next.
The Select the dimensions for the virtual cube dialog appears. We will select all dimensions for purposes of this lesson.
9. Click the Add all dimensions (">>") button to add all dimensions to the Selected dimensions list on the right of the dialog.
The Select the dimensions for the virtual cube dialog appears as shown in Illustration 26, with our selections appearing in the Selected dimensions list.
10. Click Next.
The Finish the Virtual Cube Wizard dialog appears.