Next in Our Series ...
In this article, Working with the Cube Editor, we reviewed and integrated many of the components that we have constructed and the concepts that we have explored individually in the last four lessons. We undertook a complete cube build, demonstrating the assembly of a cube more sophisticated than the cube we generated in our first lesson with the Cube Wizard. We also introduced new capabilities and concepts as we constructed our new cube "from scratch."
In this article, we also discussed the use of the Cube Editor, as opposed to the Cube Wizard, as a means of cube construction, and then we created a basic "starter" cube directly from the fact table, to serve as a foundation for a more elaborate cube. We expanded the dimensions of the cube after adding the associated dimension tables. We worked with the dimensions, defining the appearance of the Member Name Column to meet illustrative business requirements of information consumers; in addition, we reviewed sample uses and purposes of member properties.
We made use of the Dimension Browser for design and observation tasks at various points. We added a derived dimension, and we revisited calculated members, adding a calculated measure to our cube. Throughout the lesson, we worked with various properties of measures and dimensions to control the behavior and characteristics of our cube.
In our next lesson, Exploring Virtual Cubes, we will introduce the concept of virtual cubes. We will discuss the options that virtual cubes provide in allowing us to combine measures from more than one existing cube, as well as in the removal of dimensions and/or measures from our cubes for various reasons. We will practice the use of the Virtual Cube Wizard to create a virtual cube that is a subset of an existing cube, as a means of "customizing" the information presented by a cube to a given information consumer or consumer group. We will expose a process by which we can combine measures from multiple cubes, as well as a means for creating calculated members in our virtual cube. Finally, we will practice the import of calculated members from a sample source cube to our virtual cube.
See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.