OBIEE substring for essbase dimension
SummaryOBIEE substring for essbase dimension
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)