The rounding method specifies whether to round allocated values (the default is not to round).
If you choose to round values, the rounding method specifies how to handle rounding errors. You can choose to discard rounding errors, or to round all allocated values and add the total rounding error to the highest allocated value, the lowest allocated value, or to a specific cell. If you choose to add the rounding error to the highest or lowest allocated value, and there are multiple highest or lowest allocated values, Essbase chooses one of the highest or lowest values to which to add the rounding error.
If you choose to round allocation values, you can use these parameters to further define the rounding method:
(Required if rounding allocated values) Round digits specifies the number of decimal places to which allocated values are rounded. You can choose to round to the nearest integer (the default), to a specified number of decimal places, or to a power of 10.
Round digits must be a number from -100 to 100 and can be expressed as an integer, an MDX numeric value expression, or a tuple.
Using an MDX numeric value expression is helpful when the setting for round digits is based on the currency of the allocated value. For example, assume that the database contains a dimension named Currency, which is part of the POV, and an associated attribute dimension named NumCurrencyDigits, which specifies how to round allocated values based on the currency of the allocated values. You can express round digits as:
Currency.currentMember.NumCurrencyDigits
Note: | If, for the rounding method, you choose not to round allocated values, the round digits parameter must be empty. |
(Required if rounding method is set to a specific location) Round to location specifies a cell to which to add the total rounding error. Expressed as a tuple, the cell must be in the range and have the same dimensionality as the range. Round to location can consist of only level 0 members.
Note: | If, for the rounding method, you choose an option other than to round to a specific cell, the round to location parameter must be empty. |