Skip to Content
avatar image
Former Member

Currentmember in MemberFormula doesn't work for multiple selection

Hi guys,

We have a member formula in the account dimension as follows:

Iif([OBC_ORG_HIER].CURRENTMEMBER.PROPERTIES("GR_LINE")="301370",[SC_TOTAL],SUM(DESCENDANTS([OBC_ORG_HIER].CURRENTMEMBER,10,LEAVES),Iif([OBC_ORG_HIER].CURRENTMEMBER.PROPERTIES("GR_LINE")="301370",[SC_TOTAL],0)))

Basically we look at our current selection for org_hier (entity dimension) and we look for an attribute to be equal to 301370. If that's correct, then sum all transactions for that org member. Otherwise, look at all descendents of that member and sum the value for the leaves that verify this same condition.

This works fine on reports when you bring all org units that have this attribute = 301370. But when you bring a mix of org hier members on the report that make this condition true and false.... then it crashes giving us this error:

Any help on this guys?

Regards,

Iago

error2.png (53.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 23, 2015 at 11:33 AM

    The logic of the member formula is strange and not clear... I recommend to use additional hierarchy in entity dimension instead of using property! Hierarchy is used for aggregation, not property!

    Vadim

    Add comment
    10|10000 characters needed characters exceeded