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 Field Length | Description |
1 |
ID | Char 32 | The identifying value for the period Note: The name must be ID. |
2 |
L1_Scenario | Char 32 | Top-level dimension member value (for example, Actual or Budget) |
3 |
L2_Year | Char 32 | Second-level dimension member value (for example, 2008) |
4 |
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: