/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
When consuming SAP Datasphere's data via ODBC connection, for the header of each column, it displays the "Technical Name" instead of "Business Name".
Like below, the head of column is 'date'.
In SAP Datasphere, the "Technical Name" of the field is 'date', whereas the "Business Name" of the field is Japanese.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Datasphere
Reproducing the Issue
Check data from SAP Datasphere (for example, Business Builder) via ODBC connection and display on client (for example, MS Access).
Cause
The technical name is the value of the database field - which is shown from the ODBC connection as well.
The business names were added as label information in underlying database but this may not be transferred via ODBC towards the ODBC client.
Resolution
System behavior. See above cause for explanation.
Keywords
Microsoft, Access, power bi, pbi, tableau, powerbi, dwc, data warehouse cloud , KBA , DS-BB , Business Builder , Problem
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)