Search found 82 matches

by MarenC
Thu May 28, 2020 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 log file delete
Replies: 6
Views: 461

Re: tm1 log file delete

ykud had done very well not to have become an MVP! :D
by MarenC
Sat May 23, 2020 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Naming Conventions Elements
Replies: 2
Views: 104

Naming Conventions Elements

Hi,

I try to avoid special characters in principal dimension element names but should I extend this to aliases?

Maren
by MarenC
Fri May 22, 2020 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 11
Views: 992

Re: @= in active sheet formula

Hi Steve,

I just removed the hyperlink from the cell and that seemed to sort it

Maren
by MarenC
Tue May 19, 2020 9:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cell Annotation
Replies: 2
Views: 230

Re: Cell Annotation

Hi Wim,

Yes, a cellputs to the target version.

I was expecting that I would have had to manipulate the string somehow to replace the source version with the target version, but to my surprise it simply worked by doing a cellputs without me having to alter anything.

Maren
by MarenC
Tue May 12, 2020 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cell Annotation
Replies: 2
Views: 230

Cell Annotation

Hi, I wanted to create a process to copy comments made in workspace between versions and it was much easier than I imagined it would be. Basically all I did was create a view of the }CellAnnotations_TestCube and copy the value for the source version into the target version. When I first looked at th...
by MarenC
Fri Apr 24, 2020 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Suggestion - TM1 Performance Modeler or Planning Analytics
Replies: 8
Views: 1896

Re: Need Suggestion - TM1 Performance Modeler or Planning Analytics

Hi, I keep reading/hearing that performance modeler will soon be dead or that it can cause issues by activating it. Generally I hear that the advice is to avoid it like, well the plague! ;) But my understanding is that to work with metric cubes you need to do this in Performance Modeler, so I guess ...
by MarenC
Thu Apr 23, 2020 12:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException
Replies: 16
Views: 567

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

I would narrow down the focus to security and Certificates. I wish I could be more specific!

Maren
by MarenC
Fri Apr 17, 2020 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Logical Operator as paramater
Replies: 1
Views: 627

Logical Operator as paramater

Hi, is it possible to have a parameter for a logical operator and pass this into the TI code. So for example, pOperator is > And in the TI code the formula would be: If(1 pOperator 2); Do something; Endif; I want to create a process that can dynamically cater for different operators and was looking ...
by MarenC
Wed Mar 04, 2020 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cell Type is Real weirdness
Replies: 2
Views: 604

Re: Cell Type is Real weirdness

Hi Tomok,

yes it makes perfect sense to me now! :D

Maren
by MarenC
Wed Mar 04, 2020 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cell Type is Real weirdness
Replies: 2
Views: 604

Cell Type is Real weirdness

Hi, I have a process with the following logic on the Prolog: vAdminCube = 'Admin Cube'; vDay = cellgets(vAdminCube, 'Actuals', 'Current Year', 'Day'); sFile='C:Path\testday.txt'; If( vDay @= '03' ); Asciioutput(sFile, 'Test Output'); Endif; The above errors with the message Cell Type is Real. This d...
by MarenC
Wed Feb 26, 2020 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess in a scheduled chore causes server crash
Replies: 4
Views: 531

Re: RunProcess in a scheduled chore causes server crash

Hi Pavoga,

I encountered this very issue last week and saw the exact same message in the server log.
I was going to raise an issue on the forum but thought I had used up enough of peoples time with RunProcess questions!

Maren
by MarenC
Thu Feb 20, 2020 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 628

Re: Ruled cell not released for write

Hi, I tried this but in just a single process. So the Version had flag Y against attribute ActiveVer and the cells were rule based. In the process, I refer to a cube view that references the Active version. On the Prolog I update the attribute to make ActiveVer = n and then on the data tab I cellput...
by MarenC
Wed Feb 19, 2020 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

I have appreciated your help on this PavoGa. The MTQ didn't do anything, so I will post back if anything comes of this.

And yes I have been looking at the other RunProcess thread

Maren
by MarenC
Wed Feb 19, 2020 5:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Information on DebugUtility
Replies: 5
Views: 2723

Re: Information on DebugUtility

Hi, does this really Obfuscate data?

Because I just tested it and it didn't seem to do anything like that, it just seemed to take a copy of the cub file

Maren
by MarenC
Mon Feb 17, 2020 4:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

Hi Pavoga, MTQ = -2. "One last question on the first run, what executions actually wrote to the cube? The first nine, the last nine or some random selection?" Always seems to be the First n number, so in the case I posted previously the first 9 but I have just rerun the process and this time the fir...
by MarenC
Mon Feb 17, 2020 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

Ok thanks, I may be well past the point where anyone can help but PavGo did ask me to provide the server log output and that is all I have done.

Will contact IBM and feedback if I get anywhere.

Maren
by MarenC
Mon Feb 17, 2020 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 User Locks
Replies: 2
Views: 285

TM1 User Locks

Hi, I just a few questions about TI process locking. I am asking this because I want to build a number of user processes that users can run on the web and want to know how to avoid any locking. Please assume that Parallel Interaction is enabled. Example A (no meta data updates): I create a process t...
by MarenC
Mon Feb 17, 2020 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

Hi, I ran the Master process, which simply has RunProcess('calledProcess', pEmpID) repeated on 47 lines The called process simply has Cellputn 1 on the Prolog. I have looked in the Server Log and it it repeated 9 times, i.e. not 47 times as it should have been, as below: 11052 [2] INFO 2020-02-17 09...
by MarenC
Fri Feb 07, 2020 5:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

Hi, thanks for your testing! I can confirm that there is no other code at all in either process. There are simply 2 processes, the master has 47 runprocess statements on the prolog and the called process has 1 cellput statement, using the pEmpid parameter. And in the cfg file ParallelInteraction=T. ...
by MarenC
Thu Feb 06, 2020 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

Hi, I simplified the process so it doesn't use any View creation whatsoever. It simply does a cellputN for each employee passed into the parameter as per my previous comment - the code in my previous comment is all the code there is. I literally have 47 runprocesses in the master process and a cellp...