Problem with executing MDX statement through XMLA and OLAP BAPI

[Former Member]

Here is link to original forum:

What can be wrong with such statement and how we can rewrite it to BW 2.0 supportable format.

SELECT

NON EMPTY [TS_PROJ].[LEVEL01].MEMBERS * [TS_RESRC].[LEVEL01].MEMBERS ON AXIS(1) FROM [TS_C01/TS_C01_NW001]

Any help will be rewarded.

[Former Member]

I rewrite it to

"SELECT " +

"NON EMPTY [TS_PROJ].[LEVEL01].MEMBERS * [TS_RESRC].[LEVEL01].MEMBERS ON ROWS, " +

"[Measures].MEMBERS ON COLUMNS " +

"FROM [TS_C01/TS_C01_NW001]";