SSAS: Creating a Cube

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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s