SAP Knowledge Base Article - Public

3312194 - Error on saving view when deleting fields due to dependent on Intelligent lookup


One column of a view which is consumed by Intelligent Lookup is deleted in the view and the message:
The column 'xxxx' is deleted and may break dependent objects: 'yyyy'. 


SAP DataSphere

Reproducing the Issue

Delete any column of a view which is consumed by Intelligent Lookup 


Deletion of a column is considered a breaking change and thus detected by the DWC repository. At this moment, since Intelligent Lookup cannot gracefully handle breaking changes, we thus consciously prohibit the change in order to not break the Intelligent Lookup and potentially lose match data. 

We are planning to release this restriction in two steps, depending on the type of column. Columns that do play a special role in IL (because they are a key column, a pairing column or a match column) will continue to be treated specially during deletion since their deletion would break the IL in unrecoverable ways such that match information would get lost. All other columns shall be allowed to be changed in incompatible ways in the underlying view though. In a second step we plan to release this behavior but make users aware of the severity of their change. 


This development is a complex one and still needs to be fitted to the roadmap though. 


KBA , DS-DI-IL , Intelligent Lookup , Problem


SAP Datasphere all versions