EXPANDSINGLE

Overview

The EXPANDSINGLE function expands a node by adding specific level values for one or more levels. For each specified level-value pair, the function creates rows containing the value from the input node.

Use this function when you want to assign a value to a specific dimensional combination, such as creating entries for a particular year, region, or product.

Syntax

EXPANDSINGLE('Node', "Level1", Value1 [, "Level2", Value2, ...])

Value can be a single level value in double quotes or a list of level values in square brackets.

Example usage: EXPANDSINGLE('Sales', "Year", "2025")

Parameters

Multiple Level–Value pairs can be provided to expand across multiple dimensions.

Output Shape

Watch Out

• Unlike EXPAND, EXPANDSINGLE creates rows only for the explicitly specified level values, not for the full cross product.
• The specified level values must exist in the hierarchy.
• When a list of values is provided, one row is created for each value.
• You cannot expand on a level whose dimension already exists on the input node at the same or coarser granularity. You can only expand by a more fine-grained level in that dimension.

Examples

Expand a value to a specific year

Input node: Node

Formula: EXPANDSINGLE('Node', "Year", "2026")

The value is assigned to the Year 2026.

Expand across multiple levels

Formula: EXPANDSINGLE('Node', "Year", "2026", "Product Group", "Cars")

The value is expanded across two dimensions simultaneously.

Expanding to multiple values

You can also provide a list of values.

Formula: EXPANDSINGLE('Node', "Year", "2026", "Product Group", ["Cars", "Trucks"])

Each value in the list creates a new row.

One-time Tax Relief in 2026

Node: Base Taxation

Node: Relief Value

Formula: EXPANDSINGLE('Relief Value', "Year", "2026")

Output node:Relief Expanded

Calculation: Base Taxation - Relief Expanded

The relief only affects 2026, because that is the only expanded year.

Example with hierarchical levels

If a hierarchy exists, specifying the lowest level is sufficient.

Example hierarchy

Product Group → Product Line → Product

Input node: Quantity

Formula: EXPANDSINGLE('Quantity', "Product", "Max T 3")

Because “Max T 3” belongs to the product line “Sedans,” which in turn belongs to the product group “Cars,” Valsight automatically fills in these parent levels in the result. You only need to specify the most detailed level.

Using a Project Variable as the level value

Instead of hardcoding a year, you can use a project variable so the formula updates automatically when the variable changes.

Formula: EXPANDSINGLE('Relief Value', "Year", "$PLANNING_START")

This creates a row for the year currently defined by $PLANNING_START, no formula change needed when the planning horizon shifts.

See also:Project Variables

Related Functions