TM1 Forum

Hi: You can not create a reference to TM1 API DLLs from Visual Studio or any other development environment. They aren't that kind of DLL. These API DLLs require you, instead, to declare the functions that you plan to use in TM1API.DLL in your application in order to use them - there are sample C hea...

Dan: I'm confused by your screenshot. You say the ribbon is disabled, but I still see a TM1 tab there. How are you disabling the TM1 ribbon add-in? Typically I just rename the tm1pRibbonX.xlam file so that TM1 won't be able to find it when loading TM1P.XLA in Excel. If the TM1P.XLA add-in can't find...

If I disable the ribbon by renaming it, is there an easy way to allow users to connect to the TM1 Server etc without having to create my own add-in? Dan, You should not need to create your own add-in. When the TM1 ribbon tab is disabled all of the Excel 2003 TM1 toolbar buttons/menus will appear on...

Thanks for the info Mike. It seems like a definate possibilty with development in a VB.Net envronment. What are you own thoughts as to a prefered development tool. We currently have a TM1 Model which utilises Excel based proformas for user inputs and the usual Ti based loads of source files from ex...

Hi: If you're asking whether or not you need the TM1 client installed on a machine in order to use the TM1 C API with some custom application (in VB.NET, C#, etc), the answer is no. You would simply need to copy the relevant TM1 API files from another TM1 client or server installation - usually the ...

As your TM1 is a 32 bit version is will not work/utilise the 64-BIt 4GB of RAM on the operating system. You can absolutely install and run 32-bit TM1 on a 64-bit operating system, provided the 64-bit operating system allows 32-bit applications to run (I don't know if I've ever seen that switched of...

Hi: Had you been using subset element formatting features previously (the functionality provided with dynamic subsets)? This was something OLAPObjects was able to use to drive formatting in its view/subset expansion-based reports when dynamic subsets were a supported feature of TM1. If so, I have se...

Hi, OLAPObjects and TM1 9.5 should work just fine together, and you do not need TM1 Web in order to run OLAPObjects, TM1 Server, or regular (Excel/Architect TM1 client) TM1 client. You only need TM1 Web to run TM1 Web (and, perhaps the new TM1 Contributor). Applix/Cognos/IBM have never provided soft...

Hello Mike, Thank you for sharing. Can you please advice what is the syntax for CAM SSO authentication (C8 BI 8.4.1)? How can I find the CAM passport? Thank you, Gabi Hi Gabi, As I stated in my notes above, I'm not sure yet how one goes about finding the CAM passport. I've only tried and succeeded ...

... TM1 has to be installed because the DLL's have to "registered" and when you install TM1 all that is done for you. You can try manually registering the DLL's (with the REGSVR/REGSVR32 command) . Actually, this hasn't been true, historically, for TM1 API-related DLLs. None of the TM1 AP...

Hi:

Your current code is trying to get the attributes of a dimension, not the attributes of elements of the dimension. Try instead passing in a handle to one element from your dimension and you should get the handle to the attribute you're looking for.

Regards,
Mike

Hi Mike, Thank you for your reply! We got it running, stupidly it was the ODBC driver - sometimes the TIs would run and sometimes they would crash. Testing with non-ODBC TIs was successful, we are puzzled though, as ODBC has been running fine for over a month and suddenly started crashing (and only...

Hi Mike, This is great, however, it keeps crashing our 64bit server 9.5.0 (moving to 9.5.1 soon) and using CAM security Name Space authentication. The first message reads; "Successfully connected to TM1 server" couple of minutes later it comes up with 85: SystemServerConnectionInvalid and...

Ok, I think I've got it. You create the pool which is like a mem alloc, and then place a bunch of values in there, with untyped pointers to them. It probably doesn't help that the sample code I was given was DailyWTF worthy. That a good way to think of value pools and the values within them. And, i...

I believe the intention was for the API to lean toward an object oriented architecture - how well this was achieved is worth questioning but what is available is what is available - we can only guide those who would like to learn it. Are you talking about the Java and .NET APIs? Those I would happi...

Thanks Mike. We have been using the original schedule execute version without a problem fro around 12 months. Hi Jim, Thanks very much for the feedback. You bring up a very good point that I should have highlighted: there is no reason to stop using TM1ProcessExecute or TM1ChoreExecute if they are a...

Hi everyone: I've just posted a totally new version of a command-line TI process/chore execution utility here: http://forums.olapforums.com/viewtopic.php?f=21&t=3486 Sorry for the delay. This replaces the older TM1ChoreExecute and TM1ProcessExecute command-line utilities included in this thread,...

Hi: I've just posted a totally new version of a command-line TI process/chore execution utility in the Useful Code forum: http://forums.olapforums.com/viewtopic.php?f=21&t=3486 Sorry for the delay. This replaces the older TM1ChoreExecute and TM1ProcessExecute command-line utilities and now has s...

UPDATE: Given the unveiling of a more officially supported/documented executable from IBM, TM1RunTI.EXE, I'm putting this utility out to pasture for now. It's still available if you're interested, but overlaps enough with IBM's utility that I'm not planning on developing it further. Some details on...

Hi: First thought: Are there other dimensions in your rpt_Dynamicsubsets cube that you aren't specifying in your cube reference? If there are, could it be that TM1 is just picking an element at random, which may not happen to contain "May-2010"? Second thought: Just to cut this down a bit,...