Skip to Content
avatar image
Former Member

SQL Analytic Privileges (using SQL Editor)

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 09 at 09:12 AM

    Hi

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

    Thanks !

    Add comment
    10|10000 characters needed characters exceeded