Search found 13 matches
- Fri Jul 31, 2020 12:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Separate measure dimension for each cube VS one singular measure dimension for all cubes
- Replies: 7
- Views: 3542
Re: Separate measure dimension for each cube VS one singular measure dimension for all cubes
Thank you for the replies, I feel confident that I have enough talking points now!
- Wed Jul 29, 2020 8:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Separate measure dimension for each cube VS one singular measure dimension for all cubes
- Replies: 7
- Views: 3542
Separate measure dimension for each cube VS one singular measure dimension for all cubes
Hi, I am putting together a sort of best-practice document for the junior consultants of my team about how to effectlively work with TM1 (for example: why are comments important, how to write them, why is it good to use spaces in code, etc). I am mostly using Cubewise's Bedrock White Papers , and pr...
- Mon Feb 10, 2020 12:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 83929
Re: RunProcess and Process Ends msg
Since RunProcess operates by opening a separate thread, it has no connection to the Session or Global variables declared in the master process. Thank you kindly for this confirmation of my suspicions! I will do further research into how exactly global variables operate, to avoid being surprised by ...
- Fri Feb 07, 2020 2:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 83929
Re: RunProcess and Process Ends msg
Hi, I have built a bunch of new processes to replace our current solution with Rest API, using a lot of the solutions discussed above. I handle this by having the master process create a text file in a folder and pass the name of that file to the sub process (doing this for ever sub process it runs....
- Wed Aug 08, 2018 10:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to cancel a thread that cannot be cancelled in TM1 Top
- Replies: 25
- Views: 21703
Re: How to cancel a thread that cannot be cancelled in TM1 Top
Thank you for this info! We are moving to PA in the near future, so we'll just be extra careful till then. Kudos to you!
- Wed Aug 08, 2018 9:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to cancel a thread that cannot be cancelled in TM1 Top
- Replies: 25
- Views: 21703
Re: How to cancel a thread that cannot be cancelled in TM1 Top
Hi Paul, thank you for your reply! Our situation happened because we changed a line in a rule, and did not establish cube dependencies (we are relatively new to parallel interaction, and still struggle with how to determine what dependencies are needed in each case) before running a night load in pa...
- Wed Aug 08, 2018 7:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to cancel a thread that cannot be cancelled in TM1 Top
- Replies: 25
- Views: 21703
Re: How to cancel a thread that cannot be cancelled in TM1 Top
Tried this solution when we had parallel loads stuck because of a cube dependency being established while running. Unfortunately, it didn't work in that case. I wonder if it doesn't work when used for locks happening during parallel interaction, or just with locks caused by establishing cube depende...
- Tue Jul 10, 2018 9:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Dependency impact on performance
- Replies: 10
- Views: 10256
Re: Cube Dependency impact on performance
Hi all, I hope you forgive me for bringing back such an old topic. We implemented parallel loads a couple of months ago in a 10.2 with FP5, and now we are experiencing locks whenever feeders are changed in rule files (we are optimizing our rules and adding conditional feeders where needed, and these...
- Wed Mar 21, 2018 8:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: BatchUpdateStart and BatchUpdateFinishWait in master process
- Replies: 12
- Views: 10899
Re: BatchUpdateStart and BatchUpdateFinishWait in master process
Thank you for your reply :) I have edited out the detailed description of my problem, as I believe I have found a solution. Instead of using CellPutNs, I TextOutPut everything into a .csv file, and then import everything from there using a separate process. I just had to be sure to clarify the data ...
- Tue Mar 20, 2018 3:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: BatchUpdateStart and BatchUpdateFinishWait in master process
- Replies: 12
- Views: 10899
Re: BatchUpdateStart and BatchUpdateFinishWait in master process
Hi, I hope you don't mind me bringing this back. I am trying to have a master process execute other processes in parallel, and some of those need BatchUpdate. Here is what I am doing now: Master Process: ExecuteCommand('"(...)Hustle.exe" "\\(...)\FileThatParallelRunsProcessA.txt"...
- Thu Mar 01, 2018 8:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting changed data only - flag?
- Replies: 8
- Views: 5717
Re: Exporting changed data only - flag?
I get where you are coming from, but believe me when I say that I tried to verbalize my bundle of issues as best as I could. Please cut me some slack, I am a newbie, I will do better in the future. While we're talking about this, your replies were more about shouting at me (multiple question marks) ...
- Wed Feb 28, 2018 3:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting changed data only - flag?
- Replies: 8
- Views: 5717
Re: Exporting changed data only - flag?
Thank you for your responses! I apologize for some of the confusion I caused, I did mix up a few things and wasn't clear enough. The process imports data from DB, does a lot of data load between cubes, and then exports. The actual issue (again, sorry for not being clear enough at first, this is my f...
- Wed Feb 28, 2018 10:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting changed data only - flag?
- Replies: 8
- Views: 5717
Exporting changed data only - flag?
Hi! Here is an issue we have been facing pretty much since we started our project: We are currently loading all data from our TM1 10.2.2 to our DB every night (couple dimensions with 50+ elements), because we cannot narrow our subset of what to export down. Users might change any data at any time, b...