Defining a Target for Custom Calculation Rules

Creating Custom Calculation Rules with the Designer Screen describes how to complete the Description page for a custom calculation rule. The next step is to define a calculation target, the range of dimensions that are affected by the custom calculation rule.

To define the target that the custom calculation rule will affect:

1. In an open custom calculation rule, click Target.

   The Target page opens, shown here for an example rule titled Utilities Expense Adjustment.

   Figure A-10 The Target Page of the Create Custom Rule Screen

   
   
   
2. Select the Result Dimension, used in the formula to specify the member to hold the result.
3. Select the Target Dimensions, the members that define the target range that will be affected by the custom calculation formula.
   Optional:You can filter the data as described in Filtering Dimension Members (Mass Edit Page).
4. Define a formula for the rule:.
   1. Enter the formula as a text string (see About Custom Calculation Rule Formula Syntax for format information).
      In this example, the formula looks at the intersection of the Rule and Input dimensions and multiplies it by 0.15, or 15%.
   2. Select Validate to determine if the formula is valid.

      Note:

      Custom calculation rules are validated against the data cube. If you have recently added or changed dimensions or members, the custom calculation rules may not validate correctly until you have redeployed the cube to propagate the changes. For other validation procedures, see Using Model Views and Validating Applications.

5. When the formula is complete, click Save or Save and Close.

To edit and delete rules, see Managing Existing Rules with the Designer Screen.