On our NT Server(ver 4.0) we have business intelligence (Cognos) software/applications, which basically build cubes(olap tool) using data derived from various data sources.
However, we wish to build the cubes remotely on the Server being driven from our IBM AS400 Machine – when data is available, eg:after overnight processing, but not relying on the Cognos scheduler, ie: fixed times.
Currently we schedule our cube builds on our NT server – however, they are reliant on the data being available at the scheduled time.
On occasions this has become an issue, when over night processing on the AS400 takes longer than expected & runs past the scheduled time – even though we have built in a buffer of 1½ - 2 hrs to allow for minor delays/processing.
Data normally available 02:30
Cube build starts 04:00
Required by the business 07:00
So, we thought, right, rather than relying on fixed times, lets get the AS400 to drive/execute the jobs when the data is available.
- On the whole the cubes will be available earlier
- Building will be complete, when the first user accesses the system, save on resource etc
- In the event of data being unavailable at the normal build time – this no longer becomes an issue – as the AS400 drives the cube build process - earlier later etc
Currently we have several processes taking place, macro’s being run, sqlserver dts jobs etc – we have managed the following:-
1) AS400 to execute remote Dos commands
2) AS400 to execute remote Sqlserver dts jobs(import routines/table builds)
However, we are unable to get the AS400 to build remote cubes …..in either dos batch files or via a macro.
We even tried scheduling the existing cube build batch files using the ‘at’ command – the jobs get scheduled, but will not execute – security is at the Admin level for the account using/running the at command – process starts, but not given any cpu or memory.
Sample of the batch file
rem ** povendorcubebuild.bat
rem ** K Jones
rem ** ver 1.1
rem ** 26 Nov 2002
rem ** Amended so that the models are not saved on build completion
rem ** -s switch removed.
rem ** Builds PO cube
"D:\Program Files\Cognos\cer2\bin\trnsfrmr.exe" -i -n1 -r4 -nologo "E:\NEW COURTS BI\new po vendor.pyi"
**** Note the above works fine when scheduled or executed on the server ****
Bottom line is that we just want execute the above batch file remotely - comments please.
IBM AS400 – OS400 operating sys(ver5) – using client access express for remote tasks