Use Linked Models

Introduction

Linked Models are used to link multiple Models together. Models which are linked can share Measures and Dimensions. The main use of this feature is to create Validation Models which define relationships between Dimension Members. The image below illustrates two Models, Workforce Planning and Validation, which have been linked together.

Add a Linked Model 

To add a Linked Model, select a Model and navigate to the LINKED MODEL tab. Click Add  and select the Model(s) you wish to link. You can then use the gear icon  next to each Linked Model to further configure which Measures are accessible. By default, all Measures within a Model can be accessed.

Note: After adding or configuring Linked Models, you will need to re-deploy the application.

Relationships in Forms

The most common purpose in Linking Models is to create relationships. These relationships define the valid combination of members across Dimensions within a Model. For instance, there might be a set of products that are sold in certain countries, or a relationship that defines which Accounts are valid for a set of Departments.

Tip: For more information on relationships between Dimension Members, as well as a few examples of how they can be configured, visit the Use Relationships article.

Linked Model Dimensions

In addition to having access to the Linked Model's Measures, we also have access to its Dimensions as well. In the LAYOUT tab for any Form within the Model, at the bottom of the Dimension List are all the available Linked Dimensions.

Linked Model Measures

Once a Linked Model has been added, we can access the Measure values for the Linked Model. In this example, the Rule Calculate Percentages uses [Measures].[Profit_Value].