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

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
User472204-OC
User472204-OC Rank 5 - Community Champion

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Why use substring inside the EVALAUTE rather than just using the OBIEE function substring on the result itself?