3746515 - SQL view creation fails with invalid_csn when consuming a view with applied data access control via association

• Creating a standard SQL view that selects from a fact view in the same space fails.
• Validation returns an error message showing only the source view name, with no further details.
• Network response includes a JSON message with only the source view name.
• Backend stack traces include “Compile failed with: INVALID_CSN”.
• Error detail contains “Unsupported usage of derived data access control”.
• Logs may include “ServiceWorkerExecutionError”.

• SAP Datasphere

1. Open the target space in Data Builder.
2. Create a new SQL view.
3. Enter SQL such as: SELECT * FROM "xyz".
4. Validate or save the SQL view.
5. Observe that validation fails and the message shows only the source view name.

A validation defect occurs when creating SQL views that consume views which apply Data Access Controls derived from an associated dimension, leading to INVALID_CSN (“Unsupported usage of derived data access control”).

1. Identify the association(s) in the source view where “Applied Data Access Controls” is enabled and DAC is propagated from an associated dimension.
2. Temporary workaround A: disable “Applied Data Access Controls” for the problematic association to unblock SQL view creation (only if acceptable for your scenario).
3. Temporary workaround B: create a graphical wrapper view on top of the source view and have the SQL view consume the wrapper instead.
4. Permanent fix: a correction is planned for an upcoming release (planned for release 2026.11). Monitor availability and revert temporary changes after the fix is delivered.
5. Revalidate or recreate the SQL view and confirm it saves successfully.

refer to: Planned wave availability and fix delivery schedule

refer to: How to create a Support User in SAP Datasphere

sql view creation, invalid_csn, data access control, dac, derived dac, applied data access controls, associated dimension, association, compile failed, validation error, serviceworkerexecutionerror, select from view, data builder views, sql view fails, datasphere , KBA , DS-SEC-DAC , Security – Data Access Control , Problem