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
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
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.
Quote from: judicael on 05 Jan 2010 06:08:23 AM
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 (http://www.cognoise.com/community/index.php/topic,8613.0.html) thread.
MF.