cancel
Showing results for 
Search instead for 
Did you mean: 

Composite Provider performance with left outer join

former_member730190
Participant
0 Kudos
341

Hi all. I have a composite provider unioning a bunch of ADSOs and Cubes. I then have a left outer join on this union to a characteristic.The number of records in the cubes and ADSOs are in 100-300 million range. The records in the characteristic are 3 million. The reporting is very slow. Is there anything I can do to improve the performance? Including the characteristic in the cubes and ADSOs is not an option. BW on HANA (2.0). Thanks.

Abhishek_Hazra
Active Contributor
0 Kudos

Is your join condition based on the same characteristic info object? Or some of its attributes?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member730190
Participant
0 Kudos

The join is based on the attributes of the characteristic.