Basic Overview

Description

Expands the Node for the given values on the given Levels. The result is a Node with an additional column for the Levels only containing the given values. The values have to exist on the levels. If the values don’t exist on the given levels, the result will be empty.

Signature

EXPANDSINGLE(NodeLevel1Value1,[ Level2, Value2,] ...)

Parameters

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

  • Level: The level by which the input node shall be expanded

  • Value: The value with which the input node shall be expanded

  • New in Version 2.10: The function can have more than one Level - Value pair

Example

Basics

Input: Node =

Value

1.1


Output  = EXPANDSINGLE('Node', "Year", "2015")

Year

Value

2015

1.1

Output  = EXPANDSINGLE('Node', "Year", "2015", "Product Group", "Cars")

Year

Product Group

Value

2015

Cars

1.1

One time Tax Relief in 2019

Node Base Taxation

Year

Value

2018

1,000

2019

1,000

2020

1,000

2021

1,000

Node Relief Value 

Value

500


Node Relief Expanded = EXPANDSINGLE('Relief Value', "Year", "2019")

Year

Value

2019

500

Tax TotalBase Taxation - Relief Expanded 

Year

Value

2018

1,000

2019

500

2020

1,000

2021

1,000

Example with lower level dimensions

With defined hierarchies, it is enough to specify the lowest level.

Hierarchy: Product Group, Product Line, Product

Node Quantity

Value

500


Node Model T Black Sales = EXPANDSINGLE('Quantity', "Product", "Max T 3") 

 Product Group

Product Line

Product

Value

Cars

Sedans

Max T 3

500


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.