Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: Sarayucog on 03 May 2010 02:19:49 AM

Title: issue in incremental updation of a cube
Post by: Sarayucog on 03 May 2010 02:19:49 AM
Hi all,

I have a cube, I want to update it incrementally.

My problem is when I am updating with 2 weeks of data its working fine, but when I am updating it with months of data its taking too much of time like 10hrs to 14hrs or some times its hanging out. I am using some batch file to run that cube automatically.

Could you please anyone give the solution for this.


Thanks in advance
Sarayu
Title: Re: issue in incremental updation of a cube
Post by: bdbits on 03 May 2010 10:59:50 AM
Please post the batch file, or at least the cogtr line. How much data are we talking about? thousands or rows? 10s of millions? How long does it take to completely build the cube as opposed to an update?
Title: Re: issue in incremental updation of a cube
Post by: Sarayucog on 05 May 2010 05:07:54 AM
Hi dbbits,

C:cogtr.exe  -n2 -i "E:\xyz\models\vcb.pyj"

Could you please tell me now what is the problem.


Thanks in advance
Sarayu
Title: Re: issue in incremental updation of a cube
Post by: cognostechie on 10 May 2010 06:22:58 PM
Build the cube from within Transformer to see how much time it takes. Open the log file to see how many records are being read and post it here. I have had cubes reading 60 million records (10 million more than Cognos suggests as the higher limit) getting built in 3.5 hrs.
Text only | Text with Images