3679184 - Data disappears after applying additional filter on a dimension in Analytic Model

• After changing the filter selection for specific dimension, the preview output becomes blank or
• Preview becomes blank, after readding the dimension to drill down
• Console shows the following error: library-preload.js:429 Uncaught (in promise) TypeError: Cannot read properties of null (reading 'getIterator').

• Analytic Model

• The issue occurs due to an incorrect data type conversion in the model. Some columns have inconsistencies between the design-time data type defined in the editor. For example, if a column is defined as Date, but SAP HANA Cloud interprets it as String, this mismatch can cause runtime errors or incorrect data to be returned.

1. Execute Data Validation for the base view. Refer to Help Portal - Run a Data Validation
2. Identify the base view where the incorrect conversion occurs
3. Convert fields properly using functions such as `TO_DATE`
4. Apply the correction to the base view
5. Validate the changes
6. Deploy the view and Analytic Model

Help Portal - Column Data Types

Help Portal - Data Types

analytic model, contract date filter, data disappears, incorrect date conversion, runtime error, TO_DATE function, preview output blank, data type mismatch , KBA , DS-MD-AM , Analytic Model , DS-MD-VIW , Views , Problem