1 Reply Latest reply on May 17, 2016 10:23 PM by Christian Berg

    How to use 'substring' MDX function for ESSBASE in BIEE Answer?

    User472204-OC

      Hi Experts,

       

      My BIEE version is 11.1.1.7.141014, and the datasource is ESSBASE.

      There is one requirement that I have to use the 'Substring' MDX function in BIEE answer, but I do not be good at MDX , when I use this 'Subtring' function , and it will generate the error message.

      Please tell me how to wriete the MDX in analytics. Thanks.

       

      PS: The formula is as below:

      EVALUATE( 'substring(%1.dimension.currentmember.member_name,%2,%3)' ,"Operation"."Store" ,'1','7' )

      Formula.JPG

      error.JPG