Adding Measure Conditions to an Access Rule

Measure conditions and dimension value conditions determine which plan cells the access rule applies to. If you don't define any measure conditions, the access rule only uses the dimension value conditions to determine the plan cells that it applies to.

To add measure conditions to an access rule:

  1. Open the access rule you want to add the measure conditions to.
  2. Open the Dimensions And Measures tab.
  3. In the Measures section, click Add Measure Conditions. The Measure Conditions window displays.

  4. Select one of the following operators:

    • "Equals", if you want the access rule to apply to the specified measures.
    • "Does Not Equal", if you want the access rule to apply to all measures, except for the specified measures.
    • "Contains", if you want the access rule to apply to measures that contain the specified text.
    • "Does Not Contain", if you want the access rule to apply to all measures that do not contain the specified text.

  5. For Value, depending on the operator that you selected, do one of the following:

    • If you selected "Equals" or "Does Not Equal", search for and select the values.
    • If you selected "Contains" or "Does Not Contain", enter the value that you want to use.
  6. [Optional] To add more measure conditions, click Add Condition, then repeat steps 4 and 5 to define the condition.

  7. If you added multiple conditions, specify the logical operator that is applied between the conditions. In the Condition Logic field, select one of the following:

    • "AND", if you want all the conditions to be met for the rule to apply. This means that all the conditions must evaluate to true.
    • "OR", if you want at least one of the conditions to be met for the rule to apply. This means that at least one condition must evaluate to true.
    • "Custom Logic", if you want to define a custom logical expression that must evaluate to true for the rule to apply.
  8. If you selected "Custom Logic" in the Condition Logic field, define the custom logical expression in the Custom Logic field. You can use AND, OR, and parentheses to build the expression. Each condition is represented by a number. You must ensure that all the conditions are included in the expression.
  9. Click Save. The measure conditions are now added.