Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User472204-OCMay 17 2016 — edited May 17 2016

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' )

Gary Graham-Oracle

Hi Dylan,

There is currently one bug involving reports and parent-to-child bind variables open against 4.0.1. It says nothing about a chart versus a table, so perhaps your issue is different, but nevertheless I have referenced this discussion in that bug so the appropriate developer will be forewarned.

Of course, it would help even more if you could provide a detailed test case including table structure DDL, the data, and the report definition.

Regards,
Gary

SQL Developer Team

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2016

Added on May 17 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

290 views

Analytics Software

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

Comments

Post Details