If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

partition cube build for new/updated data

Started by cham, 05 Aug 2010 02:51:35 PM

Previous topic - Next topic

cham

Hi Gurus,

I really need help for this.

I am trying to build the power cube(transformer) everyday incrementally. The cube is patitioned by month. But incremental load is inserting duplicate data because my source can be updated 5 days back data. I can't do the full cube build everyday because of data volume and time to build it.  My cube is partitioned by month. Now my question is : is it possible to full build the cube everday by partition, so that everyday I will do full build only the last month partition and that will solve my problem of inserting duplicate records(which are updated but not inserted in the source).

Please let me know if anyone knows about it. Also, if any workaround.

Sarayucog

As of me its not possible to do incremental update when you have partitioned the cube by month wise.

Clarify me is it possible to apply both incremental update and paritioning on a cube Simultaneously.

While applying incremental update your database should contain only current data. It should not contain previous data. If it contains previous data it will insert the duplicate data into you cube.