TM1 Forum

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

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.

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 ?

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

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

whitelillie: apologies for hijacking your thread ! Whenever you might have a question or doubt, feel free to ask.

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

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.

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

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

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

kavitha2002 wrote: ↑

Mon May 06, 2019 2:31 pm

Hope you are workless

Will this (not even funny) comment stay, or will you delete your own non-sense posts afterwards ?

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

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

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

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.

Hello

Would it be possible to check it in version 2.0.7 please ?

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

I can use it in 2.0.6. on my laptop. It's 11.4 (tm1s.exe = 11.4.0.21)


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

Wim

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