Could someone please let me know if the authorisations scenario presented below is possible?
Scenario:
A user has access to only see 0PLANT A001.
(note: in RSECADMIN, an analysis auths object has been created with the below values – ie including colon)

In reporting, without Plant being in the rows of the query, the user should be allowed to see the “aggregated” amount – eg total sales at Company Code level. But when drilling down by Plant, he will then automatically be restricted to only A001 (as per "Expected Result" tables below)
Issue:
All is ok if Plant is not in the rows – eg if viewing data at the aggregated Company Code level, the user can see the total sales value across the business
But when adding Plant to the drilldown, the message “User does not have authorization” is returned.
Only if the user then filters on Plant = A001, will the result set return with just A001.
Can anyone tell me if the “Expected Result” is possible with analysis auths – ie the report automatically restricts to A001 without the user having to manually filter?
