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.
Step 2: After that Welcome screen will describe the steps we will be going through. And click Next.
Step 3: We will have to prove a Name for our Product dimension and click Next.
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.
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: We are going to define the hierarchy for our dimension that is from highest to lowest level. For example
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.
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 the summary screen of the action with performing. This aims to creation of 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!