Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Question on Calculation view

Dear Gurus

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

D1

D2

M1

CA2 has

D1

D2

D3

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!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question