Skip to Content
0
Jun 15 at 07:13 AM

Filter value in RS2HANA_AUTH_STR table wrong

236 Views Last edit Jun 22 at 06:07 AM 3 rev

Hi all,

We have replicated BW Analysis Authorizations to SAP HANA via RS2HANA_GEN.

When checking the generated values in RS2HANA_AUTH_STR, we have identified some kind of syntax error for one authorization.

Generated Value:

"0INFOPROV" LIKE '2H%' OR "0INFOPROV" LIKE 'CPBD%' OR "0INFOPROV" LIKE 'CRM%' AND ("0USERNAME" IN ('USER1234'))

In my point of view the brackets resp. the AND/OR operators are not correct here.

According to the BW Analysis authorization the value should be:

( "0INFOPROV" LIKE '2H%' OR "0INFOPROV" LIKE 'CPBD%' OR "0INFOPROV" LIKE 'CRM%' ) AND

"0USERNAME" IN ('USER1234')

In the generated value the AND condition for 0USERNAME is just relevant for the last OR condition (LIKE 'CRM%' ).

This is caused by missing/worng brackets. Our expectation is that the AND condition is valid for each individual OR condition.

Could anyone observe the same behaviour?

We use one BW analysis authorization where the 0INFOPROV contains the objects mentioned in the created VALUE.

Thanks and best regards

Stephan