TM1 Forum

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,...

Wim thanks for your reply.

I have resolved the problem during the day, it was a Char Quote causing some data been misread.

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

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

Spot on! Thanks very much Mike

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": &quo...