The Create Date-Time Dimension Wizard automates the creation of time dimension hierarchies and attributes within aggregate storage outlines.
To use the Create Date-Time Dimension Wizard:
In the Outline Editor window, right-click an aggregate storage outline.
On the Select Common Attributes page, complete the following actions:
Enter a dimension name.
Select the first day of the calendar week.
Select the beginning and end of the preferred time period.
See Create Date-Time Dimension Wizard—Select Common Attributes Page for detailed information about this page.
In the Create Date-Time Dimension Wizard—Select Calendar Hierarchy Page, select a calendar hierarchy type.
For information about calendar hierarchies, see Calendar Template Definitions.
As needed, modify the hierarchy, including enabling linked variable attributes (LVAs).
Select OK to close the Select Calendar Hierarchy dialog box.
Select Next to open the Create Date-Time Dimension Wizard—Select Day Attributes Page.
On the next page, you enter reserved days (weekends) and holidays. See Select Day Attributes for information about this window.
Create Date-Time Dimension Wizard—Add Calendar Hierarchies Page
Create Date-Time Dimension Wizard—Define Labeling Rules Page
Create Date-Time Dimension Wizard—Select Calendar Hierarchy Page
Create Date-Time Dimension Wizard—Select Common Attributes Page
Create Date-Time Dimension Wizard—Select Day Attributes Page
Create Date-Time Dimension Wizard—Select Linked Attributes Page
“Aggregate Storage Time-Based Analysis” in the Oracle Essbase Database Administrator's Guide