3557114 - When updating Public Dimension with Data Import Service (DIS) API, properties will be cleared if no values are defined in request body.

When using the Data Import Service (DIS) API to import only some of the properties to a public dimension with multiple hierarchies and properties, the API deletes the content of properties and hierarchies not specified in the request body.

SAP Analytics Cloud 2024.21.10

1. Public dimension has the following member:
   1. ID: Test_01
   2. Property1: P1
   3. Property2: P2
   4. Hierarchy: H1
2. Set up import API clients and token, write the following in request body:

   1. { "Data":[ { "ID":"Test_01", "Property1":"P01"} ] } 

3. After running the import request, you will notice the dimension member is updated to the following:
   1. ID: Test_01
   2. Property1: P01
   3. Property2: (Empty)
   4. Hierarchy: (Empty)

The behavior observed is due to the current design of the Import API.

Workaround: 

1. Data Export Service: Use the Data Export Service to export the actual values of the public dimension. This will help you capture the current state and ensure other properties.
2. Data Import Service: After obtaining the current values which you will use to build your body to import data for Data Import Service, update only the necessary values for the specific properties you intend to change.  

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

SAP Analytics Cloud, Data Integration, Data Import API, Public Dimension, Import, Properties, Hierarchies, Deletion, Unmapped Properties, Contrary Behavior, File Upload, Import Jobs, Connections. , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem