Multiple outputs from 1 Anaplan Connect Script or 1 Process

Regular Contributor

Multiple outputs from 1 Anaplan Connect Script or 1 Process

Hi,

I want to be able to export 6 views of the same module to external file (xls). I have saved the 6 views and i have exported and saved the processes. I would like to have 1 script to run the 6 outputs, but if i use a script with all six, it only runs the final process. I did try creating one process with the 6 actions, but that also just runs the final action.

This is the script (well similar)

 

Thanks

 

rem OUTPUT the Promo history
set Operation=-export "Report 1" -execute -get "M:\file1.xls"
set Operation=-export "Report 2" -execute -get "M:\file2.xls"
set Operation=-export "Report 3" -execute -get "M:\file3.xls"
set Operation=-export "Report 4" -execute -get "M:\file4.xls"
set Operation=-export "Report 5" -execute -get "M:\file5.xls"
set Operation=-export "Report 6" -execute -get "M:\file6.xls"
Message 1 of 4
3 REPLIES 3
Regular Contributor

Re: Multiple outputs from 1 Anaplan Connect Script or 1 Process

Ahh i think i have solved it.. i need to have the trigger information between each process in the script. This then runs them one after another.

 

Give msyelf Kudos :)

 

set Operation=-export "Audit - 1" -execute -get "C:\Audit 1.xls"

setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%

set Operation=-export "Audit - 2" -execute -get "C:\Audit 2.xls"

setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%
Message 2 of 4
New Contributor

Re: Multiple outputs from 1 Anaplan Connect Script or 1 Process

Hi,  have you thought of just putting in a line break?

set Operation="-export "Report 1" -execute -get "M:\file1.xls" ^
-export "Report 2" -execute -get "M:\file2.xls" ^
-export "Report 3" -execute -get "M:\file3.xls" ^
-export "Report 4" -execute -get "M:\file4.xls" ^
-export "Report 5" -execute -get "M:\file5.xls" ^
-export "Report 6" -execute -get "M:\file6.xls" "

 

Message 3 of 4
Community Manager

Re: Multiple outputs from 1 Anaplan Connect Script or 1 Process

 
Message 4 of 4