Update/Built Cube daily by Scheduler

[sys2674]

Hi,

I have a cube build.and i want this cube to be build daily at 4.00a.m. through scheduler.
Can any one pls help me to solve this.

Regards
SYS2674

[cognostechie]

I use Windows Scheduler to update the cube automatically every morning. Create a batch file (.bat) in Windows with the following (change the location according to where your Cognos is installed and where your .pyi file is):

"D:\Program Files\cognos\cer3\bin\trnsfrmr.exe" -n2 D:\inv\inv.pyi

Put this .bat file in Windows Scheduler and it should work.

[cognostechie]

Just to add this would work when no logins/passwords are required. Since you were making cubes from .csv files, so I presume this is what you need.

[sys2674]

Hi cognostechie ,
thnx for the solution,I tried but it did not work.
I tried another method in scheduler but i am getting this "Run-time error '91':
Object variable or With block variable not set."
If i click ok it closes scheduler.
I am unable to open scheduler

Pls let me know about it

SYS2674

[sys2674]

HI cognostechie ,

Thnx for ur solution,i was able to build cubes from scheduler.
I  wrote the folowing
"C:\Program Files\Cognos\cer4\bin\trnsfrmr.exe" -n
-s "C:\Cognos_Data\Sales_Data\Models\2005Q1_SLS.pyi" where we browse file
made sure that there are no duplicates of 2005q1_sls.pyi,2005q1_sls.mdc
and delete all *.qy*,and*.lck
and scheduled for 4.00a.m it worked fine.This using poweplay 7.3,scheduler7.3

Cheers
SYS2674