Restriction Set - allow mulitple prompt values

building semantic layer
1

In my webi report I have multiple prompts for offices some BO groups need to access 1 and only 1 office while other BO groups need to access more than 1 office. The restriction sets I have setup in the universe work for the BO groups that need to access 1 office however it does not work for users in BO groups that need to access more than 1 office.

I have setup restrictions for each office then link them to a BO group some of the same users belong to more than 1 BO group. Most groups only need to access one office in the prompt other users need to access multiple prompts. The way its setup for the users who need to access multiple prompts is to add them to the BO groups that are already linked to a restriction.

e.g.

prompt values:

  • office 1
  • office 2
  • office 3

BO groups:

  • BO group 1
  • BO group 2

I can get it to work like this:
a user in BO group 1 can access office 1. But if I wanted a user in BO group 2 to access the prompt values for office 1 and office 2 it doesnt work when anyone from BO group 2 logs into infoview at the prompt they will get no values at all.

Anyone know how to fix this attached is more detail
Restriction Sets.doc (89.0 KB)

ilbo :australia: (BOB member since 2008-10-09)

2

Apologies but I don’t like downloading files so have not read the attachment.

The restriction you have set up does this allow access for the specific group or does it deny access to all other groups?

I am assuming that the same universe is being used which begs the question is the combination of access restrictions causing them to create an impossible combination e.g.

where access = group1 AND access=group2

You can set access restrictions to combine using OR if this is the case alternately if this is impractical when other restrictions are taken into account, you could set up a third group allowing access to both and move the users from the individual groups into the both group.

I hope that makes sense…

clg :uk: (BOB member since 2009-09-23)