Search found 32 matches

by Dimix
Thu Jan 27, 2022 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Subset and Alias
Replies: 2
Views: 12868

Re: REST API: Subset and Alias

Thanks Mike!
by Dimix
Mon Jan 24, 2022 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Subset and Alias
Replies: 2
Views: 12868

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') ...
by Dimix
Tue Mar 31, 2020 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Subset - element level
Replies: 1
Views: 1321

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...
by Dimix
Thu Sep 26, 2019 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX API: Refresh Sheet
Replies: 1
Views: 3488

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...
by Dimix
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: 14559

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...
by Dimix
Wed Jul 31, 2019 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Cloud
Replies: 5
Views: 5057

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.
by Dimix
Wed Jul 03, 2019 7:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Cloud
Replies: 5
Views: 5057

Re: REST API: Cloud

Thanks, will take a look at it.
by Dimix
Tue Jul 02, 2019 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Cloud
Replies: 5
Views: 5057

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...
by Dimix
Fri May 03, 2019 4:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 6627

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...
by Dimix
Thu May 02, 2019 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 6627

Re: REST API: Space

Thanks Wim and tomok. Maybe the easiest and quickest solution is to create an attribute without spaces.
by Dimix
Wed May 01, 2019 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 6627

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...
by Dimix
Mon Mar 11, 2019 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: DimensionElementComponentAdd
Replies: 1
Views: 2289

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...
by Dimix
Mon Mar 11, 2019 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: DimensionElementComponentAdd
Replies: 1
Views: 2289

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...
by Dimix
Wed Mar 06, 2019 11:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX REST API
Replies: 5
Views: 3922

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 ...
by Dimix
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: 6087

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...
by Dimix
Thu Feb 28, 2019 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX REST API
Replies: 5
Views: 3922

Re: PAX REST API

Thanks macsir!

Will give it a try later today.
by Dimix
Wed Feb 27, 2019 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX REST API
Replies: 5
Views: 3922

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...
by Dimix
Wed Apr 11, 2018 8:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI: Process Options - Rebuild sheet
Replies: 3
Views: 2668

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...
by Dimix
Tue Apr 10, 2018 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI: Process Options - Rebuild sheet
Replies: 3
Views: 2668

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?

TI.png
TI.png (6.98 KiB) Viewed 2668 times
by Dimix
Tue Nov 14, 2017 10:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rows in text file
Replies: 4
Views: 3558

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 #) ...