Time Dimension Properties
The time dimension defines the units of time for your model and how those units aggregate.
Any dimension that is assigned the type T is a time dimension. Each model can have only one time dimension.
A time dimension has the following required properties:
|
Property Name |
Description |
|---|---|
|
BASE_PERIOD |
A system-generated property, used by the query engine for calculations and by the Consolidation process. It can be maintained as fiscal periods. |
|
LEVEL |
Time can be a year, quarter, month, week, or day. The LEVEL property is important in defining your time periods. You must have the correct level for each member. You must follow the chronological format throughout the time dimension. The correct format is the following:
|
|
PERIOD |
The PERIOD property allows you to filter, sort, and report based on the period. It can be maintained as calendar periods. |
|
YEAR |
The YEAR property allows you to filter, sort, and report based on the year. You should place the YEAR properties in chronological order in the file, in order for the EPMMemberOffset function to give offsets between fiscal and calendar year correctly. |
The following property is required only if the time dimension is used in a consolidation model:
|
Property Name |
Description |
|---|---|
|
MONTHNUM |
Provides a sorting order to leaf members of the time dimension within a year. For each base member, the number should be unique. |
|
TIMEID |
Numeric ID to used for identifying the time member, for example, 20120100 for 2012.JAN. |
For detailed information about maintaining these properties, refer to the note
2114433 
.