In a store dimension, information can be retrieved by store and location. Following are the steps for creating store dimension.
Step 1: Right Click on Dimensions node under the Oracle module and select the New option to open the Using Wizard.
Step 2: The welcome screen will describe the steps we will be going through and click Next.
Step 3: You will have to provide a Name for our Product dimension and click Next.
Step 4: You have to select or specify the type of Storage to be used. After that select either Relational or Multidimensional storage type and click Next.
Step 5: The wizard will go to the next screen where we are going to define the attribute for our level. For example, Name ID, and Description. We can also select the data type for the specified attribute. We can change the attribute as per the requirements and click Next.
Step 6: You need to define the hierarchy for your dimension that is from highest to lowest level. For example Country, State, City, Region, and Store, etc and click Next.
Step 7: It shows the Slowly Changing Dimension and click next. Then it will show you the Pre Create Setting and click Next.
Step 8: Finally it will show you the process of Dimension Creation Progress and click on Next.
Step 9: Moving on the next screen with a summary screen of the action with perform. This aims to create a dimension which is visible in our design center.
Please let me know if this helped you and I’ll be happy to answer any of your questions in the comment section below!