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

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