Symptom
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'.
Environment
SAP DataSphere
Reproducing the Issue
Delete any column of a view which is consumed by Intelligent Lookup
Cause
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.
Resolution
This development is a complex one and still needs to be fitted to the roadmap though.
Keywords
KBA , DS-DI-IL , Intelligent Lookup , Problem