Periodic data load using a scheduled batch file for a scorecard/model metrics in SSM

[Former Member]

Hello,

We are using SSM 7.5 and have a scorecard (DCSCORECARDS) in which metrics/measures data is updated from cube by executing procedures (DCB, DCA etc.). The procedures are working fine when executed manually and data is getting updated in scorecard correctly. But I want to schedule these procedures in PAS server so that we need not to manually execute these procedures one by one every time to update the data. To periodically upadate data through procedures, I have created a batch file which is scheduled for daily update at a particular time. This batch file is scheduled through task scheduler in the PAS server with batch job name as SSMUpload_JOB.

The details of batch file are:

Name:

globalworkforce

Location:

E:\Program Files (x86)\SAP BusinessObjects

Content of batch file (globalworkforce):

@echo off
echo set sh=WScript.CreateObject("WScript.Shell") >tmp.vbs
echo WScript.Sleep 300 >>tmp.vbs
echo sh.SendKeys "SSMJOB{ENTER}" >>tmp.vbs
echo WScript.Sleep 1000 >>tmp.vbs
echo sh.SendKeys "trace both 'logfile.txt';ext{ENTER}" >>tmp.vbs
echo WScript.Sleep 3000 >>tmp.vbs
echo sh.SendKeys "SUP KILL CONN DCSCORECARDS{ENTER}">>tmp.vbs
echo WScript.Sleep 50000 >>tmp.vbs
echo sh.SendKeys "USE DCSCORECARDS EXC {ENTER}">>tmp.vbs
echo WScript.Sleep 10000 >>tmp.vbs

echo sh.SendKeys "JOB DCB{ENTER}{TAB}">>tmp.vbs
echo WScript.Sleep 10000 >>tmp.vbs
echo sh.SendKeys "JOB DCA{ENTER}">>tmp.vbs
echo WScript.Sleep 10000 >>tmp.vbs
echo sh.SendKeys "trace both off{ENTER}" >>tmp.vbs
echo WScript.Sleep 3000 >>tmp.vbs
echo sh.SendKeys "USE ZTEST{ENTER}">>tmp.vbs
echo WScript.Sleep 1000 >>tmp.vbs
echo sh.SendKeys "exit{ENTER}" >>tmp.vbs
echo WScript.Sleep 300 >>tmp.vbs
echo sh.SendKeys "{ENTER}" >>tmp.vbs

start PASAdmin.exe
cscript //nologo tmp.vbs
del tmp.vbs

But when the job runs at scheduled time and is executed,  status of the batch file shows "successfully executed" in Task Scheduler but data is not getting updated in the scorecard.

I am not able to fine out why this file is not able to execute the SPs and not updating the data.

Kindly help and suggest me a solution.

Thanks,

Yash

[Former Member]

Hello,

Please let me know if there is any other way to achieve this?

Thanks,

Yash

[Former Member]

Hi,

Try to execute then aplication server and send the procedure name to execute.

For that you need to call the aplication server, put the username, the password and the procedure name.

Example:
pasadmin.exe -j <proc name> -u <user> -p <password>

Hope this helps,
Miguel

[Former Member]

Hello Miguel,

Thanks for the reply,

Can you please eloborate it keeping in mind the changes i need to do in comparison to my earlier Batch file created because there are around 70 procedures created to upload the data into metrics from cube in scorecard which i want to schedule through batch file or any other way.

Thanks,

Yash

[Former Member]

Hi,

Create one new procedure and put your PAS commands there (only pas commands, not WScript...)

After that create a batch file to call the aplication server and your new procedure.

Miguel