cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Load from Partially Compressed Cube

Former Member
0 Kudos

Hi All,

We have a design where we have a Cube on top of cube. We want delta loads for the same (Cube 1 to Cube 2). We want to compress data in Cube 1 before loading to cube 2.

What has happened is that for dataloads for days Dec 1 - Dec 15 to Cube 1, we had compressed the Cube 1 and days Dec 16 - Dec 31 data was uncompresssed. We did an Initialization on Jan 1 from Cube 1 to Cube 2.

When we reconciled the data with SAP, we are way way off. I'm thinking it might have to do with partial compressions. Please let us know your views. How would the Init would have worked in the above scenario as some data was in F table and some in E table?

Looking forward to all of your views/suggesstions.

Regards and Thanks,

Vivek

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vivek,

Though a late reply, but for others who come to this thread.

Dataload from a compressed cube would not give you the required result. You should use a copy cube.

Or if in flow we are loading from Cube 1 to Cube 2 then Cube 2 should be compressed.

Thanks

Sachin