Search found 5 matches

by sven912
Fri Feb 25, 2022 10:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rest API - Powershell
Replies: 6
Views: 3465

Re: Rest API - Powershell

Thank you so much that worked perfectly - I will now analyse the code so hopefully I can start to get my head around how all this works !
by sven912
Fri Feb 25, 2022 3:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rest API - Powershell
Replies: 6
Views: 3465

Re: Rest API - Powershell

I'm very much a novice on this! This is what I have - I played around with the parameters entry until the syntax was accepted but still unsure how to get them to be triggered. Can anyone help me understand what I need to do. Thanks. [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocol...
by sven912
Fri Feb 25, 2022 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rest API - Powershell
Replies: 6
Views: 3465

Re: Rest API - Powershell

Thanks for that - looks like I need to study more on this - not sure how I get the parameters into the lines of code ? Do I need to add -Parameters $Parmeters or similar into this code. $TM1RESTAPI = Invoke-RestMethod -Method Post -uri $TM1InstanceURL -WebSession $session -Headers $headers -ContentT...
by sven912
Fri Feb 25, 2022 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rest API - Powershell
Replies: 6
Views: 3465

Rest API - Powershell

Can anyone help with the syntax for adding parameters to a PS script to execute a process. Works fine with no parameters.

$TM1Run = "Processes('zRestAPITest')/tm1.Execute"

But how to I add say pYear = '2022' and pMonth = 'Feb'

Thanks.
by sven912
Fri Feb 25, 2022 1:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation within the same dimension
Replies: 6
Views: 2334

Re: Calculation within the same dimension

Create a 2nd consolidation called "All Departments exc Dept1" with all departments except Dept1 rolling into it - then you should have the basis for want you need.