How to Create Store Dimension in OWB?

How to Create Store Dimension in OWB?

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.

How to Create Store Dimension

 

Step 2: The welcome screen will describe the steps we will be going through and click Next.

How to Create Store Dimension

 

Step 3: You will have to provide a Name for our Product dimension and click Next.

How to Create Store Dimension

 

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.

How to Create Store Dimension

 

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.

How to Create Store Dimension

 

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.

How to Create Store Dimension

 

Step 7: It shows the Slowly Changing Dimension and click next. Then it will show you the Pre Create Setting and click Next.

How to Create Store Dimension

 

Step 8: Finally it will show you the process of Dimension Creation Progress and click on Next.

How to Create Store Dimension

 

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.

How to Create Store Dimension

Please let me know if this helped you and I’ll be happy to answer any of your questions in the comment section below! 

Leave a Reply