3674874 - Analytic Model will not be visible anymore to users accessing via ODBC / JDBC in SAP Datasphere

• After redeploying an AM, its views are no longer available for consumption via ODBC / JDBC with OpenSQL Schema.
• All newly deployed Analytic Models are no longer accessible to Open SQL Schema (ODBC/JDBC) users.
• Existing models that are modified and redeployed are no longer be accessible for consumption.
  
  When you attempt to read internal view's based on AM with an Open SQL Schema DB user, you get:
• Could not open '<VIEW_BASED_ON_AM>'.
  Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid 'XXXXXXXXXXXXXXXXXXXXXXXXX'.

SAP Datasphere

Working as designed. 

Analytic Models were never intended to be consumed via Open SQL schema (ODBC/JDBC).
It was possible due a bug, and after the fix was introduced, the re-deployment of AM object causes its internal views to no longer be visible for ODBC/JDBC consumption.

This restriction exists because the artifacts accessible via ODBC did not represent the complete Analytic Model as designed in Datasphere. 
These models require processing through HANA Multi-Dimensional Services (MDS) to generate accurate results and are not merely database views.
This could generate unexpected results, missing columns, and wrong functionality from which you have modeled on the Analytic Model.

Modeling adjustments

The supported approach
For access to Analytic Models through external clients, tools, and applications (beyond SAC or the SAP Excel Add-In), the supported access is via OData API. 
Refer to the SAP Datasphere Help documentation.

Limited alternative
In case source fact view or dimensions provide you suitable data (no restricted measures, no texts, no aggregation... and many other AM functionalities), check if enabling flag "Expose for Consumption" satifies your business requirements. Then consume the exposed view via ODBC/JDBC.

Check out How to consume OData API in Power BI and other clients from SAP Datasphere Support Content.

DWC, DSP, DS, database user, db explorer, database explorer, insufficient privileges, power bi, PBI, HANA ODBC: General error, 258 insufficient privilege, consumer role standard, , KBA , DS-MD-AM , Analytic Model , Problem