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
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.
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.
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
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