3101904 - Errors or incorrect results when selecting data from database views like 0BW:BIA:* of the BW schema

When executing a query on database views like 0BW:BIA:* of the BW schema incorrect results are displayed or the query fails with errors.

Error messages can be various like:
SAP DBTech JDBC: [2048]: column store error: search table error:  [34023] Instantiation of calculation model failed;exception 306002: An internal error occurred

OR

column store error: search table error: [2712] olap: merging multi value dicts is not implemented, please make sure the following join cardinality is modeled correctly (did you use 1:1 when the data really is 1:N or N:M?);BwPopJoin1Inwards pop285

OR

A calculation view based on a view like 0BW:BIA:* of the BW schema fails with similar errors.

SAP BW on HANA
SAP BW/4HANA

HCPR, ADSO, error, execute sql failing , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-BEX-OT-DBIF , Interface to Database , BW-WHM-MTD-HMOD , HANA Model Generation in BW , BW4-ME-HMOD , HANA Model Generation , Problem