Parameters (PEL)
PerformancePoint Expression Language (PEL) supports user-defined parameters for passing values to a rule at run time. In addition, PEL supports a system parameter that references the current period in the Time dimension.
Default values for rule parameters can be set as model properties. For information, see the topic Add, edit, or delete a model property.
Note
You cannot use parameters in definition rules.
User-defined parameters
To use a parameter with a rule, create the parameter, and then reference the parameter in the rule text. For information about how to create a parameter, see the topic Adding a rule parameter. When you reference a parameter in rule text, the parameter label must be enclosed by dollar signs ($).
The following example shows how parameters for a member of the Entity dimension and a member of the Currency dimension might appear in a SCOPE statement.
SCOPE(
[Scenario][All Members].[Forecast],
[Account].[Corporate].[Salary],
$MyEntity$.LeafMembers,
$MyCurrency$.LeafMembers,
[BusinessProcess].[Standard].[INPUT],
[HR].[HR].[Internal].LeafMembers
);
Each time that you run the rule, you will be prompted to enter values for the parameters.
System parameter
PerformancePoint Expression Language includes the $CURRENTPERIOD$ system parameter that returns the current period in the Time dimension for the model that is being used.
$CURRENTPERIOD$ is defined by the following syntax.
$CURRENTPERIOD$ AS MEMBER OF DIMENSION [Time]
You do not have to create the $CURRENTPERIOD$ parameter. The $CURRENTPERIOD$ parameter is implicitly declared; declaring $CURRENTPERIOD$ explicitly will cause an error.
To find the current period for a model, examine the model Summary page under the General section. To reference $CURRENTPERIOD$, use a model that includes the Time dimension.
The following example shows how to use $CURRENTPERIOD$ in rule text.
SCOPE (
[Account].[Corporate].[Marketing].LeafMembers,
[BusinessProcess].[Standard].[INPUT],
[Currency].[All Members].[USD],
[Entity].[ResortOps].[Resort - Tahoe],
[ParentEntity].[All Members].[NONE],
[Scenario].[All Members].[Forecast],
$CURRENTPERIOD$,
[Version].[All Members].[NONE],
[BusinessDriver].[All Members].[NONE],
[Product].[ResortProducts].[Ski Tuning] );
THIS = ([Scenario].[All Members].[Budget]) * 1.5;
END SCOPE;