TM1 Forum

Have run into a brick wall with this: I have a dimension that has two elements that I want to swap the data between. Thought maybe using SwapAliasWithPrincipalName would do the trick and it does...until the server is restarted and the dimension elements appear to return to their original, un-swapped...

Here is a good discussion about handling rule-driven consolidations and techniques to use for the issue you describe.

http://www.tm1forum.com/viewtopic.php?f=3&p=1512#p1512

Thank you, both. So, how might one use TM1TupleSize? The only thing I can imagine is to validate a set before creating it, possibly when creating from TI (i.e. to avoid "Unable to register Subset...", for which there are other, more common workarounds. Trevor, that is the only thing I had ...

Got word that IBM has never even had a support call on it. So either I am a complete idiot and cannot comprehend the Reference Guide entry on it or no one uses it.

How does this function work and how would one use it? I have been unable to find an example of its usage.

I would suggest using Beyond Compare 4 vs Winmerge. If you are comparing a source code file against a TI process, Beyond Compare does a better job of ignoring irrelevant lines.

One more thing observed is that locking starts to happen after 35 to 45 secs after processes starts, so we concluded that its data tab that is causing issue. more over our temporary cubes differ by parameter passed during kickoff time. How do you know for certain it is locking and not just a slowin...

This might help with some ideas, it is a recent discussion on this very topic: http://www.tm1forum.com/viewtopic.php?f=3&t=12552 Additionally, are you writing to the consolidations with CELLPUTPROPORTIONALSPREAD? Did not sound like it, but thought it worth asking. Have you turned on log4j.logger...

For what it is worth, I have a TI process that rebuilds subsets from the *.sub files including those based on MDX. A little tweaking and you can substitute in your target dimension name. We use it to rebuild subsets on some of the control dimensions after a server restart. Just copy the sub files in...

Brian,

Finally got around to testing and reproduced the problem with the server crashing when using SYNCHRONIZED and Lock.Exception logging turned on. Turned logging off and SYNCHRONIZED worked perfectly.

Thanks!

For what it is worth, I use Notepad++ with a TM1 language file. When finished editing, just copy and paste into the basic editor.

Thanks, Brian. We do have the lock exception logging turned on and I'll try that later. With regards to the argument for the Synchronized function, I tried it both ways, with an existing object name and just a string value, both with the same result. Should have mentioned that. Thank again. If that ...

That's the first time I've heard of the Synchronized() function crashing. It's been my experience that IBM takes crash issues seriously but YMMV Brian, I have gone back and tried the Synchronized function again. Just as soon as the second process starts, the server crashes. The process is called us...

Agreed. That is why I think we are doing something wrong. I'm going to look at it again and post back if still having issues. Thanks, Brian.

Thanks for the info guys. Every solution here I have toyed with, but stubborn me wanted to see whether I could derive it referencing a cell string value stored in our global cube using .properties method to grab prior month attributes values to derive it. It was more a challenge to see if it could ...

It can actually get worse than this. If you use ExecuteCommand to call TM1RunTI and set the wait parameter to one, you can completely deadlock TM1. The master process can be waiting for the runti command to finish while that process hit contention with the master process. This kind of deadlock requ...

Thank you for confirming something I suspected was the problem. In this case, it looks like just reading the dimension as a datasource is causing the lock contention. I'm going to do some further testing to see if I can get around that issue. I'll post the results. You're right that the master proce...

I have for several years used master processes in conjunction with a control cube to manage the execution of processes. The basic structure of the system would be: * a master process reads the control cube for processes to execute along with parameters * builds a datasource, typically a dimension su...

Very interesting. We are pushing to expand websheet usage and what I have is an active form based on one cube but calculates the variance with another cube... DBRW(cube1, , , ) - DBRW(cube2,,,) This works fine, but takes a little trickery to get the drill to work. This websheet compares the cubes at...

I know this is an old post, but did you ever solve this? I have same need to open two separate cube views through a drill. Two RETURNVIEWHANDLE functions in the epilog did not manage to do it.