Select Dimensions in Microsoft Analysis Services

In this section will choose  create few Dimension Tables. We will first create Time dimension then we will create Customer, Store and Product Dimensions.

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

In the following dialog box, click on  New Dimension

Select Dimensions for Cube


  • You will see the Dimension Wizard Main Screen

Dimension Wizard

  • Click On Next and you will see ‘Choose How you want to create the Dimension’ screen
  • You will create the Product  Dimension Table in the next section
<<< Select Fact Table and Choose Measures in Analysis ServicesCreate Time Dimension in Microsoft Analysis Services >>>
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .