Question on Calculation view
I am a newbie in SAP HANA and please pardon me if the question appears silly to you.
I have been asked to optimize a Calculation view for perfomance.
The original one was built with 'Join'ing 2 Calculation views, say CA1 and CA2. Let's call the one in question as CA.
Now, CA1 has the below fields
Old version of the CA had D1, D2 of CA1 Inner joined with D1, D2 of CA2 and D1, D2, M1 and D3 in semantics.
When I changed this to union, I have mapped
D1 of CA1 to D1 of CA2,
D2 or CA1 to D2 of CA2 and
mapped M1 from CA1 and D3 from CA2 to output.
When I was doing a data preview, I see values are populated for D1, D2, M3, but not for D3.
The 'Manage mapping' shows it is mapped with D3 from CA2, and marked Null for CA1.
Am I missing something here?
Thanks in advance!