In my application (hosted on UNIX), has a incremental cube (loades data on daily basis). As this cube contains hugh data so this cube reaches 2GB mark every month and fails after that. After that I remove some data from this cube (by changing the Initial Start Date) and rebuild cube. This process takes around 8-10 hours.
Is there any way, I can decrement the data (remove the data from cube) without rebuilding it?
or
Is there any way, so that on daily basis data will be inserted in the cube file (as this is incremental cube) and just like that I can remove the first day data from the cube?
Ex:
Initial_Date Start_Date EndDate
2010-10-15 2012-08-22 2012-08-23
Next day:
Initial_Date Start_Date EndDate
2010-10-15 2012-08-23 2012-08-24 Here only one day data will be inserted in mdc file without rebuilding the Cube.
Any way that I can remove the last day data from existing cube(2010-10-15) without rebuilding?
Hi,
You can only remove data from the cube by rebuilding it, however you should have a look at
Multifile Threshold:
This will allow you to build a cube beyond the 2gb limit.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cogtr.8.4.0.doc/ug_cogtr_id9828AutomaticCreationofMultifileCubes.html
Time Based Partitioning:
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cogtr.8.4.0.doc/ug_cogtr_id7761DefiningTBPCube.html
Rob