3669843 - Changes in the backend source are not reflected in a Public dimension in SAP Analytics Cloud

• You have removed an entry (member) in the source system and this is not being removed from the SAC Public dimension after refreshing the import query.
• The expectation is that deleted entries (members) from the source system should also be updated when importing and therefore not appear in the SAC Public dimension any longer.

SAP Analytics Cloud Enterprise 2025

1. Create an SAC Public dimension.
2. Create an import to load data into the dimension.
3. Delete a member from the source system.
4. Refresh the import query in SAC.
5. Observe that the deleted member from the source system still appears in the SAC dimension.

This behavior is expected and reflects SAP Analytics Cloud design.

As highlighted in SAC's Help Portal Import Data to Your Model, a dimension data import job never deletes existing members, but only adds additional ones.

For example: You have a dimension with members A, B and C. You run a data import job that imports members B, C and D. You'd expect that the dimension would then have members B, C and D, but in fact the dimension has now members A, B, C and D.

• Import Data to Your Model
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

Your feedback is important to help us improve our knowledge base.

SAC, cloud, import, analytics, public, dimension, BW, S4/HANA, HANA, member, entry, members, entries, remove, delete, importing, changes, reflect. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem