Export (0) Print
Expand All

Defining a SCOPE statement

A SCOPE statement determines the set of member cells in a model subcube that will be affected by running one or more PerformancePoint Expression Language (PEL) statements. The SCOPE statement evaluates the PEL statement list in the context of a scope expression.

When you define a SCOPE statement, you specify the dimension members that you want the statement to evaluate.

In effect, a SCOPE statement selects a set of cells, and limits the selection to a specified region of cells in a model. Thus, if no SCOPE statement is specified, the PEL compiler uses the whole cube, which is the default scope.

You can create a SCOPE statement by using the Define Scopes pane in the Business Rules workspace, or by inserting dimension members directly in the Rule expression pane.

The following procedures assume that you have an existing rule in the rules table.

NoteNote:

The Define Scopes pane does not support rules that use Preprocessor directives (PEL).

To define a SCOPE statement in the Define Scopes pane

  1. In the Workspace Browser pane, click Models.

  2. In the Models table, click to open a model.

  3. Click the Business Rules tab.

  4. From the list of rules and rule sets, select the rule for which you want to create or modify a SCOPE statement.

    NoteNote:

    If you are creating an Outbound rule, the Define Scopes pane appears automatically, and you can omit step 5

  5. Click the Toggle Scope Editor icon.

    NoteNote:

    This icon is disabled for Outbound rules.

    This inserts the Define scopes pane. For each dimension in the model, the Define scopes pane displays a list of placeholders that resemble the following example:

    /*[Scenario].[All Members].[All].LeafMembers*/

    Each placeholder represents a dimension expression.

  6. For each placeholder listed in the Define Scopes pane, click the ellipsis (…) button next to the placeholder.

    This displays the Add or remove members to include them in the selection for dialog box.

  7. (Optional) Use the Add, Remove, or Find buttons to modify the list of dimension members, or to progress through the member list.

  8. In the Add or remove members to include them in the selection for dialog box, select each member you that want to include, and then click OK.

  9. Repeat steps 6 – 8 until you have selected a dimension member for each dimension listed. This includes dimensions that you might have added. Then, click OK.

  10. Click the Toggle Scope Editor icon. The Transfer scope information dialog box appears.

    In the Transfer scope information dialog box, click Yes to transfer the scope expressions that you defined to the Rule Expressions pane.

    For an Outbound rule, this step finishes the scope definition and rule creation process. Notice that, for an Outbound rule, the Rule expression pane is disabled.

    For all other rules that enable the Toggle Scope Editor button, you must enter the remaining text for your rule statement in the Rule expression pane.

  11. From the Actions menu, select Save This Model to save the scope statement you just created.

To define a SCOPE statement in the Rule Expression pane

  1. In the Workspace Browser pane, click Models.

  2. In the Models table, click to open a model.

  3. Click the Business Rules tab.

  4. From the list of rules and rule sets, select the rule for which you want to create or modify a SCOPE statement.

    The Rule expressions pane becomes active. If you selected a rule that was previously coded, this displays the rule text in the Rule expressions pane. If you selected a new rule, the Rule expression pane is empty.

  5. Position the pointer in the Rule expressions pane where you want the new SCOPE statement to appear.

    If this is a new rule, begin by typing SCOPE(

  6. Right-click in the Rule expression pane, select Insert Member(s) of Dimension, and then select the name of the dimension for which you want to add a member.

    This displays the Select members dialog box.

  7. (Optional) Use the Add, Remove, or Find buttons to modify the list of dimension members, or to progress through the member list.

  8. Select the check box next to each member you want to include, and then click OK.

  9. Repeat steps 6 – 8 until you have selected a dimension member for each dimension that is listed. This includes dimensions that you might have added. Then, click OK.

  10. Enter a closing parenthesis and a semicolon at the end of the scope.

  11. Write the PEL statements that you want your rule to run. The PEL statement list must end with a semi-colon.

  12. End the business rule statement by typing END SCOPE;

  13. From the Actions menu, select Save This Model to save the SCOPE statement that you just created.

Show:
© 2014 Microsoft