Skip to Content
0

Hana calculation view wrong aggregation between joins

Jan 04, 2017 at 02:24 PM

49

avatar image

Hi everyone,

I have the following issue i have a join between two projections, the thing is on the left table i have a measure wich duplicate many times as number of LGORT or CHARG for each material. I want the measure of the left fixed for one material independent of LGORT AND CHARG not aggregate by the dimensions of the right table.

if i dont use anything of the rigth table the measure its correct but if i include a measure of the right make the sum for all values of CHARG and LGORT

11.jpg (48.7 kB)
12.jpg (47.0 kB)
13.jpg (11.6 kB)
11.jpg (10.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers