EXPANDSINGLE
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(Node, Level1, Value1,[ Level2, Value2,] ...) |
Parameters |
|
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 Total= Base 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 |