Search found 127 matches
- Wed Dec 27, 2023 1:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18688
Re: REST API Dimension Clone
We use something like this #.\hot_promote_process.ps1 my_process_name DEV UAT PATCH $processName =$args[0] $sourceEnv =$args[1] $targetEnv = $args[2] $method = $args[3] function Set-Header { param ( $EncodedText ) $header = @{ "Content-Type"="application/json; odata.metadata=none; oda...
- Tue Nov 14, 2023 4:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18688
REST API Dimension Clone
Hello, We have a simple Powershell script to hot promote TI processes, and am looking to implement something similar for dimension metadata. I'm looking to replicate a dimension between 2 services using the REST API as opposed to TI. It should be an exact copy, including attributes. Does anyone know...
- Fri Sep 01, 2023 9:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1733
Re: Update a process with the TM1 REST API
Just in case anyone's interested, I worked out how to remove the attributes property via Powershell: ... $response = Invoke-WebRequest -Uri $url -Method Get -Headers $header $x = $response.content | ConvertFrom-Json $x = $x | Select-Object * -ExcludeProperty Attributes $body = $x | ConvertTo-Json $u...
- Fri Sep 01, 2023 8:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1733
Re: Update a process with the TM1 REST API
Yes, these are lost so need to be re-added, which is probably more work than removing the attributes property from the body.
- Thu Aug 31, 2023 9:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1733
Re: Update a process with the TM1 REST API
Another solution I have found is to simply delete the existing process from the target server and then re-add: $url = $url = "http://${targetServer}:${TargetPort}/api/v1/Processes('$processName')" $header = Set-Header $targetUser $targetPass $response = Invoke-WebRequest -Uri $url -Method ...
- Wed Jun 28, 2023 3:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 4200
Re: Run Process - How to Determine When All Completed.
File semaphores is what I use currently to control a parent process. I believe I read about using adding/removing attributes or elements and tested it a few years back, but never used in production. The file semaphores seem to work well enough. Wasn't there a post the other day about some additiona...
- Tue May 10, 2022 8:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DIMNM performance in PAfE
- Replies: 2
- Views: 875
DIMNM performance in PAfE
Has anyone else experienced issues with Perspectives functions in PAfE? We have a fairly large function dimension and it takes ~ 10 seconds for a single retrieve. My alternative REST API query is much faster. Existing IBM query: http://server:port/api/v1/Dimensions%28%27dimension%27%29/DefaultHierar...
- Mon May 17, 2021 5:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Rule Attach
- Replies: 1
- Views: 2175
Re: REST API Rule Attach
Managed to figure it out: PATCH request: api/v1/Cubes('xxx') Body: {"Rules": "this is an error"} Response: { "@odata.context": "$metadata#Cubes/$entity", "@odata.etag": "W/\"e8d228a6c97159561df48d9ecf2a4c71a1a657b6\"", "Name&...
- Mon May 17, 2021 5:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Rule Attach
- Replies: 1
- Views: 2175
REST API Rule Attach
Hi All, I've worked out how to validate the existing or new rule for a cube, but can't find where in the documentation it shows how to attach. Does anyone know the function? request: api/v1/Cubes('xxx')/tm1.CheckRules body (blank to check existing rule): {"Rules": "this is an error&qu...
- Fri May 14, 2021 8:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Escaping } in REST API query
- Replies: 3
- Views: 3519
Re: Escaping } in REST API query
Hi Michael,
Thanks very much for the detailed explanation, and the FriendlyName suggestion which is a better solution that I had:
Thanks,
Dan
Thanks very much for the detailed explanation, and the FriendlyName suggestion which is a better solution that I had:
Code: Select all
/api/v1/Users('userid')?$select=FriendlyName
Dan
- Thu May 13, 2021 10:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Escaping } in REST API query
- Replies: 3
- Views: 3519
Escaping } in REST API query
Hi All, I'm having an issue with a query to get a user's default display alias: } escaping to %7D api/v1/Dimensions('}Clients')/Hierarchies('}Clients')/Elements?$select=Attributes/%7DTM1_DefaultDisplayValue { "error": { "code": "278", "message": "Unsuppor...
- Mon Jul 23, 2018 11:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Limitation of DBS/ DBSW
- Replies: 2
- Views: 2235
Re: Limitation of DBS/ DBSW
I have found a sample: modCreateCubeFromFile that seems to have all the necessary functionality I require.
- Mon Jul 23, 2018 10:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Limitation of DBS/ DBSW
- Replies: 2
- Views: 2235
Limitation of DBS/ DBSW
We have a problem with sending data from Excel to TM1 as I believe the limit of the DBS/ DBSS formulae is 16 dimensions and we have some cubes with more. A few options are being discussed presently: Tm1Tools and use DBRW to copy/ paste UDF using REST API to write the data UDF using classic API to wr...
- Mon Apr 09, 2018 9:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA API Certificate Issue
- Replies: 0
- Views: 2534
VBA API Certificate Issue
Hi guys, We're experiencing an issue with an older client version connecting to PA 2.0.4. We have a set of certificates that works perfectly when using perspectives or architect however we are using the VBA API to connect: TM1SystemServerConnectWithCAMNamespace and this is not working. Is there a wa...
- Mon Aug 08, 2016 1:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: startup chore behaiviour
- Replies: 14
- Views: 7399
Re: startup chore behaiviour
My guess is that the stats cubes only start to get populated after the server has loaded and the startup chore has run, which makes sense to me. I would try running a nested TI process from the chore via tm1runti.exe and have the nested process do the waiting. TI process that's part of startup chore...
- Fri Jan 23, 2015 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel keep refreshing screen when flew view contain formula
- Replies: 3
- Views: 4078
Re: Excel keep refreshing screen when flew view contain form
Try turning your calculations to manual in Excel:
Formulas -> Calculation Options -> Manual.
You can then manually calculate your spreadsheet by pressing F9
Formulas -> Calculation Options -> Manual.
You can then manually calculate your spreadsheet by pressing F9
- Fri Jan 16, 2015 2:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Write the feeders for this special Rules
- Replies: 3
- Views: 4522
Re: How to Write the feeders for this special Rules
Did you read through the article? You should read it and make sure you understand it otherwise you're going to get stuck when trying to write rules with any kind of complexity. Your rule is a very simple one, something like: SKIPCHECK; [‘Sal_Company’:’OutSale’] = N: ['Pro_Company':'Total_Company’]; ...
- Wed Jan 14, 2015 2:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Write the feeders for this special Rules
- Replies: 3
- Views: 4522
Re: How to Write the feeders for this special Rules
You don't necessarily need to write your rule using a DB function as it's not an inter-cube rule and you're not using any functions within the DB. You can feed from a consolidation (i.e. Total_Company), which is the same as writing individual feeders for each of the node level children of the consol...
- Mon Jan 05, 2015 10:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average of last 12 months excluding months which dont have d
- Replies: 4
- Views: 3551
Re: Average of last 12 months excluding months which dont ha
There are a few considerations here. If you keep track of how many months you've loaded for each year in a separate cube, you can reference this denominator using a DB() function in place of your hard-coded 12. Alternatively you can create a new measure to keep track of whether Revenue_meas1 is non-...
- Fri Dec 12, 2014 11:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 10.2.2 RunTI.exe with SSO
- Replies: 3
- Views: 4621
Re: 10.2.2 RunTI.exe with SSO
HI, We have it working in 10.2 FP2: "D:\Program Files\ibm\cognos\TM1_10_2_64_DEV\bin64\tm1runti" -i "D:\xxx\tiprocess.config" -connect instance_label -process cube_clear_view psCube="xxx" psMonth="2014_01" tiprocess.config contains the following information: [...