Predefined Properties for Planning and FreeForm Applications

Note:

Predefined members are used in Planning Modules only. See Customizing Predefined Artifacts.

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.

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.