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.

1-SSAS-Creating-a-Cube

Proceed to the second step and select to Use existing tables and click Next.

2-SSAS-Creating-a-Cube

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.

3-SSAS-Creating-a-Cube

Now I’m presented with all possible measures (facts) selected in the measure group. I’ll use all and select Next.

4-SSAS-Creating-a-Cube

Now I can choose which dimensions to select and click Next.

5-SSAS-Creating-a-Cube

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:

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

w

Connecting to %s