Update cube incrementally Vs. recreating entier cube

[Ricky@MDPD]

We recreate our cube on daily bases (the entier cube).  Cognos 8.4

How can I set up my cube to automatically:

1- update incrementally during the week
2- fully recreate on Saturdays!!!

Any feedback is greatly apreciate..Thanks

[Arun.J]

Use two copies of the model one saved in .PYJ and other .MDL

use the .PYJ for weekdays . In the SQL,  put the timestamp filter (like sysdate) to load only new categories.
*Ensure the Timestamp with Date,Day,Time(HH:MM;SS) so to load all the new data precisely

Write a Batch / Shell script to update the Cube using .PYJ Model and schedule it.

use the .MDL for Full Load.

Write a Batch / Shell script to update the Cube using .MDL Model and schedule it.

Arun.J

[judicael]

Hello,

I have to set up the incrementally update cube.
Would you explain to me the details steps for implement
this solution ?

Thanks.

Judicaël.

[MFGF]

Hello,

I have to set up the incrementally update cube.
Would you explain to me the details steps for implement
this solution ?

Thanks.

Judicaël.

See this thread.

MF.