Variance between two scenarios templates

PerformancePoint Planning Business Modeler includes two templates that help you create business rules to calculate the variance between different scenarios.

  • Variance Between Two Scenarios

  • Percent Variance Between Two Scenarios

A rule that is created from any variance template is a Definition rule with MdxScript implementation. Every time that you query a cell set that falls in the scope that is defined by the rule or script, PerformancePoint Planning Business Modeler runs the rule and caches the script in the cube. For more information, see MdxScript implementation.

In this topic

Prerequisites

Variance Between Two Scenarios template

Percent Variance Between Two Scenarios template

Prerequisites

The following tasks are prerequisites for a rule that you create with one of these templates:

  • Create a new member of the Scenario dimension that will store the values that are calculated by this rule. PerformancePoint Planning Server provides a script to create this member. For more information, see Script to create dimension members for rule templates.

  • Be sure that the SCOPE statement for this rule includes all ToDate members of the TimeDataView dimension. By default, the PERIODIC member is included with the TimeDataView dimension. However, you must specify each ToDate member that you want to include when you create the placeholder substitution for TimeDataView. For more information, see About the TimeDataView dimension.

Top of Page

Variance Between Two Scenarios template

A rule that you create from this template calculates the variance between values from two different scenarios. In addition, the rule indicates whether the difference between scenarios is favorable or unfavorable by assigning a positive or negative sign.

For example, suppose the variance compares values in an Actual scenario with values that are in a Budget scenario. In this case, if actual revenue is larger than budget revenue, the rule assigns a positive sign to the calculated value that indicates that this difference is favorable. Similarly, if actual revenue is less than budget revenue, the rule assigns a negative sign to the calculated value that indicates that this difference is unfavorable.

For information about the values that you must provide for this template, expand the following link:

Rule template substitutions

To convert the Variance between Two Scenarios template into a business rule, you must substitute actual dimension values for the placeholders in the templates. For information about how to substitute values, see the topic Filling a placeholder in a rule template.

The following table describes the placeholder substitutions that you must make to create a business rule from this template.

Placeholder

Comment

<<[Scenario].[Hierarchy].[VAR_SCENARIO]>>

User-defined member of the Scenario dimension that will store the calculated variance

<<[TimeDataView].[All Members].[All_ToDate_Members]>>

List of all members of the TimeDataView dimension that have ToDate rules associated with them

<<[AccountHier]>>

Provide an account hierarchy name for each of the following accounts: Income Statement, Income Statement Debit, Balance Sheet, and Balance Sheet Credit

<<[Scenario].[Hierarchy].[FIRST_SCENARIO]>>

The first scenario in the comparison

<<[Scenario].[Hierarchy].[SECOND_SCENARIO]>>

The second scenario in the comparison

Top of Page

Percent Variance Between Two Scenarios template

A rule that you create from this template calculates the percent of the variance in values from two different scenarios. In addition, the rule determines whether the variance between scenarios is favorable or unfavorable.

For example, suppose the variance compares values in an Actual scenario with values in a Budget scenario. In this case, if the actual revenue is larger than the budget revenue, the rule assigns a positive sign to the calculated value that indicates that this difference is favorable. Similarly, if actual revenue is less than budget revenue, the rule assigns a negative sign to the calculated value that indicates that this difference is unfavorable.

For information about the values that you must provide for this template, expand the following link:

Rule template substitutions

To convert the Percent Variance Between Two Scenarios template into a business rule, you must substitute actual dimension values for the placeholders in the templates. For information about how to substitute values, see the topic Filling a placeholder in a rule template.

The following table describes the placeholder substitutions that you must make to create a business rule from this template.

Placeholder

Comment

<<[Scenario].[Hierarchy].[PctVariance_ActualMinusBudget]>>

User-defined member of the Scenario dimension where the calculation will be applied

<<[TimeDataView].[All Members].[All_ToDate_Members]>>

List of all members of the TimeDataView dimension that have To-Date rules associated with them

<<[AccountHier]>>

Provide an account hierarchy name for the following accounts: Income Statement, Income Statement Debit, Balance Sheet, and Balance Sheet Credit.

<<[AccountHier]>>

The Account hierarchy for Income Statement debit accounts

<<[Scenario].[Hierarchy].[FIRST_SCENARIO]>>

The first scenario in the comparison

<<[Scenario].[Hierarchy].[SECOND_SCENARIO]>>

The second scenario in the comparison

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!

×