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

Cube Wizard


  • 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

Cube Wizard

  • You will create a Dimension Table in the next section
<<< Create a Data Cube in Microsoft Analysis ServicesSelect Dimensions in Microsoft Analysis Services >>>
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .