Skip to Content
avatar image
Former Member

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 04, 2015 at 04:34 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.