The SQL generated in Web Intelligence (Webi) report query panel it shows that row level access restriction created at Universe are not applied. For Administrator it works well.
I found resolution:
Log on to LaunchPad with a user other that Administrator. Create a Web Intelligence report with the fields with access restrictions applied at Universe.
Note: Observe the SQL generated by the query. It does not show the restrictions applied (no ‘Where’ clause)
Cause
The user does not have enough rights on data access.
Resolution
Log on to Central Management Console (CMC). Go to Universes. Right click the Universe and select User Security. Select the user and click Assign Security. Click Advanced tab and then Add/Remove Rights. In Add/Remove Rights window on left hand side expand System and select Universe In right side pane it shows specific rights for Universe. Explicitly grant the Data Access right and Edit Access Restriction right ==============================================
I followed the instructions above, but the issue is still there.
Add comment