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.