MDL Refreshment

[bmw2008]

Hi

We are in the process of Migrating the C7 cubes with C8 Cubes in Transformer. as my client has some Macro which refresh  the cubes in c7. but In c8.3 that macro are not running. we are getting error as Object Class not Found. as it looks that C8.3 don't support that Macro..
is other any way we can write any scripts or some other way. in which we can refresh the MDL in C8.3 transformer..

Your prompt reply great,

thanks
BMW.

[Arsenal]

Hi,

Macros have been disabled in 8.3 Transformer. You have to write your own script to build the cube using cogtr(for Unix) and then throw in the PCCONN part of it incase you expect to build the cube during business hours.

[porkins]

I also am in need of creating a batch file to do cube refresh.  I got my PCConn disable and enable scripts working properly, but the cube build is having issues.  We are on 8.3 with a 7 namespace.  If I omit -l or -y1 and login manually then the script will run.  But, this needs to be automatic. When I use -l I get a login error when I use -y1 like below it submits a timestamp to the log and nothing else happens??

E:\Cognos\C83\bin\cogtr.exe -n2 -i -y1"namespace=username/password" -r4 -dLogFileName="logfile.log" -dLogFileDirectory="E:\Metadata\Models" -dCubeSaveDirectory="E:\Metadata\Models\Work" -dModelSaveDirectory="E:\Metadata\Models\Work" "E:\Metadata\Models\model.pyj"