Forum Discussion

blairzy1's avatar
blairzy1
Frequent Visitor
9 years ago

SAP BW connector invalid MDX command

I'm using: Power BI Desktop (April 17 release) I'm trying to connect to SAP BW using the now standard SAP Business Warehouse server connector. SAP NW RFC SDK 7.20 downloaded and extracted. The .lib a...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

blairzy1 I got the information internally that they suggest to enable product traces on the Diagnostics tab of the Options dialog and then repeat the operation which produces the error. Then, send us the trace files. 

 

Please follow above suggestion and capture trace and share it here.

 

Anonymous Please check if the trace file is captured as I told above. If not, please send me again.

 

Best Regards,
Qiuyun Yu

blairzy1's avatar
blairzy1
Frequent Visitor
9 years ago

Hi Qiuyun Yu,

I've PM'd you. Have you had a chance to push the files through to the team?

 

Regards,

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    blairzy1Anonymous Desktop trace files already sent internally, will updated here if I get information from PG.

     

    Best Regards,
    Qiuyun Yu

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi all,

       

      Please check below information from PG:

       

      The generated MDX is this:

       

      EXECUTE MDX |WITH MEMBER [Measures].[Microsoft.Mashup.Engine.NullMeasure] AS null SELECT [Measures].[Microsoft.Mashup.Engine.NullMeasure] ON 0,[0PLANT].[LEVEL01].ALLMEMBERS PROPERTIES MEMBER_CAPTION,MEMBER_UNIQUE_NAME ON 1 FROM [ZTAX_REG/REP_20120526_VATREG_TS_GST] CELL PROPERTIES VALUE| WITH-OPTIONS(IgnoreEmptyResultset=true, USEFLATTENING=TRUE);

       

      It turns out that "AS null" works correctly on some BW servers but not others.. As of the June release, we will generate different MDX that will avoid this problem, which should fix the issue.

       

      Best Regards,
      Qiuyun Yu