TM1 Forum

Is there a way of automating the TM1Print function in TM1? I've check the API, there doesn't seem to be anything to do with TM1Print in there.

Thanks!

Thank you both for the insight. I was trying to avoid using SQL statements against the data source because it is already a union query (and already crunching a lot of values). But I think it best to try to rewrite the query in consideration of 'NA' rather than TM1 attempting to handle 'NA' (simply b...

I'm trying to get a null value to go into an element called 'NA', but I need to check for nulls properly. Currently, I am using something like: IF(ELEMENT@=''); ELEMENT='NA'; ENDIF; is using '' the proper way to check for nulls coming from the data source? Even though blank string is not the same as...

Can you post any code snippets? There shouldn't be an issue, but that depends on exactly what you are executing.

I've noticed that on 9.1.4 every time I do a server save (after some recent changes, like adding two elements and some cube rules) that these changes disappear completely if I bring down the server and start it back up. I have to retrace my steps and it is getting annoying. Do you think this may ha...

Hello, Every time someone locks the server, every connected tm1 user 'hangs' in excel until the lock is released. Only us administrators can see what's happening (by using tm1top). Can we notify all connected users how long the lock will take? How can we kill the thread to force the server to relea...

Hello, Every time someone locks the server, every connected tm1 user 'hangs' in excel until the lock is released. Only us administrators can see what's happening (by using tm1top). Can we notify all connected users how long the lock will take? How can we kill the thread to force the server to relea...

If you don't get it right the first time in terms of memory usage, there is always the Reorder Dimensions wizard, which you can use to test different dimension orders in the cube without making any changes. Just right-click on the cube you made and select Re-order dimensions. Play around with the or...

I've noticed that on 9.1.4 every time I do a server save (after some recent changes, like adding two elements and some cube rules) that these changes disappear completely if I bring down the server and start it back up. I have to retrace my steps and it is getting annoying. Do you think this may hav...

If you are referring to the .NET API, most of that is read-only but you can executive a TI process from .NET API.

From Java, C++, VB, pretty much all is possible (read/write/execute).

Which language are you intending to use?

Alan Kirk wrote: I suggest that you use the [Format] button in the Attributes Editor to modify the format.

That did it!!! Thanks a bunch!!! You rock!!

The precision of the calculation has nothing to do with the display, and vice versa. (a) Which dimension are you setting the formatting on relative to the overall cube? (First, last, 5th out of 6, etc?) (b) Do you have formatting set on any other dimensions which may be overriding the formatting th...

I'm getting a really strange number formatting issue in 9.1.4 FP2. I have the calc set to ROUNDP with a precision of 2, I've went and edited the element formatting (right click on dimension, select Edit Element Format) and STILL by default that thing is showing up as a whole number. I even went into...

Thanks for the feedback Guys Mal You might want to be aware that there is a bug that I believe applies to Windows 7 and maybe Vista. Sometimes what happens is when you attempt to launch the Architect client, it won't come up, but will show up in the running processes. This can be fixed by killing t...

I use Windows 7 and 9.4; works just fine.

Apparently there is a way to convert the Java TM1 API into a COM-exposed (and usable by .NET) DLL file. For this, you need to download (or have installed) the latest Sun Java JDK and JRE as well as Visual Studio (any version will do - maybe even express). Next, if it doesn't already exist, create a ...

I believe I know the answer, but I just want to verify: Cube Rules are NOT accessible in the TM1 .NET API? Seems silly that I can get to cube rules through the Java API, the C/C++ API, but not using the C#/VB.NET library. I mean, I guess I could write a wrapper library in C++ using the C libs, but t...

You should be able to, but you might consider making a view and using ODBC to query the view. ODBC is a little bit flaky, so best to uncomplicate the query from TM1 to SQL Server.

You can even query databases from separate servers.

Ah, finally. The problem was that the following must be done before being able to use the TM1API in Java... 1. Open a command line prompt (cmd) 2. Change directory to: "C:\Program Files\java\jdk1.5.0_06\jre\bin" (adjust accordingly) 3. Adjust and run: keytool -import -file "C:\Program...

http://www.paristech.com

and
http://www.olap.com

In fact, this product has a very common origin with TM1 and uses a similar code base (aggregation and calculation engine). Very similar to TM1 but simpler user interface.