Share via


Percent variance to previous period template

The rule that you create from the Percent Variance to Previous Period template calculates the percent of variance between values in the current period and the prior period. In addition, the rule determines whether the difference is favorable or unfavorable. For example, suppose the rule compares revenue from Q1 of 2007 to revenue from Q4 of 2006. If the rule determines that Q1 2007 revenue is more than Q4 2007 revenue, the rule classifies the variance as favorable and assigns a positive sign to the variance. Similarly, if the rule determines that Q1 2007 revenue is less than Q4 2006 revenue, the rule classifies the variance as unfavorable and applies a negative sign to the variance amount.

You can use this rule template for any periods, regardless of level in the Time dimension. That is, if the selected period is a month, the rule compares the account values with the values that were recorded for the same month of the previous year. If the selected period is a quarter, the rule compares current values with those in the same quarter of the previous year.

Prerequisites

The following task is a prerequisite for a rule that you create with this template:

Implementation

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

Placeholder substitution requirements

To convert the Percent Variance to Previous Period 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

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

User-defined member of the TimeDataView dimension that stores the calculated variance

<<[AccountHier]>>

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

<<[TimeHier]>>

Time hierarchy that is used by the current model

See Also

Reference

ParallelPeriod (PEL)
Iif (PEL)

Concepts

About the TimeDataView dimension
Variance to previous period template

Other Resources

Predefined templates for general business rules
About the Account dimension