SAP BEx Query and Power B

[askrajeev]

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

[askrajeev]

you can ignore it ..its not really error its just warning

[askrajeev]

It got resolved

Thanks All!

[ngmurali23]

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

Thanks

Murali N

[askrajeev]

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

[V-lianl-msft]

Hi @askrajeev ,

Sorry, I have little experience in this field See if this thread can help you:

https://answers.sap.com/questions/7600791/bex-variables-ignored-in-mdx-query.html 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[askrajeev]

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]

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