DSO for Aggregation purpose

[#1]

Hi,

I want to create a consolidated DSO based on the two info cubes as a source for this DSO so I can use this DSO for lookup purpose

I want to use the following objects as Characteristics and Key Figures in the DSO

Characteristics: Material, Plant, Fiscal Period, Version ID

Key Figure: Actual Production, Number of Hours

Both cubes have have same characteristics and KF.

I need to know what type of DSO do I need to create that can control the aggregation for key figures coming out of both source cubes

Any help will be appreciated

Thanks

[former_member203111]

Thanks everyone for valuable suggestions, I have finally resolved the issue to re-structure my entire model, I created a standard DSO and dump data into it from multiple source and then from that standard DSO the data loaded to cube with some transformation logic.

Thanks you all.