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.

[john_hawk]

Hi Madhu,

My guess would be that you have recently modified (or imported a transport) a change to the security profile for most BW users.

This change resulted in no matching data ( Company Code = 1000 AND Company Code = 2000) vs. (Company Code = 1000 OR Company Code = 2000) . The first would have "no applicable data", the second would return data.

Have a BW resource review the profile to insure the the profiles are not overrestricted.

John Hawk

[Former Member]

Hi,

Did you checked query execution in RSECADMIN (running query in RSRT in user context) ?

best regards,

Wojtek

[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

[RamanKorrapati]

Hi,

No Applicable data found - mean the selections which is entered by user does't have data at bw target level or user may be passing wrong format input values. please take bw consultant help and check the user input values which is he/she is entering.

Thanks

[former_member186053]

Hi Madhu,

Ask user to access same report in his/her colleagues machine with his/her credentials. Does user has personalized variables saved for that report, if yes delete personalized variables and try to run query freshly.

Did you check user authorization in BW system using RSECADMIN t/code for that particular report with same selections.

Thanks,

Vengal.

[Rajesh_Naik]

Hi Madhu,

Was there a change in the design of the report?

Thanks,

Rajesh