cancel
Showing results for 
Search instead for 
Did you mean: 

AUTHORISATION

Former Member
0 Kudos

Hi All,

Can anyone explain how we can give authorisations to columnwise in a report.

suppose a report is on multiprovider.

But some users should be able to see only few columns and unauthorised columns must be shown as blank or zero values.

Please help me reagrding this.

Thanks in advance!

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member206112
Contributor
0 Kudos

Hi,

Let's make a sample query: the query contains to key figures - quantity and price.

all users are allowed to see quantity and only few could see the price.

how to do that:

1. make sure 0TCAKYFNM infoobject is authorization relevant (BEx tab of the infoobject definition).

2. create 2 analysis authorizations using RSECADMIN that will consist of 3 infoobjects: infoproivder, time validity and 0TCAKYFNM. for the group that could see all key figures assign the two key figures under 0TCAKYFNM.For the group that can see only the quantity - create the second authorization with only quantity.

Assign those authorization through roles or personally to users.

Tomer.

Former Member
0 Kudos

restrictions on a query is done by restricting characteristics. not by rows and columns. well,one excemption, you can restrict the rows using S_TABU_LIN auth. object

for example, a query which is using 0plant infoobject, and for each column you have a plant, and rows might be whatever it is. then you can restrict users with the plant. which means if you want to make a user to see data for only first 3 plants( in your words, first three columns.) you can do it by creating RSR auth.object on 0plant. ask your security administrator about it mentioning on what characteristic you want the restriction.

Message was edited by:

Keerti Vemulapalli

Former Member
0 Kudos

Hi pallavi,

Please create a web interface query with a Table to hold all your columns.

Please search in SDN for

How toHide a Column in your Web Query with the Table Interface.pdf

and you will get this document and you can follow the same.

Hope this helps

Cheers

Raja