Search found 26 matches

by Dimix
Wed Jul 03, 2019 7:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Cloud
Replies: 2
Views: 186

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: 2
Views: 186

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: 428

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

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: 428

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: 572

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

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: Dimensions('plan_business_unit')/Hierarchies('pl...
by Dimix
Wed Mar 06, 2019 11:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX REST API
Replies: 5
Views: 504

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: 486

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: 504

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: 504

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: 666

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: 666

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 666 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: 1204

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 #) Else Echo %%B)>%2
by Dimix
Tue Nov 07, 2017 3:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rows in text file
Replies: 4
Views: 1204

Re: Empty rows in text file

Thanks Wim, good idea.
by Dimix
Tue Nov 07, 2017 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rows in text file
Replies: 4
Views: 1204

Empty rows in text file

I have a TI process that reads a text file (in this case a .rux file), and I'm using the following settings: Capture.PNG The preview indicates that there are empty rows in the text file: Capture2.PNG However, empty rows seems to be ignored when processing the file in the MetaData/Data tab. This is p...
by Dimix
Mon Oct 09, 2017 5:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CubeDataReservationAcquire
Replies: 0
Views: 839

CubeDataReservationAcquire

I'm working on a customized workflow for a customer, and for that purpose I use CubeDataReservationAcquire to take ownership. It works great in TM1 10.2.2, but I can't get it to work in Planning Analytics 2.0. A simple test that describes the issue: TM1 10.2.2 sUser = 'Donald'; sCube = 'Profit_and_L...
by Dimix
Tue May 30, 2017 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VB/VBA API
Replies: 1
Views: 835

VB/VBA API

Hi all I have just started to explore the VB/VBA API, and I can see a huge potential for this type of functionality. Just wonder, is it worth the time and effort to learn this version of the API, or should I maybe go for the new REST API instead? How many of you are using the VB/VBA API, are there a...
by Dimix
Wed Mar 22, 2017 10:09 am
Forum: OLAP Jobs
Topic: TM1 Consultant - Stockholm, Sweden
Replies: 3
Views: 2256

Re: TM1 Consultant - Stockholm, Sweden

Good point Jim! No, Swedish is not a requirement, TM1 is the universal language. ;)
by Dimix
Tue Mar 21, 2017 8:59 pm
Forum: OLAP Jobs
Topic: TM1 Consultant - Stockholm, Sweden
Replies: 3
Views: 2256

TM1 Consultant - Stockholm, Sweden

We at Intito, the leading TM1 partner in Sweden, are looking for an experienced TM1 consultant to join our highly motivated and driven team in Stockholm. We expect you to have 2-3 years of hands-on experience as a TM1 developer or administrator/super user. Please contact Rickard Rygin for more infor...