Skip to Content
0

SQL Analytic Privileges (using SQL Editor)

Apr 06, 2017 at 05:14 AM

67

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers