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

Essbase SOAP XMLA converts right square bracket into blank and throws an exception

Question
8
Views
0
Comments
edited Aug 2, 2018 2:36AM in Essbase

Summary

Essbase SOAP XMLA converts right square bracket into blank and throws an exception

Content

Hi,

I am getting data from an Essbase Cube through SOAP XMLA Java application.

It works for all kinds of queries except for subqueries. The cube is created using ASO (Aggregate Storage Model) which supports subqueries.

This is my SOAP XMLA MDX Query:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

<SOAP-ENV:Header/>

<SOAP-ENV:Body>

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">

<Command>

<Statement>

SELECT { [Measures].[Price],[Measures].[Amount] }  ON COLUMNS  ,

NON EMPTY (  SUBSET(  Descendants ( [Country model hierarchy], [Country model hierarchy].Levels(0), SELF_AND_BEFORE ) ,0,1000) )  ON ROWS 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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