Microsoft Analysis Services Tutorial

Select Fact Table and Choose Measures in Analysis Services

In this section will choose  a Fact Table and add measures to it.

Click on Next button on the Create Cube Wizard from the previous section

In the following dialog box, choose sales_fact_1998 as your Fact Table

• Click on Next and you will see all the numeric columns present in the Fact table
• Choose Store Sales, Store Cost and Unit Sales and click next

• You will create a Dimension Table in the next section

Next>> Select Dimensions in Microsoft Analysis Services