Account load files can include these properties:
Account, Parent, Alias: Default, Alias: T1, Valid For Consolidations, Data Storage, Two Pass Calculation, Description, Formula, UDA, Smart List, Data Type, Operation, Account Type, Time Balance, Use 445, Use 544, Use 554, Skip Value, Exchange Rate Type, Variance Reporting, Source Plan Type, Plan Type (Plan1), Aggregation (Plan1), Plan Type (Plan2), Aggregation (Plan2), Plan Type (Plan3), Aggregation (Plan3), AttribDim1, AttribDim2
For details on these properties, see the following table and Common Member Properties.
Notes:
Time Balance specifies how account data flows over time. It takes a type only for members with an account type of Saved Assumption, or if the record is rejected.
When Time Balance is Flow, records with any valid skip values are loaded, but Skip Value is disabled for all Account types.
Skip Value can be set when Time Balance is First, Balance, or Average. These options set which values to skip when the parent value is calculated: none, #MISSING, zeros, or #MISSING and zeros.
Plan type names and numbers depend on what is defined in the application. Base time periods cannot be added with the utility. Year, base time periods, and exchange rates cannot be deleted.
YearTotal and BegBalance time periods cannot be modified with the utility.
Exchange Rate Type depends on the value specified for Data Type. Valid values: Average, Ending, and Historical when Data Type is Currency, or None when Data Type is anything other than Currency.
Variance Reporting loads account members with an account type of Saved Assumption or if the record is rejected. Expense designates the saved assumption as an expense. The actual amount is subtracted from the budgeted amount to determine the variance. Non-Expense designates the Account as not an Expense. The budgeted amount is subtracted from the actual amount to determine the variance. Values for Account types: Revenue: Non-Expense, Expense: Expense, Asset: Non-Expense, Liability: Non-Expense, Equity: Non-Expense.
When you update or save the parent of a member, the system verifies if the Source Plan Type associated with the member being loaded is valid for the new parent. If the source plan type of a member is valid for the parent member but not for the member itself, the member is saved, but its source plan type is set to the first valid plan type. If a Source Plan Type is specified but is not valid for the parent, the record is rejected.
Table 29. Account Dimension Properties
| Column Header in .CSV Load File | Planning Property | Value | Default | Required |
|---|---|---|---|---|
| Account | Member Name | Text, subject to member naming restrictions | None | Yes |
| Parent | Member Name | Text, subject to member naming restrictions. | None; the name of an existing member, or, if empty, the member is placed as a child under the dimension root | No (Need to specify for most Period members) |
| Alias:Alias_Table_Name | Alias | Text, subject to Planning member naming restrictions and aliases already defined in the alias table specified in the column header; <none> removes any alias binding for the member from the specified table. | None | No One column header for each alias table defined on the dimension is displayed. Default is a pre-defined alias table defined for every dimension. |
| Valid For Consolidations | Not Used | N/A | N/A | No |
| Data Storage | Data Storage | Text: Store, Dynamic Calc and Store, Dynamic Calc, Never Share, Shared,Label Only | Inherited from the parent. If the parent is the root member, the default is Never Share | No |
| Two Pass Calculation | Two Pass Calculation | True, False, or an integer: non-zero is true; zero is false | Inherited from the parent | No |
| Description | Description | Text, subject to Planning maximum character restrictions; <none> removes a description | None | No |
| Formula | Formula | Text, subject to Essbase restrictions for valid formula syntax; <none>removes a formula | None | No |
| UDA | UDA | A single UDA text value, or a quoted, comma-separated list of UDA text values; non-existing UDAs are added to the dimension; existing UDA bindings are removed on subsequent saves if not re-specified; nothing specified leaves bindings as is; <none> removes all existing UDA bindings. | None | No |
| Smart List | Smart Lists | Text, restricted to names of Smart Lists that are already defined for the application. Should be specified only if Data Type is set to Smart List; <none> removes any existing Smart List binding | None | No |
| Data Type | Data Type | Text: Unspecified, Currency, Non-Currency, Percentage, Smart List, Date, Text | Inherited from the Parent; Currency if the member is added under the root dimension | No |
| Operation | Text: update; delete level 0; delete idescendants; delete descendants | Update | No | |
| Account Type | Account Type | Text: Expense, Revenue, Asset, Liability, Equity, Saved Assumption | Inherited from the parent; Revenue if the member is added under the root dimension. | No |
| Time Balance | Time Balance | Text: Flow, First, Balance, Average, avg_actual, avg_365, fill | Inherited from the parent (default Time Balance values for Account types: Expense: FlowRevenue: Flow, , Asset: Balance, Liability: Balance, Equity: Balance) | No |
| Use 445 Use 544 Use 554 (Only one column header appears, depending on system settings. If weekly distribution is not defined for the application, no column header displays.) | Weekly Distribution (If Weekly Distribution is set to Even for the application, no distribution option displays.) | True, False, or an integer: nonzero is true; zero is false | None | No |
| Skip Value | Text: None, Missing, Zeros, Missing and Zeros; must be None if Account Type is Expense or Revenue | Inherited from the parent | No | |
| Exchange Rate Type | Exchange Rate Type | Text: None, Average, Ending, Historical (None should not be specified if Data Type is set to Currency; otherwise, it should be specified) | Inherited from the parent; Average if member is added under root dimension. | No |
| Variance Reporting | Variance Reporting | Text: Non-Expense, Expense. (Must be Expense if Account Type is Expense; must be Non-Expense for all other Account types. | Inherited from the parent; Non-Expense if the member is added under the root dimension. | No |
| Source Plan Type | Source Plan Type | Text: Plan Type names defined in the application (for example, Plan1 or Plan2) | Plan1 or the name of the first plan type defined in the application | No |
| Plan Type (Plan1) | Plan Type | True, False, or an integer: non-zero is true; zero is false | Inherited from the parent | No |
| Aggregation (Plan1) | Aggregation | Text: +, -, *, /, %, ~, Never | Inherited from the parent. If the parent is a root member, the default is +; for Year, the default is ~ (ignore) | No |
| Plan Type (Plan2) | Plan Type | True, False, or an integer: non-zero is true; zero is false | Inherited from the parent | No |
| Aggregation (Plan2) | Aggregation | Text: +, -, */%~, Never | Inherited from the parent; if the parent is the root member, the default is +; for Year, the default is ~ (ignore) | No |
| Plan Type (Plan3) | Plan Type | True, False, or an integer: non-zero is true; zero is false | Inherited from the parent | No |
| Aggregation (Plan3) | Aggregation | Text: +, -*/%, ~, Never | Inherited from the parent; if the parent is a root member, the default is +; for Year, the default is ~ (ignore) | No |
| Attribute Dimension Name (this property is available for sparse Account, Entity, or user-defined dimensions) | Attributes | The name of an attribute defined in the attribute dimension: existing attribute bindings are removed on subsequent saves if not re-specified; nothing specified leaves bindings as is; <none> removes all existing attribute bindings for the member; one column header is displayed for each Attribute dimension defined on the dimension. | None | No |