Blending - SAC

[4analytics]

Hello community,

Im practising with two models (HANA) and im trying to blend data.

I would like to understand how can i blend them to view if my costumers have fax or no (sampled data and models)

Here we can see costumer ID as the linked dimension, the date (hierarchy), movements... Im really interested in create a new story which i can see a table with the following structure: Year / Month - Counter of times the costumers come - % of Costumers ID who have fax(each month). My problem is when i try to make this table because 2 errors appear.

1. Out of context blending caused an average/count aggregation to be performed.

2. Blending duplicate. Blending caused some values to be duplicated.

Best whishes,
Z.

[sourabhpaul]

Hi,

Blend with costumer ID only. may it will help. I have created data identical to your data. I am not facing duplicate issues. maybe it will help you.

Regards,

Sourabh Paul