Simple Join Issue

[Former Member]

Hi

We are in HANA SP9

I need to have a actuals vs target for salesman as follows

Actuals is already available in a calculation view. Target is arriving as flatfile. Hence created analytical view for same

Projection 1 -> target

Projection 2 - > actuals

I joined this 2 projection by salesman code and date and used right outer join ( right ->target, left -> actuals)

and cardinality 1:1

Ideally it should work, but What I am getting is strange output

I played around with cardinality and changes join type to inner/left but nothing giving me correct output

Any inputs much appreciated

[former_member200930]

Hi Ben,

Please do following steps to get desired result.

Create calculation view as per the below image

Image 1 :

Join on proper columns. I have used only date columns.

Image 2:

Please create link between join and top aggregation node. As per shown in image 1. 

On top level, I have used aggregation node. Please right click on "values" column and select " add to output" for both columns.

Image3:

Now, below image is for your ref.

Image 4 :

Now, activate your model and you will get your desired results.

Image 5:

If you still facing problem or not getting proper result then please coordinate with you HANA admin guy. There could be problem in SAP HANA modeler.

I hope, It will solve your problem.

- Vikram Divekar