cancel
Showing results for 
Search instead for 
Did you mean: 

Partial data display based on access

Former Member
0 Kudos

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)

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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