EXPANDSINGLE

EXPANDSINGLE

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

Examples

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 LineProduct

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





Was this helpful?

Yes | Somewhat | No