Mechanism of automatic scaling of measurement units enables the user to show data saved in different scale in a uniform scale. For example, indicators saved in tens and thousands can be shown in millions.
Scaling of measurement units is available in the Reports tool.
Measurement units are presented as a separate dimension in cubes.
To set up measurement units in cubes, one can use only a units dictionary, but a cube indicators dictionary should have an additional attribute.
NOTE. Measurement units cannot be scaled if data caching is enabled.
Time series database data is saved in different scale: in rubles and thousands of rubles. Differences in scale complicate perception of information, displaying of data by one scale of visualizer leads to incorrect perception of information.
Data for the first row is saved in the Rubles unit with the scale 1. Two other rows contain data saved in the Thousands of Rubles unit with the scale 1000:
Select the Rubles unit for the current report sheet, data is displayed in one unit:
See also:
Creating Other Objects | Data Connection and Preparation