MAP
Removed in | Version 3.6.0 |
Description | Allows to map a level in a node to a different level, either in the same or a different hierarchy. This replaces the level (and its hierarchy) from which is mapped with the level (and its hierarchy) to which it is mapped. For example, when mapping from Business Entity to Country, you lose the business organization hierarchy and get the location hierarchy on Country level. If the mapping table contains other levels, these are used to apply the mapping accordingly. The node must at least have all levels from the mapping table, except for the to-Dimension. The factor allows to do splits and partial mappings. If you want a 1-to-1 mapping which keeps the measure fill the factor column with 1. |
Example | To create models where a certain share of revenue is transferred onto a consolidation item, you can easily map from the business entity to a consolidation or diff entity. Use EXPANDSINGLE afterwards, in case you need to re-add the from-level again. |
Signature | MAP(Node, DataSource, DataTable, FromColumn, ToColumn[, FactorColumn]) |
Parameters |
|