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

[john_hawk]

1) Will the combination of Material, Plant, Fiscal Period, Version ID provide a unique key?

If so, use Standard DSO with those keys and update transformation in overwrite mode.

2) Will there be multiple valid inputs with the same Material, Plant, Fiscal Period, Version ID combination, and you want to sum the records?

If so, use Standard DSO with those keys and update transformation of the key figures in sum mode.

3) Will you have delta record input or multiple valid records by Material, Plant, Fiscal Period, Version ID?

If so, used Write Optimized DSO with updattransformation rules in overwrite mode.

John Hawk