Period Dimension Properties
Period, Parent, Alias: Default, Alias: T1, Data Storage, Two Pass Calculation, Description, Formula, UDA, Smart List, Data Type, Operation, Type, Start Period, End Period, Aggregation (Plan1), Aggregation (Plan2), Aggregation (Plan3)
Notes:
-
For Period, Parent should be specified for most update operations.
-
Type (such as Base or Rollup) cannot be changed for existing members. You can add and update Rollup and Alternate members. You can update BegBalance and Base time periods (for example, to add an alias). You cannot add or modify YearTotal time period. The DTS Period type is recognized, but is not supported by the Outline Load utility. If you try to load DTS information, the utility displays an error in the log file.
-
Start Period and End Period are valid for Rollup Period types.
-
Plan type names and numbers depend on what is defined in the application.
-
For properties common to Period and Account members, see Account Dimension Properties.
Table 5-6 Period Dimension Properties
| Column Header in Load File | Oracle Hyperion Planning Property | Value | Default | Required |
|---|---|---|---|---|
| Period | Member Name | Text, subject to Planning restrictions on Period member names. | ||
| Type | Not exposed in Planning | Text: base, rollup, year, alternate, DTS; only Rollup and alternate time periods can be loaded by the utility; BegBalance and Base periods can be modified (for example, to add an alias); YearTotal and DTS time periods cannot be loaded or modified.
|
None | Yes |
| Start Period | Text (only applicable to summary time periods) | Text, restricted to time periods already defined for the application. | None | Yes |
| End Period | Text (only applicable to summary time periods) | Text, restricted to time periods already defined for the application. | None | Yes |