Search found 416 matches

by PavoGa
Wed Apr 08, 2020 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through custom views/subsets
Replies: 5
Views: 52

Drill Through custom views/subsets

I have all but given up on using drill throughs anymore as the inability to get RETURNVIEWHANDLE to return a customized view has become an albatross. I have a somewhat cumbersome technique that seemed to work in 2.0.5, but have heard that has even gone away in 2.0.8 Is anyone still customizing drill...
by PavoGa
Tue Apr 07, 2020 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write to range of cells within TM1 Cube
Replies: 9
Views: 196

Re: How to write to range of cells within TM1 Cube

CellPutProportionalSpread will not perform very well. In my testing it is a performance dog compared to looping. I very much like the idea of it, but there are simply faster ways of doing what you are describing.
by PavoGa
Tue Apr 07, 2020 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element count in a hierarchy
Replies: 6
Views: 87

Re: Element count in a hierarchy

I believe Bedrock offers a process that does exactly this: bedrock.hier.unwind.pro . Might want to check it out. However, to answer the question of determining the number of elements in a consolidation or hierarchy, this will do it efficiently: dimDimName = 'SomeDimensionName'; subDimName = EXPAND('...
by PavoGa
Wed Apr 01, 2020 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent...Aliases???
Replies: 1
Views: 75

Re: Persistent...Aliases???

Okay, this appears to have been discussed in other threads, just did not catch one of them. Apparently forcing a dimension recompile is at least one method for resolving this.

Still think it should be fixed. 8-)
by PavoGa
Tue Mar 31, 2020 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent...Aliases???
Replies: 1
Views: 75

Persistent...Aliases???

Ran into some issues with aliases that had supposedly been cleared, or could not be reassigned to another element. So wrote a process (FINDER) that, for a given alias value, loops through dimensions and hierarchies testing for the alias' existence, the alias it exists in, primary element name and th...
by PavoGa
Thu Mar 05, 2020 1:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updateing Model to Hierarchys
Replies: 4
Views: 429

Re: Updateing Model to Hierarchys

To be sure, one can have leaf elements in an alternate hierarchy that are not in the base/default hierarchy. We run a process against our dimensions with alternate hierarchies to ensure any leaf elements in an alternate hierarchy are added to a special consolidation in the base so that they are avai...
by PavoGa
Fri Feb 28, 2020 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess in a scheduled chore causes server crash
Replies: 3
Views: 339

Re: RunProcess in a scheduled chore causes server crash

This may have been brought up before, so forgive me if that is the case. Looks like using RunProcess in a process executed by a scheduled or startup chore will crash the server. For which version? You have two specified in your profile. I have a bunch of scheduled chores which use RunProcess and I'...
by PavoGa
Wed Feb 26, 2020 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess in a scheduled chore causes server crash
Replies: 3
Views: 339

RunProcess in a scheduled chore causes server crash

This may have been brought up before, so forgive me if that is the case. Looks like using RunProcess in a process executed by a scheduled or startup chore will crash the server. I'd run into this before and forgot about it, then it happened again when the same changes were made to use RunProcess in ...
by PavoGa
Thu Feb 20, 2020 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 426

Re: Ruled cell not released for write

To correct my earlier statement, because it may be partially incorrect: the update to the version is not committed for the Import process because the attribute update and Import are all within the Prolog procedure . You may be able to resolve your problem by simply moving the import to the Epilog. O...
by PavoGa
Thu Feb 20, 2020 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 426

Re: Ruled cell not released for write

What I think is happening is that attribute change is uncommitted data within the YEPro transaction and therefore when the Import process runs, the rules are still seeing the Active Flag as "Y" on the previous version. The attribute change is not committed until YEpro completes. You can test this ra...
by PavoGa
Mon Feb 17, 2020 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8263

Re: RunProcess explanation

I've run out of ideas. I do not see this behavior ever where the master process finishes AFTER all the sub-processes it executes with RunProcess have completed. And it really is not really close as it finishes a fraction of a second after both kicking off the last process and when that process finis...
by PavoGa
Mon Feb 17, 2020 3:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8263

Re: RunProcess explanation

One last question: What is your MTQ setting the config file?
by PavoGa
Mon Feb 17, 2020 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8263

Re: RunProcess explanation

A little surprised at one thing in your first log output. None of the subprocesses finished after the main process . Off the top of my head, I do not recall that happening any time I've been testing RunProcess. Even if I kicked off say a half-dozen subs, some are going to finish after the main proce...
by PavoGa
Fri Feb 14, 2020 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Writing a Single Dynamic TI process to load data from multiple files
Replies: 4
Views: 305

Re: Writing a Single Dynamic TI process to load data from multiple files

As Wim says, it overrides the DataSource tab settings, but the settings on the variables tab remain. For example, take the following SQL query on the DataSource tab: --for Oracle SELECT '1' AS vTheNumberOne, '2' AS vMySecondVariable FROM DUAL If not overridden, these variable names are the ones set ...
by PavoGa
Thu Feb 13, 2020 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 560

Re: RunProcess, parameters and NOW bug

I've edited the above post a few times already as I keep thinking of extra steps to test. If I pass 1.2344567778 * 1000000 from the parent process it gets truncated in the child's asciioutput. So its as if the runprocess seems to back trace any numeric value to its starting point and assess whether...
by PavoGa
Thu Feb 13, 2020 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 560

Re: RunProcess, parameters and NOW bug

... 3/ Convert the Now to String before passing in string parameter = THIS WORKS! 4/ Directly passed a numeric value that was hardcoded in parent process = still truncates everything after first decimal ... So as far as I can see its a definite bug - it doesn't impact passing of most numeric values...
by PavoGa
Thu Feb 13, 2020 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 560

Re: RunProcess, parameters and NOW bug

Has nothing to do with precision. The test was a simple SLEEP(variable.ms.seconds) before the ending time call to NOW. I failed to mention that substitute ExecuteProcess for RunProcess and the values are passed with no problem. Multiplying the variables and/or NOW simply resulted in a ripping of the...
by PavoGa
Thu Feb 13, 2020 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 560

RunProcess, parameters and NOW bug

Have found what I consider a bug when passing parameters to a subprocess called by RunProcess . If one is passing a variable initialized by NOW or passing NOW directly to the parameter (see below for an example), the value used in the subprocess is a number, but is not the actual value of NOW in the...
by PavoGa
Fri Feb 07, 2020 7:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 20
Views: 13599

Re: RunProcess and Process Ends msg

I don't want to have a bunch of parameters to give information from one process to its sub, so to avoid this, I have implemented a set of global variables ("is this a chore?", "which chore?", "path to folder containing txt files that have to be wildcardsearched", etc). During testing, however, I ha...
by PavoGa
Fri Feb 07, 2020 4:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8263

Re: RunProcess explanation

I setup the same test. Created a subset on a dimension with 50 members, ran a subprocess with RunProcess passing parameters, wrote those parameters to a cube and they all showed up as expected. The master process started (from the server log) at 16:02:14.584 and last subprocess completed at 16:02:14...