on 11-08-2007 6:07 PM
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.