Forum Discussion

askrajeev's avatar
askrajeev
Helper I
4 years ago

SAP BEx Query and Power B

Hi Folks,

Working on SAP BW Power BI Dashboard

We are planning to use BEx Query as our source.

We got some 10 CKF's in Bex Query 

We enabled OLE DB for OLAP on BEx Query extended Tab

After enabling By OLE DB for OLAP, we getting message 

"Local Calculation is ignore when accessing using MDX"

 

Any one encountered this issue before, if yes any solution for the issue

 

Appreciate your response and time!

Thanks,

Rajeev

7 Replies

  • Hi Folks,

    Working on SAP BW Power BI Dashboard

    We are planning to use BEx Query as our source.

    We got some 10 CKF's in Bex Query 

    We enabled OLE DB for OLAP on BEx Query extended Tab

    After enabling By OLE DB for OLAP, we getting message 

    "Local Calculation is ignore when accessing using MDX"

     

    Any one encountered this issue before, if yes any solution for the issue

     

    Appreciate your response and time!

    Thanks,

    Rajeev

    • satishkondapell's avatar
      satishkondapell
      New Member

      Hi 

      can you provide the solution like how you fixed the error. Did you do it on Bex or in Power Bi side.

       

      Thanks

      Satish

  • Hi Liang,

    Appreciate your response!

    Quick question on the link provided..

    It talks aout variables ..is it related to CKF's and RKFs also

    Thanks,

    Rajeev

    • Anonymous's avatar
      Anonymous
      Not applicable

      How this got resolved?. Can you provide the details of the resolution?.

      Thanks

      Murali N