BI Analysis Authorization

Former Member — Mon, 29 Aug 2011 15:24:02 GMT

Hi ALL,

When query executes it should provide data for Company code[0COMP_CODE] "A" and all Plants [0PLANT]under that company code "A" .

Now these queries have been designed using 0COMP_CODE and 0PLANT which are characteristics of a Infoprovider "ZINFO"

The O/p data of the Compant Code "A" needs to be Drilled Down based on PLANTS under the comapany code "A".

AUTHORIZATION CONTAINS 0COMP_CODE = A ; 0PLANT as ":"

When the query executes, it qives an AU error .

The query Execution log shows 0plant is taken as * ; COmp COde is taken as A .

This above selection set is compared with AUTHORIZATION SET which CONTAINS

0COMP_CODE = A ; 0PLANT as ":" .

Hence log shows 0PLANT missing value of "*".

Please let me know How can a company code and plant level restriction be achieved based on

0COMP_CODE and 0PLANT without giving 0plant as *.

Also please let me know if use NAVIGATIONAL ATTRIBUTES can help to so so?

Thanks and Regards.

Ajit

Re: BI Analysis Authorization

Former Member — Mon, 29 Aug 2011 17:12:30 GMT

Hi Ajit,

The plant should be in the free characteristics but not in the rows or columns. Check the Query. If the plant is included in the row or column, the aggregations will not work as expected.

I recommend you to go through the SAP notes 1140831 which explains using : (colon) authorizations.

Also, SAP note 1337102 and 1053989 should help you further.

Hope this helps!!

Regards,

Raghu

topic BI Analysis Authorization in Application Development and Automation Discussions

BI Analysis Authorization

Re: BI Analysis Authorization