You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OBIEE substring for essbase dimension

edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

OBIEE substring for essbase dimension

Content

Hi

  I am trying to use substring for an Essbase dimension. I understand that I need to use Evaluate function along with essbase MDX function subsrting. But I am not able to make it work. I am getting either syntax error or error like this..

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 2 at token 'Substring' (HY000)

Can anyone point to proper syntax/ way to get it work Please?
Appreciate your help on this.
Thank You
Arijit

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!