Hi Paulo,
in addition to all of the above, we are also using ExecuteCommand to :
1) Run other tools to manipulate files, for feature or performance reasons (vs what could be do by TI process)
a) awk.exe, to create X files from a source one, splitting on data present in column X.
(for example, I have a file with the 12 months, and it want to create 12 monthly files which can then be imported in parallel)
b) sfk.exe, to:
- Sort the contents of a file by selected columns, and optionally removing duplicates lines
- create another file with only unique values (dimension elements) in certains columns.
For example when importing a file uploaded by a user, I wand to clear the perimeter based on BusinessUnit, Scenario and Year from this file.
This operation will create a file with the scope to be cleared.
c) Powershell, to
- Get the modification date/time of a file
- Get the size of a file (to determine if we should split it and import the resulting files in parallel, or not)
- get a file HASH (useful for external systems that consume files generated by the application)
2) Run Powershell Scripts (for example, execute the Process Scheduler, passing a configuration file generated by a process)
3) Execute TI processes 'externally' and wait for them to complete, using ExecuteCommand( '...\tm1runti.exe ...', 1)
>> in PA Engine, we can/will instead use RunProcess() in conjunction with WaitForAllJobs().
+ it would be nice to have these Wait...() functions available in PA Local, it would make the transition easier.
Cheers !
------------------------------
Renaud MARTIAL
PA Applications Manager
L'Oréal
------------------------------
Original Message:
Sent: Mon February 22, 2021 09:03 AM
From: Paulo Monte
Subject: What are you using ExecuteCommand for in the Cloud? We want to hear from you.
Hi All,
Many customers and partners implement additional functionality not native in the product\service using ExecureCommand via a TI process.
It's a powerful way to build around the service.
We'd really like to hear about what Cloud customers (specifically cloud customers) are doing with ExecuteCommand.
Cheers,
------------------------------
Paulo Monte
------------------------------
#PlanningAnalyticswithWatson