just tried to configure step by step SAP Modelling Guide to create an authorization scenario for a consumption model.
But if i try to apply the authorization scenario on a consumption model i am not able to save because of this error:
Correlation ID: f525bb90-489c-4d53-62c4-9ff50ed3fdcd
HTTP Status: 500 Internal Server Error
Error Code: 257
Technical Message: sql syntax error: incorrect syntax near "[": line 1 col 195 (at pos 195), Code: 257, SQL State: HY000
Based on the Demo Content I create a Data access control to restrict the employee table through Employee ID
I created 2 Business Entities Dimension Employee and an analytical dataset salesorders
applied on both business entities the authorization scenario and in the data preview everything is fine.
creating a consumption model and applying the scenario i'll get this error. Is this a bug or do i miss something.
thanks for advice greetings cornelius