Lookup()

Lookup returns the value from the Source.Indicator aligned to the current block, using the dimension property if specified.

🗒️ Description


Provides the flexibility to map data in a specific way that may not follow the standard data flow, explicitly overriding the system's automatic data alignment between blocks or indicators. This is used to define custom data relationships, such as transferring values from one dimension item to another (e.g., moving customers out of one pricing tier and into another) or when the default system logic needs to be explicitly redefined.

✏️Syntax & variables


value = Lookup( Source.Indicator, Dimension.Property )

Parameter Description
Source.Indicator The indicator you want to reference (e.g., "Historical Data".Volume).
Dimension.Property (optional) A property that explicitly defines how to map the source values to the current block, overriding the automatic dimension mapping (e.g., Product.Category, Customer.Region).

✅ Expected result & examples

The Lookup() function is useful for controlling how data is aligned or for carrying forward specific values between different blocks or tiers.\


1.     Transferring Data Across Model Tiers (Tier Upgrade):

○       Scenario: A model is being upgraded, and historical revenue data from the Free_Model block needs to be transferred to the new Starter_Model block. The data must be explicitly mapped by Product.SKU.

○       Formula: Lookup('Free_Model'.Revenue, Product.SKU)

○       Result: This formula retrieves the revenue value from the Free_Model for the matching Product.SKU in the current row of the Starter_Model, ensuring only historical data aligned by that specific key is transferred.


2.     Overriding Default Alignment for Calculations:

○       Scenario: In the Cost block, you need to pull in the Price from the Sales block, but the system's default mapping uses Product Name. You need to force the mapping to use a common Region dimension instead for regional pricing analysis.

○       Formula: Lookup('Sales'.Price, Region)

○       Result: The formula explicitly aligns the Sales block's Price to the current Cost block row based only on the shared Region property, allowing for consistent regional analysis even if other product details differ.