Basic Overview

Description

Rolls up the given Node so it has no more than the given Levels left. ROLLUP(Node) will roll up that Node to a single measure.

Signature

 ROLLUP(Node, Dimension1, Level1, Dimension2, Level2, … , [AggregationType])

Parameters

  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')

  • Dimension1, Level1: Zero or more pairs of dimension and level names to roll up to

See also: Aggregation Settings

Examples

Input node Quantity  describes quantity of products sold across time and categories.

Dimension

Product

Time

Value

Dimension Levels

Product Group

Product

Year

Month

Level Values

Cars

Model T

2018

2018-01

11

2018-03

5

Motorcycles

V-Twin

2019

2019-02

7

101 Scout

2019

2019-01

19

Following examples describe Rolling up with different aggregation levels and aggregation functions. 

Rolling up with sum (default)

ROLLUP('Quantity')=

Value

11 + 5 + 7 + 19 = 42

Rolling up with average

ROLLUP('Quantity', "AVG")=

Value

(11 + 5 + 7 + 19) / 4= 10.5


Rolling up to year and product group dimension levels with sum

Using the pairs of dimension and level names Time-Year and Product-Product Group. 

ROLLUP('Quantity', "Time", "Year", "Product", "Product Group")=

Product Group

Year

Value

Cars

2018

11 + 5 = 16

Motorcycles

2019

7 + 19 = 26


FAQs

Frequently asked questions can be found here

Contact 

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.