Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

BI Analysis Authorization

Former Member

‎08-29-2011 4:24 PM

0 Kudos

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

1 REPLY 1

Former Member

‎08-29-2011 6:12 PM

0 Kudos

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