ROLLUP_TO

Basic Overview

Description	Rolls up the first input node (Node1) to the level-dimensionality of the second input node (Node2)
Signature	ROLLUP_TO(Node1, Node2)
Parameters	Node1: Represents the input that will be rolled up Node2: Used to take the levels to roll Node1 up to
Limitations	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

Example

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:

Dimension	Product		Time		Value
Level	Product Group	Product	Year	Month
Level value	Cars	Model T	2018	2018-01	11
	Cars	Model T	2018	2018-03	5
	Motorcycles	V-Twin	2019	2019-02	7
	Motorcycles	101 Scout	2019	2019-01	19

(Node2) Node Reduced:

Dimension	Product	Time	Value
Level	Product Group	Year
Level value	Cars	2018	50
Level value	Motorcycles	2019	70

Rolling up Node1 to the dimensionality of Node2

ROLLUP_TO('Everything', 'Reduced')

Level	Product Group	Year	Value
Level value	Cars	2018	16
Level value	Motorcycles	2019	26