Skip to Content
0
Apr 06, 2017 at 07:18 PM

MDX FORMULA - HIERARCHY ERROR

209 Views

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