No data to retrieve. Query 1 (Webi ERROR)
I need urgent help with this (and I hope you can help me) I’m trying to build a Webi Report based on Bex Query. I created an OLAP Connection using the Information Design Tool. Also my Bex Query has checked the OLAP option.
When I build the Webi Report, I can select the Bex Query ratios and dimensions in order to put it into the result panel, however, when I run the query (in Webi) the error comes up and it says:
No data to retrieve. Query 1.
This is weird because, when I execute the Bex Query vía RSRT I get the results fine. But, when I build the Webi Report I don't get the results and the error says "No data to retrieve. Query 1" even when I have data for this Bex Query.