MDX FORMULA - HIERARCHY ERROR

[former_member623]

Hello,

BPC 10.1 nw ,hana mdx enabled.

Member formula:

IIF([ENTITY].CURRENTMEMBER=[ENTITY].[PC_ASA],10,20)

----------------

[ENTITY].[PC_ASA] - This member is only in H2 hiearachy.

above member formula works only when i select an entity from H2.if i select an entity from H1 , report throws an mdx error "no result set..".

is there any syntax error in the formula? or is it a system bug.

thanks in advance.

Rekha

[former_member623 · Accepted solution]

it works after changing formula as Below:

IIF([ENTITY].CURRENTMEMBER.NAME = "PC_ASA", 10, 20)

[former_member186338]

If other properties are working - put some unique value in another property and use it as workaround...

[former_member623]

Other properties works fine..Only ID not working

[former_member186338]

To check try some other property, not ID.

[former_member623]

hi vadim

IIF([ENTITY].CURRENTMEMBER.PROPERTIES("ID")="PC_ASA",10,20)

-->above format throws an ujo read exception error .It doesnt work for PC_ASA also.

thanks

rekha

[former_member186338]

Try:

IIF([ENTITY].CURRENTMEMBER.PROPERTIES("ID")="PC_ASA",10,20)