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:

Name Maximum Field Length Description
ID Char 32

The identifying value for the period

Note: The name must be ID.

L1_Scenario Char 32 Top-level dimension member value (for example, Actual or Budget)
L2_Year Char 32 Second-level dimension member value (for example, 2008)
L3_Quarter Char 32 Third-level dimension member value (for example, 2008_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:

See also: