Symptom
When changing the field type in local tables it is observed that the related Views are not synchronized.
Environment
SAP Datasphere
Reproducing the Issue
Examples steps are :
- Create a VIEW
- Drag and drop the local table
- Change the local table field type without deploying
- Deploy the VIEW.
Cause
Modeling related objects in several browser tabs is not a supported use case. It can also lead to complex scenarios which cause issues.
Resolution
You may use following sequence:
- Create table.
- Create view on top of this table, then save (or deploy).
- Edit table, update column data type, save (or deploy). You will get message saying that the change may impact dependent view.
- Open view, you will see a message saying that the source has been updated. Save this view, data type will be updated.
Keywords
KBA , DS-MD-VIW , Views , Problem
Product
SAP Datasphere all versions