Skip to Content

Row level security is not applied in Webi report

Hi All,

I have an issue

Environment - Business Objects 4.2 SP 3

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.

May i get any help to resolve above issue.

Regards,

Jeet

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 11, 2017 at 12:14 PM

    Hi Jeet ,

    We observed similar kind of issue on 4.2 update . That time we resolved it by , opening , refreshing the document and saving it back to platform .

    Not sure this helps !! did you try recreating restriction at universe

    Regards

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded