3638685 - Missing Value From Fact View in Analytic Model Filter Search

• Value from the fact view does not appear in the Analytic Model filter search, but the same value from the dimension is displayed.

• SAP Datasphere

1. Access the Analytic Model.
2. Click on "Preview".
3. Input the required parameters for the Analytic Model.
4. Move the affected Dimension into rows.
5. Apply a filter and search for a value "1234" - it is visible and sourced from the dimension.
6. Apply a filter and search for the value as it is recorded in fact view "0001234" - it is not visible, though it is part of the underlying fact view.

• The issue arises due to inconsistent values between the fact view and dimension tables.

1. Adjust the values in the fact and dimension tables to ensure consistency. Both tables should have the same value, either "1234" or "0001234".
2. Perform the adjustments manually or use SQL functions to align the values.
3. Validate the changes by reapplying the filter in the Analytic Model and confirming that the fact view data is now visible.

analytic model, fact view, dimension view, filter search, missing data, inconsistent values, filter , KBA , DS-MD-AM , Analytic Model , DS-MD-VIW , Views , Problem