Oracle Hyperion Financial Management Tips And Techniques

GetCell Functions

While the HS.Exp writes data, the HS.GetCell function is used to retrieve data from the database. You will need to pull values from the database to either test if a number is valid, or to see if you should perform a rule. The most common way to use these numbers is to populate the variable with numbers:

You can specify all of the same values you can for the HS.Exp on the right-hand side of the equal sign here too. You can use all 12 dimensions, mathematical operators, relative members, and other functions.

The following example assigns to the dData variable the amount stored in the intersection of the Sales account dimension: ...