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.
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.
Step 2: The very first screen will be Welcome screen which will describe the steps you will be going through and click Next.
Step 3: You will have to provide a Name for our Time dimension and click Next.
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.
Step 5: Specify the range of data storage in the time dimension and click Next.
Step 6: Select the calendar hierarchy and the levels in the hierarchy and click Next.
Step 7: It will show you the status of the Time Dimension creation and click Next.
Please let me know if this helped you and I’ll be happy to answer any of your questions in the comment section below!