Accessing query from Qlik/Tableau/PBI

[former_member584656]

Hi all,

i've got a query over a Composite Provider with external Access enabled.

The query Works perfect on AFO and RSRT.

When i display data on any external tool (QV, Tableau, PBI) it still Works fine until i show some characteristics, this make the whole result data dissappear.

This happens on PRD but not on QAS.

I checked every object on BW and HANA and is everything identical in all systems.

I've checked every trace option on BW and HANA and no error message to explore.

Any tips to solve this ?

Thanks in advance

JP

[TammyPowlas · Accepted solution]

Juan - my understanding is these tools use MDX to access BW; I recommend reviewing this wiki and perform some troubleshooting: https://wiki.scn.sap.com/wiki/display/BI/OT-MDX