Blog

Power Update Command Line Parameters

by

Running PU jobs in a batch file:

After you have defined the jobs, you can take even more control over the jobs by i.e. running them sequentially in a batch job. Here are the command line parameters supported:

PQRefresh.exe command line (normal tasks):
C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe “taskName”
 

arguments:

-log:FILE_PATH

Path for the PU.log file

-sp_overwrite_delay:NUMBER

number of miliseconds to wait until SharePoint processes restores the cube from the xlsx file (the file is uploaded as a temp file then renamed to it’s final name after that period)

-files:FILE_PATH

path for a txt file containing the files to refresh (one for each line, good for manual retries)

-macros_before:[“MACRO_NAME1 ARG1 ARG2..,MACRO_NAME2 ARG1 ARG2,..”]

list of macros to run before the update

-macros_after:[“MACRO_NAME1 ARG1 ARG2..,MACRO_NAME2 ARG1 ARG2,..”]

list of macros to run after the update

-wbpassword:PASSWORD

Workbook protection password

-timestamp

switch to include timestamp in file names

-email_to:[“EMAILADDRESS1, EMAILADDRESS2,..”]

target email addresses

-ssas_user:USER_NAME

SSAS user to impersonate using the EffectiveUserName connection string property on OLAP connections, NOT YET IMPLEMENTED

PU.exe command line (waits for exit and gives return code, 0 if ok, also used when impersonating a user)

C:\Program Files\PowerPlanner\Power Update\PU.exe “taskName”
 

Parameters

-runas

switch for impersonating a user (imersonation user / pass is defined in the task)

 

 

 

PURunas.exe command line (helper for running impersonating users, not used at the moment by PU)

C:\Program Files\PowerPlanner\Power Update\PURunas.exe “C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe \”taskName\” …” “domain” “username” “password”