12 Replies Latest reply: Mar 21, 2013 4:17 PM by user617249 RSS

    How to check if the member exists in essbase cube using IF cond.

    user617249
      Hello,

      I have a requirement to validate certain accounts and if they exist or not and use them in calc. We have certain list of percent accounts which have some driver amounts. If the user selects the parent account, it should automatically calc with percent accounts to generate the values for all its children.

      The issue is we have lots of accounts and lots of percent accounts, its not that all accounts have the percent accounts. thats the problem.

      When I Fix at a high level of accounts, am getting this error which says that member doesnt exists and return empty member set.

      Error executing formula for [Revcnt] (line 49): attempt to cross a null member in function [@X]

      Its the same even if I use Set Emptymembersets ON;

      The script is below,

      FIX(@Relative({SelectAccount},0),

      "Revcnt"(
      IF(@ISMBR(@MEMBER(@CONCATENATE(@NAME(@CURRMBR("Account")),"%"))

      Condition ;

      ENDIF);

      ENDFIX

      Is there a command to validate if the member exists in the cube or not???

      We are using 11.1.2.1 Essbase on Windows 64bit.