Seeding template in Planning Business Modeler

The rule that you can create by using the Seeding template seeds the next year. That is, the rule performs the following actions:

  • Multiplies the data from the dimensional slice for the present year by a specified numeric constant

  • Copies the products of the multiplication to the cells of the corresponding dimensional slice for the next year

The rule that you create from this template takes advantage of the PerformancePoint Planning Business Modeler default value for scope definition. That is, if no dimensions are specified in the SCOPE statement of a business rule, Planning Business Modeler supplies a default scope value of the whole cube. If only one dimension is specified, Planning Business Modeler supplies the all dimensional values in the slice along the designated dimension, and so on.

Prerequisites

None

Implementation

A rule that you develop from this template has SQL implementation. You can run this rule directly from Planning Business Modeler, or include this rule as part of a user-specified job. For more information, seeSQL implementation.

Placeholder substitution requirements

To convert the Seeding template into a rule, you must substitute actual dimension values for the placeholders in the template. 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

Description

<<[Time].[Hierarchy].[Next Year]>>

Time dimension member that specifies the year to be seeded

<<[Time].[Hierarchy].[This Year]>>

Time dimension member that specifies the year that must be used as source data

<<Constant>>

Numeric value to be multiplied times source data values before seeding to next year

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!

×