EXPANDSINGLE

Basic Overview

Description	Adds a new column to the Node for the specified Level(s), containing only the given value(s). If the value(s) are not found in the Level(s), the result will be empty. Supports multiple Level–Values pairs and value lists.
Signature	EXPANDSINGLE(Node, Level1, Value(s)1,[ Level2, Value(s)2,] ...)
Parameters	Node: Input node, specified using the node name in single quotes (e.g. 'Profit'). Level: The level on which to expand the input node. Value: The value with which the input node shall be expanded. This parameter can also be a list of values placed in square brackets.

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

Output = EXPANDSINGLE('Node', "Year", "2015", "Product Group", ["Cars", “Trucks”])

Node Base Taxation

Node Relief Value

Value
500

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

Year	Value
2019	500

Tax Total= Base Taxation - Relief Expanded

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