Comments in OLAP Query

[Former Member]

I have tried unsuccessfully to use the traditional comment indicators (--, // or /../) in the MII OLAP Query Template. Can any one offer any insight ? We are running xMII 11.5 Thanks

Edited by: Gary Wilson on Mar 18, 2010 4:17 PM

[jcgood25]

According to MS: http://msdn.microsoft.com/en-us/library/ms145560.aspx

and

This blog: http://www.databasejournal.com/features/mssql/article.php/10894_1495511_3/MDX-at-First-Glance-Introd...

You've tried the ones they show...

It is possible the OLAP cube source or connection has a back-end specific syntax?

What was the error?

[Former Member]

The error returned is:

com.lighthammer.webservice.SoapException: The XML for Analysis provider encountered an error

The query below runs successfully without the comment. I have tried using all 3 comments types, all yielded the error. I also tried using them different places in the query and all yield the error above.

SELECT

{

[Measures].[4H6FMCTGVWP1OONPFSU60LPHL],

[Measures].[4H6FMD15EVAR7B75LMWIANO7D],

[Measures].[4H6FMD8TXTWGPXQLRGYUKPMX5],

[Measures].[4H6FMDGIGSI68KA1XB16URLMX],

[Measures].[4H6FMDO6ZR3VR6TI353J4TKCP],

[Measures].[4H6FMDVVIPPL9TCY8Z5VEVJ2H],

-- [Measures].[4H6FME3K1OBASFWEET87OXHS9],

[Measures].[4H6FMEB8KMX0B2FUKNAJYZGI1],

[Measures].[4H6T8MSDUVPDDCUKTO2LASITL],

[Measures].[4H6T8N02DUB2VZE0ZI4XKUHJD]

}

ON COLUMNS,

NON EMPTY

{

[ZBRSPPLNT].MEMBERS

}

ON ROWS

FROM

[Z_SD_C33/Z_Z_SD_C33_Q0127A]

SAP VARIABLES

[Param.1]

[ZCYTCMC] INCLUDING "[Param.2]":"[Param.3]"

[Param.4]

[Param.5]

~~~~~~~ End of query ~~~~~~~

Param.1 = [ZS_RPLTC] INCLUDING "[P145]" [ZS_RPLTC] INCLUDING "[P146]" [ZS_RPLTC] INCLUDING "[P151]"

Param.2 = 05/2009

Param.3 = 05/2009

Param.4 = [ZS_CATGY] INCLUDING "[C]" [ZS_CATGY] INCLUDING "[G]" [ZS_CATGY] INCLUDING "[W]"

Param.5 = [0SALEORG] INCLUDING "[BP01]" [0SALEORG] INCLUDING "[CR01]"

~~~~~~~~ End Params ~~~~~~~

Notes:

We are using SAP BI 7.0

While the above query is only using the "---" the same error is returned if either of the comments indicators are included.

I'm sorry the test editor doesn't seem to like the code.... especially the strike through. That and the liks are unintended.

Thanks for taking the time to review our issue and offer suggestions

Edited by: Gary Wilson on Mar 19, 2010 12:31 PM

Edited by: Gary Wilson on Mar 19, 2010 12:34 PM

[jcgood25]

You might also try one of the BI / BW forums here on SDN to tap into the knowledge / experience of the MDX query gurus.

Aside from the Param.x substitutions I don't think the MII query does much to the query string other than send it to the cube, so the syntax should be normal stuff.

[Former Member]

Thanks for the suggestion.... I search the BW/BI forums as well

[salvatore_castro]

Try to login to your BI system via SAP GUI and goto transaction code: MDXTEST

Run your MDX there an see what error messages and information you get from there. It will be more helpful than the MII Query template.

Hope this helps,

Sam