topic Analysis Authorization for nav Attr Issue in Application Development and Automation Discussions

Analysis Authorization for nav Attr Issue

Former Member — Thu, 07 Feb 2008 15:19:44 GMT

Hello:

I have a 0COMP_CODE as an attribute of 0SALSORG and it is marked as authorization relevant. i.e 0SALESORG_0COMP_CODE is authorization relevant.

I created an analysis authorization Object ZCOMPCODE_1000 by adding following in it.

InfoObject Value

0COMP_CODE = 1000

0SALESORG = *

0SALESORG_0COMP_CODE = 1000

0TCAACTVT = *

0TCAIPROV - *

0TCAKYFNM = *

0TCAVALID = *

Now I have a report on a cube which has 0SALESORG as char and also 0SALESORG as a variable on selection.

When I run a query for sales org = 1000, I can see rsults as sales org 1000 is assigned to company code 1000.

If I run report for sales org 2000, I should get not authorized message as 2000 is not assigned to company code 1000 and I only have a role assigned to me which has analysis authorization object ZCOMPCODE_1000. But Still I am getting report results.

Please explain Why and How can I overcome this issue.

Thanks

Re: Analysis Authorization for nav Attr Issue

Former Member — Thu, 07 Feb 2008 16:01:52 GMT

First of all it is strange that we see two appearances of sales org.

0SALESORG = *

0SALESORG_0COMP_CODE = 1000

Probably the star value overrides the setting in the second one.

Besides did you create the variable in the query as authorization relevant or you will have problems there.

Re: Analysis Authorization for nav Attr Issue

Former Member — Thu, 07 Feb 2008 16:14:16 GMT

0SALESORG = * is a value for sales org

0SALESORG_0COMP_CODE = 1000 is a value for the company code.

Re: Analysis Authorization for nav Attr Issue

Former Member — Thu, 07 Feb 2008 16:36:39 GMT

Hi Tridev,

are you seeing the data for only the company code 1000, when you select either sales org equal to 1000 or 2000.

Thanks.