How to Create Time Dimension in OWB?

How to Create Time Dimension in OWB?

In the Warehouse Builder, Time dimension is used for signifying a time period. The OWB has the following Levels available for the Time dimension when using the Time Dimension Wizard.
Day
Fiscal week
Calendar week
Fiscal month
Calendar month
Fiscal quarter
Calendar quarter
Fiscal year
Calendar year

following are the steps for creating time dimension:

Step 1: Right Click on Dimensions node under the Oracle module and select the New option to open the Using Time Wizard.

How to Create Time Dimension in OWB

 

Step 2: The very first screen will be Welcome screen which will describe the steps you will be going through and click Next.

How to Create Time Dimension in OWB

 

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

How to Create Time Dimension in OWB

 

Step 4: You have to select or specify the type of Storage to be used. Then you have to select either Relational or Multidimensional storage type and click Next.

How to Create Time Dimension in OWB

 

Step 5: Specify the range of data storage in the time dimension and click Next.

How to Create Time Dimension in OWB

 

Step 6: Select the calendar hierarchy and the levels in the hierarchy and click Next.

How to Create Time Dimension in OWB

 

Step 7: It will show you the status of the Time Dimension creation and click Next.

How to Create Time Dimension in OWB

 

Step 8: Summary window will display you the completed information of Time dimension definition and click Finish.How to Create Time Dimension in OWB

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