Hyperion Essbase (MOSC)

MOSC Banner

HsGetValue - Multiple Members in a Dimension

Hi,

I am trying to see if HsGetValue in SmartView can be used to obtain the values for multiple members within the same dimension. For example, we have a cube built out with an account number dimension storing the natural account from general ledger. I'd like to have the HsGetValue formula return the combined values for member a and member b of the account dimension. Or even better can it return the totals from a range of member values?

here is an example. For specific reports I would need the sum of multiple members in the account dimension.

=@HsGetValue("GL_PRD","

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center