How to Apply Row level restrictions On objects

[Former Member]

Hi All,

I am working on universe designer(BO 3.1) .....

I would like to apply row level restrictions on a cloumn of table based on the user who is running the report .

can any one please help me on this..

Thanks in Advance.............

[Former Member · Accepted solution]

You would do this in BOXI 3.1 through the manage security -> Manage access restrictions option

Create new restrictions and then apply them to the users or groups as per the dialog box.

The alternative method is to use the @Variable('BOUSER') restriction but this assumes a certain set up within the database itself, i.e. that each row has an owner. It lends itself to a very specific type or reporting and in general the method that I suggested first is easiest to apply and maintain.

Regards,

Mark

[former_member4998]

Hi

Universe access and row-level security can also be managed at the group or individual user level from within the design environment.

Find the below video row level restrictions

http://www.youtube.com/watch?v=6yM0OLK6QlI

Create a data security profile that restricts access to specific rows: Information design tool 4.x -...

And You cannot set row-level security authorizations in an OLAP universe.

User security can be defined at the most granular level for the following content objects.

• Folders and sub-folders
• Reports
• Categories
• Events
• Program Files
• Publications