Search found 32 matches
- Thu Jan 27, 2022 7:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Subset and Alias
- Replies: 2
- Views: 12903
Re: REST API: Subset and Alias
Thanks Mike!
- Mon Jan 24, 2022 2:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Subset and Alias
- Replies: 2
- Views: 12903
REST API: Subset and Alias
Hi This is the subset I'm using in this example. Please note that it's saved with an Alias selected. Alias.PNG I'm using following request to retrieve information about above subset: https://localhost:12354/api/v1/Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Subsets('Default') ...
- Tue Mar 31, 2020 10:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Subset - element level
- Replies: 1
- Views: 1335
REST API: Subset - element level
Hi I have a dimension as so: Capture.PNG I have a subset containg two elements from different levels: Capture1.PNG If I now use this expression to read the subset via REST: api/v1/Dimensions('TEST')/Hierarchies('TEST')/Subsets('Default')/Elements ...I get this: Capture2.PNG 'Level' is the level with...
- Thu Sep 26, 2019 9:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX API: Refresh Sheet
- Replies: 1
- Views: 3515
PAX API: Refresh Sheet
Hi all, I have a little VBA project that integrates PPT and Perspectives, ...in short..., from a meny in PPT I open a Perspectives report, I filter it, and then refreshes it by using ' xlApp.Application.Run ("TM1REFRESH") '. I now want to make this to work with PAX, but I run into a proble...
- Thu Aug 01, 2019 1:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: VBA and TM1 Server certificate
- Replies: 0
- Views: 14593
REST API: VBA and TM1 Server certificate
Hi, I have a VBA project in which I use the REST API to interact with TM1. Works like a charm! :) However, I receive below message when running the first request (e.g. $metadata) in current session. Security alert.PNG General.PNG I install the certificate, but the message keeps coming back. I have t...
- Wed Jul 31, 2019 10:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Cloud
- Replies: 5
- Views: 5126
Re: REST API: Cloud
I got it to work using a non-interactive account. Next step is to make it work with a 'real' account. Seen somewhere that it should work.
- Wed Jul 03, 2019 7:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Cloud
- Replies: 5
- Views: 5126
Re: REST API: Cloud
Thanks, will take a look at it.
- Tue Jul 02, 2019 9:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Cloud
- Replies: 5
- Views: 5126
REST API: Cloud
Hi Gurus, Yes, this is way too complicated for me. :) I'm using Postman to learn how to use the Rest API. I'm currently reading a local instance of TM1, but now want to connect to an instance on Cloud instead. Seems that the request is a bit different between the two, the local instance require a ht...
- Fri May 03, 2019 4:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Space
- Replies: 7
- Views: 6696
Re: REST API: Space
Got an answer from Hubert Heijkers: https://www.ibm.com/developerworks/community/forums/html/topic?id=1a5b77ec-80ff-4b4f-86be-9f83b5240d52&ps=25 Well, requests have to conform to OData URL conventions and therefore property names, in this case, the property name of the dynamic property represent...
- Thu May 02, 2019 12:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Space
- Replies: 7
- Views: 6696
Re: REST API: Space
Thanks Wim and tomok. Maybe the easiest and quickest solution is to create an attribute without spaces.
- Wed May 01, 2019 1:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: Space
- Replies: 7
- Views: 6696
REST API: Space
Sorry for a basic question, but I can't get it to work. I'm using below to retrieve a dimension element list. Note that I'm selecting a specific attribute, 'BusinessUnit'. /Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Members('10000')?$expand=Children($select=Name, Attributes/B...
- Mon Mar 11, 2019 6:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: DimensionElementComponentAdd
- Replies: 1
- Views: 2338
Re: REST API: DimensionElementComponentAdd
Found the answer: Body: {"Element@odata.bind": "Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Elements('New Element')} POST: Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Elements('Consolidation2')/tm1.SetComponent Found it here: https://www...
- Mon Mar 11, 2019 5:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: DimensionElementComponentAdd
- Replies: 1
- Views: 2338
REST API: DimensionElementComponentAdd
Hi I'm using the REST API to create a dimension hierarchy. I'm using below syntax to connect an element to a consolidated node, which works as expected. Body: {"Element":{"Name": "New Element", "UniqueName":"[plan_business_unit].[New Element]"}} POST...
- Wed Mar 06, 2019 11:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX REST API
- Replies: 5
- Views: 3998
Re: PAX REST API
Thanks again macsir, I'm getting closer. :) The Get and Delete request works, but I'm struggling a bit with Post, getting an error message. The documentation talks about 'payload' , as 'The JSON payload that you are storing or updating to the TM1 Server' . What does it mean, is it maybe the same as ...
- Tue Mar 05, 2019 1:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API: consolidated elements without children
- Replies: 8
- Views: 6202
REST API: consolidated elements without children
Hi Sorry for a very basic (?) question, but this is still pretty new to me. I'm looking for a way to list all consolidated elements within a dimension without any children. Below syntax will retrieve all members (and number children) in the plan_business_unit dimension. Dimensions('plan_business_uni...
- Thu Feb 28, 2019 8:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX REST API
- Replies: 5
- Views: 3998
Re: PAX REST API
Thanks macsir!
Will give it a try later today.
Will give it a try later today.
- Wed Feb 27, 2019 11:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX REST API
- Replies: 5
- Views: 3998
PAX REST API
Hi Gurus! Struggling a bit to get the PAX REST API to work. Below is the syntax for the GET request, but I can't find any references (in the documentation, or on the web) to JSONObjectWrapper or JSONParser . Where can I find these, do you know? Public Function oDataGet(path As String) As JSONObjectW...
- Wed Apr 11, 2018 8:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI: Process Options - Rebuild sheet
- Replies: 3
- Views: 2785
Re: TI: Process Options - Rebuild sheet
Yes, I'm running the two versions in parallel on two servers, and it's a clear difference. This is an issue in my case as I want to display a dynamic success message. My process reads data from a DW, and I store # read transactions in a log cube. A DBRW will retrieve this information, which will the...
- Tue Apr 10, 2018 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI: Process Options - Rebuild sheet
- Replies: 3
- Views: 2785
TI: Process Options - Rebuild sheet
Hi all
Noticed a change in when a success/failure message is shown, before or after the sheet is rebuilt. In 10.2.2 the message is shown after the sheet is rebuilt, in PA 2.0 (11.1.0.30) it's shown before.
Have you run into this, is it a bug/new feature?
Noticed a change in when a success/failure message is shown, before or after the sheet is rebuilt. In 10.2.2 the message is shown after the sheet is rebuilt, in PA 2.0 (11.1.0.30) it's shown before.
Have you run into this, is it a bug/new feature?
- Tue Nov 14, 2017 10:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Empty rows in text file
- Replies: 4
- Views: 3763
Re: Empty rows in text file
Maybe not the most efficient way to do it, but this is the syntax I use. It inserts a '#' for each empty row in the source file, and stores the end result in a new text file. @(For /F "Tokens=1*Delims=:" %%A In ('FindStr/N "^" %1 ' ) Do @If "%%B"=="" (Echo #) ...