Implementing a Cube Design
Now that I’ve covered the basics of how to design a cube, I will demonstrate the basics of creating a cube.
Within Solution Explorer, launch the New Cube Wizard.
Proceed to the second step and select to Use existing tables and click Next.
Select a measure group(s) which contain measures and dimensions you wish to use and click Next. In this example I wish to expose dimensions of Customer data.
Now I’m presented with all possible measures (facts) selected in the measure group. I’ll use all and select Next.
Now I can choose which dimensions to select and click Next.
Finally I’m prompted to Finish the wizard and am presented with the BIDS interface where I may expose the properties of my cube in detail. For example, I may use the cube browser.