TM1 Forum

Good question. When I said I favored using an external scripting language, I should have said, I favored the idea of using an external scripting language. :oops: I have done this with C++ as it was most familiar to me. Easy to hit the ground running. It has it's downside being compiled rather than i...

Sounds right. It's for these complications that I've personally favored using an external scripting language, with built in synchronization primitives, in conjunction with RunTI.

It depends. The version of a cube a chore (or any transaction) will see depends on when that cube is first referenced (and any subsequent changes to it within the transaction.) With Parallel Interaction enabled, Cube Data is separate from the main cube, and the version of that seen will depend on th...

May be worth mentioning that the SaveDataAll/CubeSaveData commands will inject a commit (now two) into the mix.

http://www-01.ibm.com/support/docview.w ... wg27039732

You probably want the 'ServerSandboxesDelete' TI function, which is covered in documentation.

'ServerActiveSandboxSet' sets/clears the sandbox context for the client executing the function.

I'd expect it would not work because text attribute values do not need to be mutually unique among elements of a dimension. If you used a non unique attribute, TM1 wouldn't know which element you were referring to.

I think step 2 is only necessary if you need to use a custom port number for your admin host. In which case, you'd want to set that configuration to the admin host port, not the tm1 server port. In step 4, you have "vi", but should have "v1". Though, I imagine this is just a typo...

DebugUtility is an unsupported TI function that TM1 developers use to add new functionality, usually diagnostic in nature, while keeping intent obfuscated through the use of nondescript command codes/lack of documentation. The only way to get more info would be to ask a developer/support contact. Th...

IBM may not have communicated it as well as it could have, but things are getting better. And, of course, as declanr points out, you often need to be up-to-date with releases to take advantage. Locking during SaveDataAll and CubeSaveData was recently reduced as qml points out. SetCubeDependencies wi...

It sounds like updating the referenced dimension isn't invalidating the cache of the cube. IBM is missing a necessary dependency. Try a less heavy handed (than rule recompilation) invalidation of the cube (edit a cell) to see if that too clears out the old value.

Is multiple commit also like multithread? It respects the sequence that is specified in the Chore or it runs them separated? Multiple commit chores will respect the sequence you have defined. If your chore is composed of processes 1, 2, and 3, then 2 will only run after 1 completes. Likewise 3 will...

I suspect not, since there is a best practice floating around which recommends "priming the cache" by calling ViewConstruct before running the query. However, it would probably be easy to confirm by enabling the stargate debug logger, which will emit a message on stargate creation. One thi...

Search "Windows processor affinity". You can assign specific processors to an instance of TM1 before or after it has been launched.

The documentation looks a bit wonky, but you can access the live transaction log via the C API (TM1ServerLogOpen, TM1ServerLogNext, and TM1ServerLogClose.) Probably what Architect uses for its viewer.

The username/login is another common point of contention. Do your TIs happen to use the same credentials to connect (e.g. "Admin"?) If so, you could try giving each their own username (with admin privileges/group membership.)

Took me a while to find it, but, you can also see this info in Ops Console these days http://www-01.ibm.com/support/docview.w ... wg27035835.

this happens only the first time after restart There was/is a "dirty flag" on the cube that signaled updated cubes that needed to be flushed to disk in SaveDataAll/shutdown. That flag was "metadata" and required an IX lock. It would be set the first time a cube was written to si...

What type of wait is shown in top? IXC? Did you give TM1.Lock.Exception logging a go?

So even though I make changes to feeders, the stats will always remain same, until server is re-started, please confirm. The stats can change when new feeders are populated. In general, statistics are collected every minute, and updated in the appropriate cube. This is true of feeders (population, ...

Feeders are only flushed from a cube when that cube is unloaded (e.g. server is shut down,) so I would not expect the stats cube to show zero after you commented feeder statements.

Did you mean to post in the Enhancements section?