Query Security issue

[former_member522740]

hi gurus

we have this query that has some senstive Cost center info, now we want the users to be able to run the query on all the sensitve cost centers and non-sensitive cost centers, but not be able to physically see "Senstive" cost centers, but at the same time are able to see non-sensitive costcenters info in the report, is it possible to do that? if so how?

Example:

ProfitCenter Amount

100 20$

200 30$

300 55$

105$ Total

adding all the amounts up gives you 105$ now if Profit Center 300 is a senstive PC i dont want the user to be able to see that PC 300 is assigned 55$ in the report in BEX. but i want it to be counted in the total amount(105$).

thanks

[former_member522740]

THANKS

[Former Member]

You could do this using Reporting Authorization Object on Cost Center.

[former_member522740]

thanks for the reply , but i was wondering how would i assign everything to a user but remove access to PC 300. i am some what aware of the pfcg tcode i know i will have to maintain a profile for this.

i beleive * means full authorization

how do i remove access to just one PC300 and assign everything else to the profile.

[Former Member]

You will have to give Authorizations for Individual Cost Centers .

null

[Former Member]

you can do it by creating a selection for Sensitive Cost centers and Hiding them. Change its setting to Always Hide. and add it in a single fromula.

Like say 300 is your sensitive pc.

create a structure in col, make new selection and add all sensitive cost centers in that.

Right click -> properly and select always hide.

create new formula and add that selection.

So, once all non-sensitive pc will be displayed, all the sensitive pc will be clubed in one formual and will be displayed in the last row of the report.