topic Re: BI analysis authorization, checking for not equal to values in Application Development and Automation Discussions

BI analysis authorization, checking for not equal to values

Former Member — Mon, 22 Jun 2009 05:18:19 GMT

hello,

the info provider (ZIC_COPA) is having auth. relevant char. are 0COMP_CODE, PLANT, 0SALESORG.

When i am executing query which is built on ZIC_COPA info provider. It is checking all above charcteristics value. But in RSECADMIN i found that system is checking for not equal to values. For ex. please see below RSECADMIN trace. It is checking not equal to values for PLANT. does anybody know why it is checking NOT PLANT IN values??

0COMP_CODE

0PLANT

0SALESORG

SQL Format:

COMP_CODE IN ('1000',,'3200')

AND NOT PLANT IN ('1000','3200')

AND SALES

ORG IN ('1000',','3200',')

AND TCAACTVT = '03'

Note: There is no hardocoding or exclusion values in the query.

Regards

Imran

Re: BI analysis authorization, checking for not equal to values

Former Member — Mon, 22 Jun 2009 18:09:21 GMT

Hello imran,

check couple of things first; In your analysis authorization you have to assign # sign so if there is no data then # will be assigned and you will not going to have any error.

Second check your analysis authorization for CP, BP what you put and change some the values

Best Regards,

Faisal

Re: BI analysis authorization, checking for not equal to values

Former Member — Fri, 26 Jun 2009 08:30:13 GMT

Use this link, its a presentation

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/659fa0a2-0a01-0010-b39c-8f92b19fbfea

regads

Shitika

Re: BI analysis authorization, checking for not equal to values

Former Member — Tue, 28 Jul 2009 10:50:48 GMT

Dear,

Resolved.

Thanks