Skip to Content

MDX FORMULA - HIERARCHY ERROR

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jan 12 at 10:17 PM

    it works after changing formula as Below:

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2017 at 07:23 PM

    Try:

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2017 at 08:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2017 at 09:15 PM

    To check try some other property, not ID.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2017 at 09:34 PM

    Other properties works fine..Only ID not working

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2017 at 07:39 AM

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

    Add comment
    10|10000 characters needed characters exceeded