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

process of rebuiding or updating powercube in transformer 10.2

Started by nageswar1975, 20 Oct 2014 03:30:08 AM

Previous topic - Next topic

nageswar1975

Hi,

I am new to transformer. we have incremental delta data load into our db2 db. we have already existing power cubes, what we need to do for updating/rebuilding the cubes after the delta data load.

Regards,
Nagesh

bdbits

Generally speaking, you can simply rebuild the cube.

If you want to incrementally update the cube, you can do it but there are some caveats and steps to take before you deploy. This is covered in the Transformer user guide.

http://www-01.ibm.com/support/knowledgecenter/api/content/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cogtr.10.2.1.doc/c_maintainmodelscubes.html#maintainmodelscubes

CharlesAZ

How many date dimsions are you going to require?

If you only have one Date Dimension, then I would reccomend a Time based Partion Cube build process over the tradtional incremental cube build process.    Time based partition cube does not require a complete rebuild like a incremental does every x number of builds.  One reason is because builds seperate cubes for the incremental updates after your intial cube build but the user only sees the solution as one cube.  how many cubes/increcments you maintain can be controlled by a vsd file, which references each of the cubes and you can build a script to delete records out of the file.  Anyway I am throwing a lot at you but, point is if you are only using one date dimension in your model, then you should consider using a Time based partition cube.  You can find out more information on it in the transformer user guide, which is free to access, just google it.

Thanks

Charlie