TM1 Forum

Hello again,

how about calling a TI which calls the TI function GetProcessErrorFileDirectory() and prints the return value out to a flat file, then pick up that flat file and tada....there is your path.

Ah ok, Looking for a way to determine the URL path to the log or data files folder for a specified server. A VBA equivalent of the TI function GetProcessErrorFileDirectory() You could still pass the server name as an argument and presuppose the rest of the path string? You could also open up the .cf...

Hello, I am looking for a way to get the data or log files directory for a specified server in VBA code. Does anyone know if the above APi functionis the right thing to use and if so have any pointers on how to call it. What exactly do you mean by "to get the data or log files directory for a s...

No, it's not the API. It's on the server side. The APIs are on the client side. It's been discussed here before but you may be unaware of it because the process for implementing them has been so extensively "documented" in the way that IBM "documents" so many things. But start h...

which makes complete sense but in reality every restart it only takes up MORE RAM. I'm at 200GB now, I bet restarting now would surely bring it up to 210GB. How are you restarting the TM1 services? What about the Server? Have you tried restarting that? I agree with lotsaram, I do not think this is ...

or use TI to run Java via TI Java extension TI Java extension? I am yet to hear of this? Can you provide more information on this please? such as links? Or again, is this just the API? lol To run a TI outside of TM1 I just use the TM1RunTI.exe tool, but yes you can also use the APIs. Hi, I am worki...

Hello again, have you tried restarting the Server that contains all the TM1 windows services? This restart will cause all RAM to be released. How do I tell TM1 to give some of the 120GB garbage memory back? You can go to the }CubeProperties cube and set the VMM and VMT cells to the amount of memory ...

Another way is to use Java to kick off TI process if you use latest TM1.

How exactly would you use Java to kick off a TI Process? By latest TM1 do you mean 10.2 fix pack 3?

Thanks.

Trevor.

You also need to be aware of the logs when you run chores that frequently. We use to have two chores running every minute, with each chore running a TI Process. This meant that every time we looked in the transaction log all we saw a lot of the time was the repeating logs of the minute chores. This ...

There are a couple counter-intuitive quirks of the API that are documented. http://www-01.ibm.com/support/knowledgecenter/SS9RXT_10.2.0/com.ibm.swg.ba.cognos.tm1_api.10.2.0.doc/c_threadsafety_n704c3.html%23ThreadSafety_N704C3 This one is basically saying if you share user handles (gotten from Syste...

I have got it working with CAM now thanks. (Note: you can find the function declaration in TM1API.H. This can be a good source of undocumented function names for the C API. The declaration doesn't explain what all the params are, but sometimes a little trial and error can go a long way.) Good idea, ...

Hello again, One way to avoid data is to use th ItemSkip function. Like this: If (ValueThatIsEmpty @=''); ItemSkip; EndIf; Replace "ValueThatIsEmpty" with the Variable that may give you an empty value, that way your TI will skip all the empty arguments in the source, without crashing.

Success! I created code that gets the handle of the user and the server and then I test its connection: voDbHandle = TM1SystemServerHandle( hUser, sServerName ); if ( voDbHandle ){ std::cout << "Connected: " << sServerName << std::endl; }else{ std::cout << "Not Connected: " << sS...

Hello Tom, thanks for the response. I have copied the code from that link in a new function and it returns no errors, but I am not sure if it was successful, my code: char * sAdminHost = "ABCDE12345"; TM1SystemAdminHostSet (hUser,(CHAR *) sAdminHost); // // Create Value Pools from strings ...

Hello again Amit,

I am glad I have helped but are you sure just ignoring the blanks in the TI code is the best approach? That dimension will still need an argument as part of the CellGetS call.

Hello, you have not included any files so it is difficult to understand the actual error. Have you made sure that the Area Definition is not over ruled by a rule above? Your statement: The problem is that the normal hierarchy for level year is overruled by the previous code. Makes me think that a ru...

Hello, Normally an invalid key means that the attempt to pass an argument into a selected dimension, is an attempt to pass an element that does not exist in that dimension. Your error is telling you that a blank element does not exist in the dimension, I would check your data at the source, make sur...

Hello again Brian, thanks for the reply. Unless I'm missing some code, you haven't actually attempted to connect (log in) to the server. You'll only get a handle back from TM1SystemServerHandle if you've already logged in. I would think this code: for( iServer = 1; iServer <= iServerCount; iServer++...

Just when I start to get it working, I hear rumors that it will no longer be supported lol. Alan has made me feel better about it though, Please choose to develop software with the TM1 API in C++ and Java only. It would be hard to turn around now and say "yeah, we didn't mean it, the Java API's...

This can often be caused by an SSL error. If you haven't yet, try copying the entire "ssl" folder from the TM1 bin directory into the same place as the dlls That worked, excellent thanks. Have you ever connected to a TM1 server with this API? My code: TM1SystemAdminHostSet(hUser,"ABC...