Getting error "No applicable data found " while executing BI query in both Bex and Portal

[Former Member]

Hi All

I am from SAP Security background, users are getting "No applicable data found " while executing query for particular selection.
There is no issue users who are having * access and we also checked with BW functional team,they informed that they are able see data and data is exist in cubes.

User is having access for that particular selection, even in trace also it is not showing any access issue. Moreover user was able to execute report with same access and suddenly this error is coming.

Please help me to sort out this issue.

[former_member242638]

Hi,

I would suggest to run both trace ST01 and RSECADMIN and see if there is something failing as per user's report execution. Still if you don't see anything in the trace then sit with BW consultant to find out if user is executing the reports correctly with right selection of parameters.

Also try to execute the report from your id and run the RSECAMDIN trace with different value of variables.

Hope it would help.

Thanks,

Varun