Adds one or multiple Dimensions to a Block.
It will then distribute the data across those dimensions depending on the defined allocation method.
Adding one dimension
Adding one dimension with allocation method
input_block[ADD Allocation method: dimension]
Adding more than one dimension and allocation method
input_block[ADD Allocation method: dimension1, dimension2, ...]
same as source object
Constant - this method will take the value from the source metric or property and apply it to every item within the newly added dimensions. This is the default behavior if no allocation method is defined.
input_block[ADD Constant: dimension]
Split - this method will take the value from the source metric or property and distribute it evenly across the items within the newly added dimensions.
input_block[ADD split: dimension]
Source Metric Country is a simple metric with one dimension, Country. In this example, the Month dimension is added first, then you can see a custom allocation method of SPLIT is defined.
Excel equivalent: none
See also: REMOVE