Run rate template in Planning Business Modeler

The rule that you can create from the Runrate template calculates the run rate, or average account value in the source scenario. Then, the rule populates the accounts in a destination scenario by copying the computed value to selected periods.

You might use a run rate calculation to forecast company performance over time, based on selected results from current scenarios. For example, if a company has revenues of $120 million in the most recent quarter, a company representative might say, "Our latest results put us at a $480 million run rate."

Prerequisites

None

Implementation

This rule has SQL implementation. To run a rule with SQL implementation, you can run the rule directly from PerformancePoint Planning Business Modeler, or include the rule as part of a scheduled job.

Placeholder substitution requirements

To convert the Runrate 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 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]>>

Destination scenario for storing calculated averages

<<[Time].[Hierarchy]…>>

Start period in the destination scenario

<<[Time].[Hierarchy]…>>

End period in the destination scenario

<<[Time].[Hierarchy]…>>

Starting period from which run rate is calculated

<<[Time].[Hierarchy]…>>

The ending period from which run rate is calculated

<<[Scenario].[Hierarchy]…>>

Source scenario for calculating run rate

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!

×