TM1 Forum

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

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.

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

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.

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

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

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

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

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

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

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

One last question: What is your MTQ setting the config file?

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

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

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

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

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

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

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

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