on 12-21-2010 3:12 AM
We have activity (transaction) type hierarchy and based on this we will users to have access.
e.g.
L1 - Global head
L2 - Continent head
L3 - Country head
L4 - City head
If Global head is viewing the report then hierarchy should start from L1 where as if Country head is viewing the report then hierarchy should start from L3 (can't see any level up but can drill down) and so on. Can this be achieved in WebI via Universe
2) User wants to display the data based on access
L1 L2 L3 L4 Revenue Volume
a- Senior management will view complete data
b- Operations mgt will view Volume data for only L4 (when expanded) and blank for other countries
c- Operations mgt will view Volume data for few L4 (based on access)
Hi,
This is effectively possible to achieve this in universes.
You can create one class of levels per profile and apply authorizations in universe in order to respect the data access you want.
For example:
Class A:
<li>L1 - Global head
<li>L2 - Continent head
<li>L3 - Country head
<li>L4 - City head
Class B:
<li>L2 - Continent head
<li>L3 - Country head
<li>L4 - City head
Class C:
<li>L3 - Country head
<li>L4 - City head
Class 😧
<li>L4 - City head
You can also apply data security in addition to metadata security in order to restrict the Revenue Volume.
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You're looking at access restrictions within the universe based on group membership and the individual user.
Restrict objects based on group membership
Restrict rows based on user name
Both are covered in the universe designer documentation. The latter will probably be driven based on a restriction in the country table something like:
Country.CountryManager = @Variable('BOUSER')
@Variable('BOUSER') translates the user name, so make sure you have the correct name in your country table depending upon the authentication you are using (Windows AD, Enterprise, etc.)
If you get stuck, shout up.
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.