Conditional Rules

You may want a rule to execute an action only when certain dimension members are the current members in the Point of View. For example, you might want an account’s value to be calculated in one way when Actual is the current scenario and a different way when Budget is the current scenario.

Tip:

For information on how Oracle Hyperion Financial Management determines the current dimension members, see Current Dimension Members.

To do this, use the Member function in a VBScript If structure. Member gets the name of the current member of these dimensions:

  • Entity (Use the Entity object to get the current entity or the Parent object to get the parent of the current entity.)

  • Period

  • Scenario

  • Value

  • Year

If structures enable you to execute statements only if certain conditions are true. The following sections show a few different ways of using Member with If structures to test for dimension members.

Tip:

These sections cover only a few of the If structure aspects. For more details on If structures, consult Microsoft’s VBScript documentation. (You can download VBScript documentation from Microsoft’s Web site.)