To restrict a object to a particular Group at the Universe level

[Former Member]

Hi,

I have a object which should be restricted only to a particular group at the universe level.So when i define the universe we have to have explicit security that will restrict access to this object information from reports and from ad-hoc queries.I should restrict the object only to the particular group by a role based security.

Please help me out in this case.

Thanks in advance,

Madan

[Former Member · Accepted solution]

Hi Madan,

Please follow the below steps:

(In Designer)

1) Open Island Resort Marketing universe or any universe in Designer.

2) Goto Tools -> Manage security -> Manage Access Restrictions.

3) Click on New option - > Give the Restriction name - >click on Rows tab - > Click on Add button (New Row Restriction window comes) -> give table name For example:"Resort_Country" in the Table text box, under the Where Clause "Resort_Country.COUNTRY = @Prompt ('Which country?u2019,u2019 A',, MONO,FREE)"-> Click OK -> Click Ok.

4) Click on Add user or group - >Select the user ->Ok.

5) Click on Apply -> Click OK.

6) Save the universe and export it into the repository.

7) Cretae the new report (webi/deski) from the user the one who belongs from this group.

Hope above steps will helps you.

Regards,

Deepti Bajpai

[Former Member · Accepted solution]

Hi Deepti,

Thanks for your reply and will try the same and get back if any issues.

Thanks again,

Madan

[Former Member · Accepted solution]

Can u please tell me how can i restrict a filter from a particular group?

[Former Member · Accepted solution]

Filters or Funnels cannot be restricted in Manage Access Restrictions