Referencing Dimensions
How to configure references to Dimensions
Auto Relationships
When you create a reference to a Variable that has Dimensions, Models needs to know which items within that Variable to reference when performing Calculations.
Most of the time, Models can automatically work out which items to reference.
For instance, in the example below, Revenues by region and membership type has the Calculation Gym members [Auto] * Revenue per member [Auto].
The [Auto] suffix to the Variable references indicates that Models will automatically deduce the correct relationships, based on Dimensions.
Revenues by region and membership type and Gym members both have two Dimensions: Region and Membership Tier - they vary both regionally and by gym package.
Revenue per member only has one Dimension, Membership Tier, as the price of the gym does not vary by region.
For each item of Revenues by region and membership type, Models will take the matching line from each of the reference Variables.
Custom relationships
We can configure the way that Dimensions are referenced.
For example, let's say we want to create a new Variable called Revenue if everyone is Platinum.
We use the same formula as in the example above (Gym members * Revenue per member), but this time we want the Revenue per member reference to only use the Platinum value.
To do this, we open the Calculation Part wizard for the Revenue per member Variable Reference, and navigate to the Reference type step, as shown below:
In the item match dropdown, we select a Custom match (1). A new step is displayed which allows us to customise the match for the Membership Tier Dimension. Here, we can specify that it should always link to the Platinum item (2), rather than varying based on the source Variable's Dimension.
This results in the desired calculation, as shown below:
Last updated