Attributes of an Account Dimension
The Account dimension defines the set of account members and the format of the account data.
The account dimension is the main dimension of the model. In addition to the basic columns of Member ID, Description, and Account Type, a set of technical properties is automatically created when the dimension is first set up.
- In live data models, the Account dimension is named Measures.
- For models based on HANA views, a reduced set of attributes is available; hierarchies, financial data types, and currency types are not relevant. Also, a different set of values for Aggregation types is available.
- For models based on S/4HANA views, these attributes are available: ID, Description, Scale, Decimal Places, and Visible.
- If you're going to use a shared account dimension, see this help topic for important information: Public Account Dimensions.
The Account dimension uses an Account Type attribute to automatically handle positive and negative values. From an accounting perspective, account members belonging to the Profit and Loss statement and the Balance Sheet have to be correctly stored in the database with either a positive or negative value so that the accounts balance correctly. In SAP Analytics Cloud, you can enter all values as positive numbers, and the switching of signs from positive to negative is handled automatically on the basis of the Account Type setting.
There are four financial account types: Income (INC) and Expense (EXP) items are included in the Profit and Loss account, and Assets (AST) and Liabilities (LEQ) are Balance sheet items. Automatic switching is applied to the account types INC and LEQ. Note that all formulas work on the displayed value, not the value saved in the database.
When importing data from an external system, a mapping feature is available to ensure that imported data also fits into this schema. This feature is switched on using the Reverse the Sign of the Data Based on Account Type check box in the Details panel when importing data. When this check box is activated, imported data will also be identified by account type and stored and handled correctly.
Currency Rate Types
If you are using currencies with this account, and you have added specific exchange rates based on rate types to the currency table, you can add the Rate Type column to the account grid by switching on Currency Conversion in the model preferences.
Select the account type for this type of data:
The asset and liability types are aggregated over time and must be linked to an aggregation dimension in the model (such as the built-in Date dimension).
This attribute column appears when you switch on Currency Conversion in the model preferences. With currency conversion switched on, set the Rate Type to Average for INC and EXP accounts, and to Closing for AST and LEQ accounts. This setting corresponds to the rate type for exchange rates in your currency table. It lets you distinguish between the average exchange rate over a period and the closing rate at the end of the period. For more details, see Currency Conversion Tables.
|Units & Currencies||
Use this attribute to set the value type and display units. Select one of the following from the list:
The attribute can also be left blank. In this case, the abbreviated unit from Scale is displayed (see below).
For account members that are parent nodes, the aggregation type determines how values are accumulated from the leaf nodes. These aggregation types don't relate to any dimension.
|Exception Aggregation Type||
Use exception aggregation when you want to aggregate non-cumulative quantities. For example, if you have the quantity Inventory Count, you might want to aggregate the inventory count across all products, but not across time periods, because it doesn't make sense to add up inventory counts from multiple time periods.
In this case, you would choose the aggregation type SUM for Inventory Count, because you want to add up the inventory counts for all products. But if you don't specify an exception aggregation type, the inventory counts will also be summed across time. To prevent summing inventory counts across time periods, specify an exception aggregation type for the time periods.
For example, you might want to choose just the most recent set of Inventory Count values. In this case, you would choose the exception aggregation type LAST, and the exception aggregation dimension Date.
Exception aggregations relate to one or more dimensions. For example, for the AVG and LAST exception aggregations, a Date dimension is appropriate. If you select an exception aggregation type, you must also select an exception aggregation dimension.
You can also use exception aggregation when you've included aggregated quantities in formulas, to ensure that the formula calculations are performed before the aggregation. For more information, see Price * Volume Formulas and Aggregation in Formulas.
|Exception Aggregation Dimension||
If an exception aggregation dimension is required for the member (depending on the account type or aggregation type), enter it here. Choose a dimension from the dimension selector dialog, which shows all dimensions in the model and the built-in Date dimension.
To improve the presentation of numbers in stories, and hide numbers that are not significant, you can set this attribute to show just integers plus the specified number of decimal places. The unit value is then shown by the appropriate word or by an abbreviation. You can select one of the following options:
This feature is related to the setting of the Unit attribute that determines if the Scale word or just the abbreviated Scale letter is used (see also the example following this table):
This setting defines the number of digits displayed after the decimal point; select a value from 0–7.
Calculations and predefined formulas can be used for any value of the Account dimension.
Refer to the Formulas section for full details.
This column is still available, but deprecated, because it doesn't work in all cases. Instead, we recommend that you use exception aggregation. For details, see Aggregation in Formulas.
This example illustrates the effect of the Scale and Unit settings.
For a member where the Scale has been defined as Million, Unit is blank, and Decimal Places is set to 2, the number 92624530 will be displayed in the data grid with an abbreviation as 92.62M.
If, on the other hand, Unit is set to Currency, the value will be the full word: 92.62Million.
If no Scale value is selected, the full number is shown formatted by appropriate separators; for example: 92,624,530.00