How to Create Product Dimension in OWB?

How to Create Product Dimension in OWB?

In a product dimension, various products for sale can be broken out. Following are the steps for creating product 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 Product Dimension

 

Step 2: After that Welcome screen will describe the steps we will be going through. And click Next.

How to Create Product Dimension

 

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

How to Create Product Dimension

 

Step 4: We have to select or specify the type of Storage to be used. We are going to select either Relational or Multidimensional storage type and click Next.

How to Create Product 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 Product Dimension

 

Step 6: We are going to define the hierarchy for our dimension that is from highest to lowest level. For example

How to Create Product Dimension

 

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

How to create product dimmension

 

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

how to create product dimension

 

Step 9: Moving on the next screen with the summary screen of the action with performing. This aims to creation of dimension which is visible in our design center.

how to create product 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