How to join two non-cumulative ADSOs in a Composite?

[severin_thelen]

Hi all,

we try to join two non-cumulative ADSOs in our system, but we get wrong results in our query.

Our data model has two ADSO and a Composite-Provider.

• Employee ADSO, contains data like name, age and current position
• Position ADSO contains data about the office-location and the job title

Because of transformations in the ETL-process, the two ADSOs store the number of employees and positions as non-cumulative key figure with in- and outflows.

Now we want to join both ADSOs in the composite-provider. Therefore we (left) join the position ADSO and the employee ADSO with the following join condition:

• position-position-Id = employee-currentposition-id
• position-0CALDAY = employee-0CALDAY

Our problem is, that the query shows twice as many employees per row as it should have, but the number of positions is correct. If I switch the both ADSOs in the left join, I get to many positions, but the correct number of employees. Until now I try some other join-conditions, but no tested condition solves the problem.

Has some an idea how to solve the issue?

Regards
Severin