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.

SAP Datasphere

Working as designed. 

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

For access to Analytic Models through external clients, tools, and applications (beyond SAC or the SAP Excel Add-In), only OData access is supported. Refer to the official documentation.

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 form which you have modeled on the Analytic Model.

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 , KBA , DS-MD-AM , Analytic Model , Problem