Search found 2016 matches

by Wim Gielis
Tue May 21, 2019 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI summary display
Replies: 2
Views: 280

Re: TI summary display

Hello, Do you have the cube, that will capture the process run details, set up ? What dimensions do you have in that cube ? The idea is that every process should have code near the top of the Prolog tab to capture the starting time. A variable will be perfect. Then, in the Epilog tab, you record the...
by Wim Gielis
Mon May 20, 2019 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RestAPI View has less figures Ascii Export
Replies: 5
Views: 381

Re: RestAPI View has less figures Ascii Export

Or open up both exports in Excel, one below the other. Make sure the same columns are used in the same order. Then multiply 1 set of values with -1 and create a pivot table. The differences will remain.
by Wim Gielis
Mon May 20, 2019 10:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RestAPI View has less figures Ascii Export
Replies: 5
Views: 381

Re: RestAPI View has less figures Ascii Export

Hello,

What kind of cells are contained in the view ? Level 0 / consolidated / string. Rules-calculated or not ? Fed or not ?

Can you make the view smaller to identify the gaps and find a pattern ?
by Wim Gielis
Thu May 09, 2019 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access denied to cells for non admin users in TI Logs
Replies: 3
Views: 140

Re: Access denied to cells for non admin users in TI Logs

it then works out which groups they are in and then checks the security at cube, dimension, and element level as well as cell security Adding up rights for a user over his/her groups, is indeed the real advantage and benefit. Anything related to that in TM1/PA to help admin users there would be an ...
by Wim Gielis
Wed May 08, 2019 12:53 pm
Forum: Useful code, tips and tricks
Topic: Checking the data source of a TI process
Replies: 2
Views: 1378

Re: Checking the data source of a TI process

Hi all, Here is an updated version, much improved. TECH_check data source.pro New functionality is a simple choice for AsciiOutput and/or LogOutput and/or sending an email. Sending an email is there, it would use a helper TI process and supply a number of parameters, that you can / have to whip up y...
by Wim Gielis
Tue May 07, 2019 6:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 292

Re: TI - Add new element in alphabetical order under consolidation

whitelillie: apologies for hijacking your thread ! Whenever you might have a question or doubt, feel free to ask.
by Wim Gielis
Tue May 07, 2019 4:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 292

Re: TI - Add new element in alphabetical order under consolidation

I never had perfomance issue with SaveDataAll Start recreating feeders file of about 10GB each and you will see savedata of about 30 minutes. During business hours this is unacceptable. It will be a CubeSaveData of }DimensionProperties but not sure how this function will allow us to solve the probl...
by Wim Gielis
Tue May 07, 2019 3:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 292

Re: TI - Add new element in alphabetical order under consolidation

Thanks CellPutN.
What is the use of the SaveDataAll ? Could it be a CubeSaveData of the respective }ElementAttributes cube ?
In some bigger models I have in mind, I don't fancy a SaveDataAll. Or maybe a control cube for dimension properties.
by Wim Gielis
Tue May 07, 2019 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 292

Re: TI - Add new element in alphabetical order under consolidation

About active forms: I don't hate them anymore. We will never become good friends but we accept each other. For the dimension edits: I brought up the case of projects and customers because I inherited a TM1 model for keeping timesheets data (hours spent), which then generates invoices based on that. ...
by Wim Gielis
Tue May 07, 2019 10:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 292

Re: TI - Add new element in alphabetical order under consolidation

Normally you would use an artificial key for this; something like an employee ID code from the HR module. You can use the name as an alias. You can then use MDX to create sorted subsets which put the elements into the order that you want. True. But start using consolidations to collapse and expand ...
by Wim Gielis
Mon May 06, 2019 10:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Views
Replies: 6
Views: 127

Re: Cube Views

Alan Kirk wrote:
Mon May 06, 2019 8:41 pm
This is of course ridiculously cumbersome if you have a long list of cubes and the one that has the view is right down the bottom.
Lotsaram to the rescue !
https://www.tm1forum.com/viewtopic.php? ... ion#p61981
by Wim Gielis
Mon May 06, 2019 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 860

Re: Cognos Analytics 11.0.13

kavitha2002 wrote:
Mon May 06, 2019 2:31 pm
Hope you are workless :lol: :lol: :lol:
Will this (not even funny) comment stay, or will you delete your own non-sense posts afterwards ?
by Wim Gielis
Mon May 06, 2019 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 860

Re: Cognos Analytics 11.0.13

Hi Kavitha, I would like to request a fully documented install document for PAW and PAX - screenshots and explanations included. Take TM1 server too, as well as docker stuff. Windows and Unix please where applicable. Kindly give it to me. Don't complain. Thanks in advance. Oh, I'm in a hurry, please...
by Wim Gielis
Mon May 06, 2019 7:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 860

Re: Cognos Analytics 11.0.13

I believe people post the question in a hurry, they cant write the entire story behind why they ask this question and steps of attempt they did, its unnecessary. Here in this forum, I am expecting the answers not the comments/advice. Seriously :o :shock: :?: That's enough material to end up on pers...
by Wim Gielis
Thu May 02, 2019 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 303

Re: REST API: Space

Also in 2.0.7 (server version 11.5) I get this error: { error: { code: "278", message: "Syntax error at position 39, near "attribute" for $expand query option: Expecting ')' token." } } for the URL: http://localhost:8001/api/v1/Dimensions('SGA_Account')/Hierarchies('SGA_Account')/Members('1000LONEN'...
by Wim Gielis
Wed May 01, 2019 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 303

Re: REST API: Space

I would expect %20 as well, also given this page:
https://www.ibm.com/support/knowledgece ... chars.html
But I cannot get it to work either.
by Wim Gielis
Tue Apr 30, 2019 7:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 19
Views: 571

Re: RunProcess and threads

Hello

Would it be possible to check it in version 2.0.7 please ?
by Wim Gielis
Mon Apr 29, 2019 7:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New version available
Replies: 0
Views: 242

New version available

Hello all, IBM Planning Analytics Local release 2.0.7 and the cloud release of IBM Planning Analytics 2.0.7 includes updates and new features for IBM TM1 Server version 11.5.0. Awaiting the moment when Alan Kirk adds this information to the sticky thread, please refer to this page for more details o...
by Wim Gielis
Fri Apr 26, 2019 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 19
Views: 571

Re: RunProcess and threads

I can use it in 2.0.6. on my laptop. It's 11.4 (tm1s.exe = 11.4.0.21)
01.png
01.png (19.43 KiB) Viewed 453 times


2.0.7 should be out either today, either early next week - so I have been told by someone from IBM.

Wim
by Wim Gielis
Fri Apr 26, 2019 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Auto Recalculate for Cube Viewer
Replies: 5
Views: 256

Re: Auto Recalculate for Cube Viewer

I was looking at a way to do this using the TM1 REST API. With this command: http://localhost:8001/api/v1/Cubes('JM')/Views('Default') I find the details of the Default view on the JM cube. I get back: { @odata.context: "../$metadata#Cubes('JM')/Views/ibm.tm1.api.v1.NativeView/$entity", @odata.etag:...