BI Analysis Authorization

45 Views

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