OBIEE substring for essbase dimension
Summary
OBIEE substring for essbase dimensionContent
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
0