Period Dimensions Table

A period dimensions table defines the time periods to be used. The number of levels in the period dimensions table depends on your reporting needs. A period dimensions table contains the following columns and must conform to the following rules:

Position
Name Maximum Length Description
1
ID Char 32 The identifying value for the period
2
L3_Scenario Char 32 Third-level dimension member value (for example, Actual or Budget)
3
L1_Year Char 32 Top-level dimension member value (for example, 2006)
4
L2_Quarter Char 32 Second-level dimension member value (for example, 2006_Q4)

The following picture shows a sample period dimensions table:

The following picture shows the relationship between this sample period dimensions table and the resulting profit-and-loss report:

Related Topics: