You can create a time dimension directly from the Databases tree
or from an empty dimension editor.
Procedure
- Right-click the Dimensions node in your database on the
Databases tree, then click Create time
dimension.
Alternatively, you can create a time dimension by clicking the Configure time
dimension option when you create a new dimension. The Configure time
dimension option is only available for a dimension with one hierarchy and no
members.
- If required, enter a name for the dimension.
- Select the Start year for the dimension.
- Select the End year for the dimension.
- Answer the How frequently do you plan? question by selecting the
granularity of the dimension.
- Months
- This option gives you three levels: Months, Quarters, Years.
- Quarters
- This option gives you two levels: Quarters, Years.
- Years
- This option gives you one level: Years.
- Check the preview to confirm that it matches your expectation, then click
Save.
You can modify the time dimension in the dimension editor
after you create it.