Testing for a Dimension Member

To have Oracle Hyperion Financial Management execute an action only if a particular dimension member is the current member, use an If structure that tests the return value of the Member function.

In this example, if the current scenario is Budget,Financial Management multiplies the amounts in the UnitsSold and Price accounts and inserts the product in the Sales account.

If HS.Scenario.Member =  "Budget" Then

  HS.EXP "A#Sales = A#UnitsSold * A#Price"

End If

Tip:

All If structures must begin with an If...Then statement and end with an End If statement. The actions to be executed if the condition is met are sandwiched between the If...Then and End If statements as shown above.