Model-to-model association planning considerations in Planning Business Modeler

Model-to-model associations can be created between models, dimensions, and members to enable movement of fact data in PerformancePoint Planning Business Modeler. Associations can be useful for automating the synchronization of business unit planning, budgeting, and forecasting into the corporate model for summarized reporting. Associations can also be used for duplicating existing data for use in what-if analysis or for aggregating data from the division model to corporate model for business planning.

Fact data movement is enabled by changing the arrangement of reference data and related measures. It is important to understand that associating models in Planning Business Modeler is about fact data movement, so you should focus on the amount of data, not on MDX calculations.

One important item to be aware of when planning your model associations is that data movement and aggregations can involve a one-to-one or many-to-one relationship between the models' dimension members that you plan to associate. However, the relationship between the dimension members cannot be one-to-many.

Similarly, application changes can impact your model associations. For example, if you remove a dimension in the model that is referred to in an association, you will not be able to open the association to view or edit. The association must be deleted or the missing dimension must be replaced for the association to be viewed, edited, or run. Additionally, any changes to model or dimension definitions should be evaluated prior to implementation to ensure they will not impact established model associations.

Finally, you should consider your users' role assignments when you plan model-to-model associations, as only members of the Data Administrator role can run associations.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!