Search found 64 matches

by ykud
Tue Jan 07, 2020 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More info on TM1Project.json file
Replies: 7
Views: 836

Re: More info on TM1Project.json file

Hello! Yes, using the (not) !ignore feature. But you have to save the tm1project settings before doing a git pull. I didn't get to play a lot with the tm1project setting because I didn't have time and the bad documentation also discourages me. Thanks heaps! That document is indeed very confusing an...
by ykud
Mon Jan 06, 2020 5:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More info on TM1Project.json file
Replies: 7
Views: 836

Re: More info on TM1Project.json file

So you have to manually list one by one if you want them included in the git as well, which is very annoying because when you're moving new dimensions between servers, its attributes will not be transferred unless you specify each "}ElementAttributes_Dimension" cubes to be transferred as well. Hi t...
by ykud
Fri Dec 27, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW and PVU
Replies: 11
Views: 409

Re: PAW and PVU

The following link confirms it as well. PAL is the principle program and PAW is a supporting program. https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/646ACC12EEC9382C8525843F006ADB8D?OpenDocument Program Name (Program Number): IBM Planning Analytics Local TM1 Server 2.0.8 (5737-B03) IBM Plan...
by ykud
Wed Dec 11, 2019 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 324

Re: Temporary views surviving their TI process

Somehow it didn't make it to the front pages of 'What's new in PA XXX', but it's there in the documentation: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/r_tm1_ref_tifun_viewcreate.html TM1® Server version 11.2.0 and earlier, temporary view...
by ykud
Wed Nov 20, 2019 10:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 337

Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

We saw something similar in one of the models and unfortunately, there wasn't any real solution, we just had to 'commit' locks in different parts of the process earlier by running each portion as it's own RunTi with ExecuteCommand(...,1). Can you try running this process in the TIDebugger and see wh...
by ykud
Tue Oct 29, 2019 6:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW on Linux better performance?
Replies: 10
Views: 2914

Re: PAW on Linux better performance?

gtonkin wrote:
Tue Oct 29, 2019 6:10 am
ykud wrote:
Tue Oct 29, 2019 12:40 am
...being able to use community docker is one of the main reasons next version of PA will support CentOS, afaik.
PAW 2.0.46 supports CentOS see this note.
Awesome, thanks!
by ykud
Tue Oct 29, 2019 12:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW on Linux better performance?
Replies: 10
Views: 2914

Re: PAW on Linux better performance?

Haven't had a chance to compare performance yet, so a bit off-topic: Make sure you check licensing implications, as far as I understand, Enterprise Docker on RHEL requires a license. And community docker is not available on RHEL. being able to use community docker is one of the main reasons next ver...
by ykud
Sat Oct 19, 2019 11:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 16
Views: 10953

Re: RunProcess and Process Ends msg

I'm starting to think that a sqllite instance to store the flags with guaranteed read / write might be better at large scale. I find this idea quite interesting. But in exactly the kind of scenario where immediacy of file writes might be problemantic with lots of multi-threadig and dozens of TIs ru...
by ykud
Mon Oct 14, 2019 11:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 16
Views: 10953

Re: RunProcess and Process Ends msg

I second Declan's suggestion. File based semaphores are really the only way to go when running processes on independent threads. Reading a cell value (or attribute value) is vey tricky to get right because of TM1's commit model and which version of the data your monitoring process is rteading versu...
by ykud
Thu Aug 15, 2019 9:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 4461

Re: Lock Contention and RollBack

Hi mce,

Did you end up figuring out the root causes of it? What version of PA you’re seeing this in?
We see something similar (although not consistently) on PA 2.0.6 if 19.

Y
by ykud
Thu Aug 15, 2019 12:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Views - Can Non Admin Users Create them
Replies: 3
Views: 1410

Re: Public Views - Can Non Admin Users Create them

Create a TI that runs PublishView with view name as a parameter and give users read access to this process. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_publishview.html Throw in a nice websheet to select the views to publish and...
by ykud
Tue Jul 16, 2019 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 18098

Re: Planning Analytics using twice the memory of 10.1

I’ll just leave it here for anyone finding this thread later: another reason for memory growth is that PA is preloading all the views and subsets definitions on startup, whereas 10.2.2 didn’t do that. There will be a parameter in tm1s.cfg to disable this behaviour in future releases, but you can che...
by ykud
Tue Jun 04, 2019 3:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 889

Re: Method for handling Rules for Actuals/Forecast periods

I usually do something simple like:

Code: Select all

[{'Forecast Version1','Forecast Version 2', etc for live versions}] = IF (DB(LookupCube(!Version, !Month, 'is Actual') = 1, ['Actual], CONTINUE);

FEEDERS;
['Actual'] => ['Live Versions'];
by ykud
Wed May 08, 2019 6:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 6295

Re: RunProcess and threads

But I do not agree that the processes of orchestration are not solved. In our production environment there are several solutions for sequential queues, one based on files, the other based on a cube of queues, both work (I note that a solution based on a cube is rather complicated, but it works!) Wh...
by ykud
Mon May 06, 2019 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 6295

Re: RunProcess and threads

As I said, process A and B would have their own transaction sets, so would not see the changes made by the other process. The process that finishes last commits its changes last. Thank you very much for confirming this. To get back to Yuri's point about controlling or orchestrating batch processes....
by ykud
Fri Apr 26, 2019 4:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 6295

Re: RunProcess and threads

Can I also jump on with some questions on RunProcess (don't have 2.0.6 to test yet): what's with transaction isolation in RunProcess? A simple test is to start with an empty cube with 1 cell. Process A: 1) CellPutN 1 into that cell 2) RunProcess (B) 3) CellGetN that cell in a loop for a minute (does...
by ykud
Thu Apr 04, 2019 3:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 970

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Does TM1Web work with https, only contributor fails? I find IKeyMan a lot simpler to use than ThirdPartyCert tool, it can show contents of your cacerts and highlight whether there are any issues with imported certificate (for example, it's missing the whole authority chain or is not trusted). http:/...
by ykud
Mon Mar 18, 2019 12:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 12
Views: 1996

Re: TM1 report bursting

- If I schedule the task to run at a certain point in time, so scheduled, and I am logged on: it works fine. Can you see under what user 'excel.exe' process is running in this case? Yours or the one you set up in Scheduled tasks? Interactive Identity setup will launch excel under your account, spec...
by ykud
Sat Mar 16, 2019 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 12
Views: 1996

Re: TM1 report bursting

This works perfectly if me or anyone else is logged on to the server when the TI process executes the vbscript. However, in the case of NO USER being logged on to the server at that time, it does not work completely. I don't understand why. It seems that the Application.Run "TM1REFRESH" or "TM1RECA...
by ykud
Thu Feb 28, 2019 1:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 11
Views: 1094

Re: Manage Rights when a big chunk of elements are deleted

Hi Elessar, Thanks for the reply. It takes about an hour for SecurityRefresh normally. On PA 2.0.4 and 2.0.6, it takes about 1.5 hours. Since it was taking longer, I asked IBM and they gave us an interim fix and that does not complete securityRefresh. It stops before completing with an error as bel...