You use the Accounts Dimension Properties tab to set properties on the accounts dimensions of block storage databases.
In the Time Balance node, you set a time balance property:
Existing definition or none—Apply the setting specified in the outline (the default). If no setting is specified, Administration Services applies “none.”
None—Apply no time balance property. Member values are calculated in the default manner.
First—A parent value represents the value at the beginning of a time period.
Last—A parent value represents the value at the end of a time period.
Average—A parent value represents the average value of a time period.
Skip node—Select an option (None, Missing, Zeros, or Missing and zeros) to determine what values are ignored during time balance calculations. For example, if you select None, no values are ignored, and, if you select Missing and zeros, both #MISSING and zero values are ignored. You can specify skip settings only if the time balance property is set as first, last, or average.
Note: | If, during calculation, Essbase encounters #MISSING values, the #MISSING values are divided by the number of members with values, not by the total number of members. |
In the Currency Conversion node, for currency databases, you define currency-exchange categories:
Existing definition or none—Apply the setting specified in the outline (the default). If no setting is specified , Essbase assumes that the dimension is not currency related.
None (use ancestor)—Specify that the dimension is not currency related.
No conversion—For values, such as quantities or percentages, that do not require conversion
Category—For values that require conversion to specific category types. In the Category box, you enter the type of conversion required, for example, US dollars.
In the Variance Reporting node, you determine how differences between actual and budget data are calculated:
Existing definition or non-expense—Apply the setting specified in the outline (the default). If no setting is specified, Essbase stores the dimension as non-expense.
Non-expense—Set the member as non-expense. You want the actual values of non-expense items, such as sales, to be greater than the budgeted values. When actual values are less than budgeted values, the variance is negative.
Expense—Set the member as expense. You want actual values of expense items, such as Costs, to be lower than budgeted values. When actual values are greater than budgeted values, the variance is negative.
“Creating an Accounts Dimension” in the Oracle Essbase Database Administrator's Guide