TM1 Forum

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

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

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

MarenC wrote: ↑Thu Feb 06, 2020 5:46 pm

When you say look at the logs, you mean the server log?

regards,
Maren

Yes, the server log.

Have you looked in the log file and determined how many of the multi-threaded processes are finishing after the main process finishes? If the master process is executing a view or cube zero out, then executing the RunProcesses, that may be the problem. The master process's "transaction" is...

Oh so this stops server crashes for invalid members, in that case a welcome improvement, given I have fallen foul of this when I first started out on TM1! It is the StrToMember function that crashes the server when presented with an invalid member, at least in our version. Rumors are it has been re...

Hi, Yes I see this too. I can't imagine a situation where I would allow a non existent element to be included in the MDX but things like this does give cause for caution when using MDX! The only way I can get the statement to error is if I take off the dimension prefix, so instead of [Time].[2020_1...

Take the following MDX statement on a cube value: FILTER( TM1SUBSETALL( [Product] ), [Sales].([Time].[2020_17], [Sale.m].[Dollars]) > 0) In this case, assume that [Time].[2020_17] is not a valid element in the Time dimension. This query will execute and may actually return a subset. What it does is ...

There are two of us who use VIM :mrgreen: and possibly only two of us silly enough to directly edit .pro files. Thanks for sharing - will have a look and feedback what I can. FWIW, I told bgregs I was an old vi guy in the UNIX/dumb terminal past, but Notepad++ is my buddy for the last few years. Ne...

If I understand, you need to be able to calculate the total hours between two given dates. Typically, your first date is anchored to the beginning of the fiscal year. Here is a solution that allows the calculation between any two dates along a continuous timeline. Using a TI, populate each day's hou...

Good stuff. Thanks.