HANA Studio’s Extract Semantics tool supposedly alleviates the issues frequently encountered when modifying a view; e.g., when removing a join below the top-level aggregation node so as to insert a new join node, the metadata (user-defined column labels, aggregation types, etc.) are lost. It's my understanding that the tool is supposed to help in this regard.
I’ve been trying the tool with various project but am having poor results. The first confusing thing is that it requires me to specify the data source for many of my outputted fields, presumably because those fields come from multiple sources in lower nodes; however, it’s not obvious what the repercussions of the selections are such as when I later re-apply the metadata (i.e., the copied semantics) after the new join node has been connected to the top-level aggregation node. Also, when re-applying the metadata, some of the column labels are not restored.
At this point, I don’t have much confidence in the tool because I don't know what metadata will be lost.
Has anyone here tried using this tool? If so, what has been your experience?