Use the Add Level command or the Insert Level command to add a level to a date dimension.
Once you complete the Properties pane for the Date Dimension, you can specify the subsequent hierarchy level of dates, in descending order.
To add a level to the hierarchy, you must be in the Design Tree at the Date branch or at a previously defined date level.
To add a level to a date dimension
- Select the Dimension branch in the Design tree.
- Select the date dimension branch.
- To add a level after all existing levels, choose the Add Level command. The level is added and the Properties pane for the level displays.
OR
To insert a level after an existing level, select the level and choose the Insert Level command. The level is added and the Properties pane for the level displays.
- Complete the fields in the Property Pane.
Notes
- You can also add relative dates to a date dimension.
- Changes made in the Property pane apply when you leave the pane or perform another operation in O3 Designer.
Sample Date Level Property Pane
The Date Level Property Pane
Fields in the Property pane include:
Property |
Description |
Name |
Enter a name for the level. |
Description |
Enter a description of the level. |
Granularity |
Choose a level of detail for the hierarchy's level. Supported granularity levels are: Year, Quarter, Month, Week and Day |
When generating a Cube, all data extracted from sources is grouped for the date dimensions, according to the granularity of the last level selected. The information automatically groups for higher levels of the granularity as well as for other hierarchical relationships.
Example
A Cube for sales analysis, which has a Date Dimension, "Invoices Date", with the last level corresponding to Month, belongs to "Monthly" granularity.
In this example, the invoices are grouped according to their month, generating information only for those months with invoices, and leaving blank those months with no invoices.
Notes
- All the granularity levels are optional but each must be subordinate to one of preceding granularity level. It is not possible to use for example Quarter above Year or Month above Quarter.
- For the Week level of granularity, weeks are identified by numbering them in their order of appearance during a month, e.g., Week 1, Week 2, etc.