Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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?
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' )
0
Answers
-
Why use substring inside the EVALAUTE rather than just using the OBIEE function substring on the result itself?
0