Rolls up the first input node (Node1) to the level-dimensionality of the second input node (Node2)
Node1: Represents the input that will be rolled up
Node2: Used to take the levels to roll Node1 up to
Input node 'Node2' can not contain levels that are not in input node 'Node1'
Input nodes can not have equal levels
Formula can feature only two inputs
For you as a user, only the levels 'Product Group', 'Year' and 'Value' are relevant. Therefore, you prepare the node 'Reduced' to feature only those levels, relevant for your work.
Node 'Everything' (and possibly multiple nodes) contains two more levels ('Product', 'Month'). Those two levels are not relevant for you and your work.
With the ROLLUP_TO formula, you can roll node 'Everything' up to the level-dimensionality of node 'Reduced'.
That means that the levels included in node 'Everything' will be reduced to only those levels featured in node 'Reduced'.
This example is explained below:
(Node1) Node Everything:
(Node2) Node Reduced:
Frequently asked questions can be found here.
You may contact the Valsight Customer Support via:
+49 30 46799042
Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .
*Except Public holidays in Berlin, Germany.
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.