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","