Predefined Properties for Planning and FreeForm Applications
The following properties are predefined for Planning and FreeForm applications. All Planning and FreeForm properties use the PLN namespace.
For more information, see:
Property | Data Type | Inherited | Level | Description |
---|---|---|---|---|
Access Granted to Member Creator |
String |
No |
Node |
Determines the access that member creators have to dynamic members that they create |
Account Type |
String |
Yes |
Node |
Defines account time balance (how values flow over time) and determines accounts sign behavior for variance reporting with member formulas |
Aggregation |
String |
Yes |
Relationship |
Determines how child member values aggregate to parent members |
Alias |
String |
No |
Node |
Alternate unique description for the dimension member |
Attribute Dimension Name |
String |
No |
Node |
Specifies the name of the attribute dimension |
Base Currency |
String |
Yes |
Node |
Specifies the base currency for an entity dimension member in a Standard multiple currency application |
Data Storage |
String |
No Note: When you add a cube, the data storage property for the cube (for example, PLN.Data Storage (Plan 1)) is derived from the application default data storage property (PLN.Data Storage). |
Relationship |
Specifies whether data is stored or calculated for a dimension member |
Data Type |
String |
Yes |
Node |
Specifies the type of data values for a dimension member |
Enable for Dynamic Children |
Boolean |
No |
Node |
Enables users to create children for this member by entering a member name in the runtime prompt for a business rule that has been configured with a dynamic parent member |
Enterprise Predefined Member |
Boolean |
No |
Node |
Designates a dimension member as predefined by the application. Predefined members are restricted to only specific types of changes such as moves, or adding a child under or a top node above them. Note: This property is set by the import process when importing predefined members from a Planning Modules application and it cannot be manually edited in Oracle Enterprise Data Management Cloud. |
Exchange Rate Type |
String |
Yes |
Node |
Determines how exchanges rates are used to calculate values |
Formula |
Memo |
No |
Node |
Member formula used to calculate a value for a dimension member. |
Formula Description |
String |
No |
Node |
Description for a member formula |
Hierarchy Type |
String |
No |
Node |
Available for dimension bound to an aggregate storage cube. Aggregate storage dimension are automatically enable to support multiple hierarchies. The first hierarchy in a multiple hierarchy dimension must be stored. |
Number of Possible Dynamic Children |
Integer |
No |
Node |
Maximum number of dynamic children that can be created for a dimension member. This option is available if Enable for Dynamic Children is selected. |
Plan Type |
Boolean |
Yes |
Relationship |
Specifies whether the dimension members if valid for the plan type. |
Process Management Enabled |
Boolean |
Node |
Determines whether process management is enabled |
|
Skip Value |
String |
Yes |
Node |
Determines how database calculations treat zeros and missing values when Time Balance is First, Balance, or Average. |
Smart List |
String |
No |
Node |
Select a smart list to associate to a dimension member. |
Source Plan Type |
String |
Yes |
Node |
Source plan type for a dimension member |
Time Balance |
String |
Yes |
Node |
Specifies how the application calculates the value of summary time periods |
Two Pass Calculation |
Boolean |
No |
Node |
Recalculate values of members based on values of parent members or other members. Available for Account and Entity members with Data Storage of Dynamic Calc or Dynamic Calc and Store. |
UDA |
List |
No |
Node |
User defined attribute used for calculation or reporting purposes |
Variance Reporting |
String |
No |
Node |
Determines whether an account is treated as an expense during variance reporting |
Weekly Distribution |
Boolean |
No |
Node |
Sets the weekly distribution. Available for bottom level account members if the option was selected when creating the application and the base time period is 12 months. |