Search found 6 matches

by danz
Thu Jun 20, 2019 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel dynamic name range chart not refreshed in TM1 web
Replies: 0
Views: 5749

Excel dynamic name range chart not refreshed in TM1 web

I have set up a dynamic name range referencing a range of data which use Offset to reference ActiveForm data. Dynamic range similar to below Capture.PNG Then I created a pie chart based on the name range. In Excel, I change SUBNM selection and rebuild, the ActiveForm updates and so as the pie chart,...
by danz
Thu Jun 20, 2019 10:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI load txt file - retrieve incomplete records
Replies: 2
Views: 661

Re: TI load txt file - retrieve incomplete records

Wim thanks for your reply.

I have resolved the problem during the day, it was a Char Quote causing some data been misread.
by danz
Wed Jun 19, 2019 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI views using alternate hierarchies
Replies: 5
Views: 1078

Re: TI views using alternate hierarchies

BTW the next PA " Ask me Anything " session is TODAY. It is worth joining Hi Alan I have a REST API question and it relates to one of your post (which the Reply function is locked), what is the best way to ask you? I have tried sending IM from back end to Site Admin but didn't seem to get to you. T...
by danz
Wed Jun 19, 2019 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI load txt file - retrieve incomplete records
Replies: 2
Views: 661

TI load txt file - retrieve incomplete records

Hi all I have a txt file generated from SAP (Encording UTF-8-BOM), open in Notepad++ shows there are 2.4m lines (3 columns, Tab delimited). Try to read it with TI and to count number of records, I get 1.4m+. Where is the other 1m records???? Anyone come across similar issue before???? Appreciate if ...
by danz
Mon Jun 17, 2019 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API - tm1.Execute return 278 error
Replies: 2
Views: 1072

Re: TM1 Rest API - tm1.Execute return 278 error

Spot on! Thanks very much Mike
by danz
Mon Jun 17, 2019 4:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API - tm1.Execute return 278 error
Replies: 2
Views: 1072

TM1 Rest API - tm1.Execute return 278 error

I recently started learning REST and been going through IBM Planning Analytics TM1 REST API pdf file. I run following request in Postman and receive 278 error. POST /api/v1/Cubes('Metrics cube-Sales')/Views('Metrics cube-Sales')/tm1.Execute?$expand=Cells { "error": { "code": "278", "message": "The c...