BI analysis authorization, checking for not equal to values

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

Use this link, its a presentation

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

regads

Shitika

[Former Member]

Dear,

Resolved.

Thanks