on 03-14-2018 5:09 PM
HI Experts,
I have a requirement of Full Outer Join for my composite provider. Since that option is available only in Calculation View, so I am planning to use it. While testing my CV based HPCR and direct HPCR on top of ADSOs I noticed a variance...
1.The composite provider with a Left Outer join between the two ADSOs gives me a result of Quantity -4176 (screenshot attached)
2. The CV based composite provider with a left outer join with the same data set is aggregating my 0QUANTITY units (attached screenshot). In CV I have used the projection instead of Aggregation post the join node.
In my CV based composite provider, I have mapped my Quantity field to info object 0Quantity.
Regards
Bhawick
Out of all the fields I have kept Profit Center/Company Code/Version/Value Type/Fiscper flag (Keep Flag) is set to TRUE, but still, the numbers are getting aggregated. Above fields are my joining fields as well. Any pointers are appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.