My BIEE version is 184.108.40.206.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' )
Why use substring inside the EVALAUTE rather than just using the OBIEE function substring on the result itself?