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