Search found 13 matches

by HyunaHyuna
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: 3503

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...
by HyunaHyuna
Mon Feb 10, 2020 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 22
Views: 83735

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 ...
by HyunaHyuna
Fri Feb 07, 2020 2:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 22
Views: 83735

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....
by HyunaHyuna
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: 21419

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!
by HyunaHyuna
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: 21419

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...
by HyunaHyuna
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: 21419

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...
by HyunaHyuna
Tue Jul 10, 2018 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Dependency impact on performance
Replies: 10
Views: 10209

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...
by HyunaHyuna
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: 10776

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 ...
by HyunaHyuna
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: 10776

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"...
by HyunaHyuna
Thu Mar 01, 2018 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 5653

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) ...
by HyunaHyuna
Wed Feb 28, 2018 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 5653

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...
by HyunaHyuna
Wed Feb 28, 2018 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 5653

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