Skip to main content
Skip table of contents

EXPAND

Basic Overview

Description

Expands the node by the desired levels.

The result is a cross product of all rows of the node with all values of the level entered in the formula.

Signature

EXPAND(NodeLevel1 [, Level2, …])

Parameters

  • Node: Input node, specified using the node name

  • Level: Specifies the desired levels to fill with values

Using EXPAND() to set up ROLLFORWARD()

When modeling a relative or absolute change to existing base data with the ROLLFORWARD() function, there are certain restrictions regarding the dimensionality of connected nodes. Take the following example:

We want to fill the “Volume” target node by rolling forward the base data with another simulation node that contains percentual changes to the base data. To do so, the simulation node containing the percentual changes must contain at least a subset (or the full set) of the base data node’s levels

Since the simulation node is empty by default, we can easily fill it with proprietary data by using EXPAND(). In this case, the base data node contains the levels “Year”, “Country”, and “Product”.

(Please note that the simulation horizon is set in the simulation settings)

We fill the simulation node with EXPAND(0, “Year”, “Country”, “Product”) to create the same levels as the base data node but with only “0” as content. This results in making the simulation node eligible for use with ROLLFORWARD().

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.