1577385 - Cannot add objects in Explorer with duplicate column names from HANA 1.0

Symptom

Cannot add objects in SAP BusinessObjects Explorer4.0 Information Space that have duplicate column names from HANA 1.0

Environment

SAP BusinessObjects Explorer 4.0
SAP HANA NewDB 1.0

Reproducing the Issue

1. Create an Analytical View inside In Memory Computing Engine (IMCE)/NewDB HANA. The data foundation of the analytical view consists out of three tables, where two of them has a column with the same name (column name is "description"). In the output structure, rename one field to "descripton_1" for clarity to avoid conflicts
2. The activation of the analytical view is successful. The data preview of this analytical view is successful. Also, the two columns are displayed once with name "description" and once with name "description_1" as expected
3. When we connect the SAP BusinessObjects Explorer 4.0 against the NewDB (HANA) and try to create an Information Space, all attibutes are shown for selection.
However, it is not possible to include both fields, namely "description" and "description_1" and drag them into the Explorer 4.0 Information space.
It seems that the Explorer 4.0 handles them as if they are the same field and only allows one of them

Cause

A Naming Convention Issue has been identified within SAP IMDB / HANA 1.0 engine

Resolution

New naming convention has been introduced by SAP HANA In Memory Computing Engine (IMCE) Revision 4
refer to following KBase
Note 1570923 - SAP IMDB modeling: column naming in generated column views
Follow steps to apply Revision 4 for SAP HANA In Memory Database (IMDB) and Modeler

Keywords

IMDB IMCE NewDB HANA Explorer Polestar 4.0 Aurora same name