Question on Calculation view

[Former Member]

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!

[Former Member]

Hi Saj,

I think you followed that steps that has to be done for UNION in Calculation View. Just check whether you mapped '0' for M3 from CA2.

Please check in your CA2 whether you have values for D3 or not.Other thing is confirm whether you can change the join to union in calculation view as it will change the result how business look into it.

Regards,

Venkat N.

[Former Member]

Hi

Thanks for the reply. Well, the result set is the same. I could validate rest of the data. But tthis column D3 is having only null values. In the join view, this field has values 'Y' or 'N',

That is confusing me.

Cheers

Saj

[Former Member]

Hi Saj,

Did you check the CA2 output and make sure you have values for D3?

Try to run the select query on final calculation view and put filter on D3 for not null and see whether you are getting any data or not.

Regards,

Venkat N.