Skip to Content
0
Former Member
Apr 02, 2014 at 12:56 PM

Dimension Member Formula

24 Views

Hello Friends,

Need to create a dimension member formula :

Dimension : BOOK – entity type

Dimension : ACCOUNT - Account type

Scenario : create a ACCOUNT dim member formula effecting only members exists in Entity dimension PARENTH3, with property MGMT_CALC = Calc.

I am trying below syntax : but not working.

IIF([BOOK.PARENTH3].CURRENTMEMBER.PROPERTIES("MGMT_CALC")="CALC", (IIF ([PNC_REV]=0,0,[ACCOUNT].[PNC_UUND_TOT]/[ACCOUNT].[PNC_REV])),NULL); SOLVE_ORDER=10

In case I am not reading hierarchy as in below syntax, it works fine.

IIF([BOOK].CURRENTMEMBER.PROPERTIES("MGMT_CALC")="Calc", (IIF ([PNC_REV]=0,0,[ACCOUNT].[PNC_UUND_TOT]/[ACCOUNT].[PNC_REV])),NULL); SOLVE_ORDER=10

The requirement is to ready H3 members with specific property value.

Regards,

Rajesh. K