Create Store Dimension in Microsoft Analysis Services

In this section we will create the Store dimension

Click Create Dimension button again

Unlike our product dimension, all the Store data is present in a single table called Store. So we will choose Star Schema and click Next

You will see ‘Select the dimension table’ screen. select  the Store table

Choose ‘Standard Dimension’ in the next ‘Select Dimension Type’ screen

In the Select The Levels screen choose Store Country, Store State, Store City and Store Name fields in that order

• Click Next and and you will see ‘member key columns’ screen. Simply click next here.
• In the next ‘Advanced Options’ screen click Next
• In the next screen, choose a name ‘Store‘ for our newly created Dimension. Make sure we share this product dimension across other cubes by checking the ‘Share the dimension’ box.
• You will Finish building the Cube in the next section