SQL Analytic Privileges (using SQL Editor)

[Former Member]

Hi,

I'm trying to apply SQL Analytic Privileges (using SQL Editor) on a Basic Calculated View (CA1). AP's are working fine and the restrictions are being applied as expected at DB level. But the BOBJ explorer report created on the Calculation View (CA1) produces below error

'feature not supported: this query cannot be handled in OLAP engine (e.g., due to join), so options in the grouping-sets clause cannot be supported'

Code used in SQL Editor (SQL AP)

"SALESORG" IN (SELECT DISTINCT SALESORG FROM SCHEMA.USER_TABLE WHERE USER_ID = 'MYUSERID' AND ATTRIBUTE_NAME = 'SALESORG')

Note: As per this SAP Note : https://apps.support.sap.com/sap/support/knowledge/preview/en/2146672 , checked using Analytic view as well but didn't work.

Please share your inputs/suggestions on it. Thanks in advance.

Regards
Sai

[vikram_kate]

Hi

Any luck with this Sai ? We are facing same issue - OLAP query somehow does not accept SQL APs.

Thanks !