Showing results for 
Search instead for 
Did you mean: 

Aggregation after Collapsing InfoCube

Former Member
0 Kudos

Hi All:

As after collapsing an Infocube, records with same business key are aggregated, then after two DTP runs we can have a record Sales =USD 100 twice. This means that after collapsing we will have one record with USD 200 which might be wrong (duplicate sale revenue) if the DTP runs with full update. Any ideas on this, or business scenarios that might justify it?


Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


This again depends on your delta...

If you have a before and after image delta - makes sense compressing your cube .. else if it is a cumulative load every day / period - then you would have to delete previous request ( also known as delete overlapping request ) and nt compress your cube..


Answers (1)

Answers (1)

Former Member
0 Kudos

see here the prob lies with MDM of Cube.

you need to delete prev req and do a full update.

Then do a rollup and collapse.

Hope it clarifies



assign pts if it is useful