TM1 Forum

Thanks for the suggestion. It worked, but unfortunately still does not run in parallel.

Ok. Remove the "START" does work and I'm seeing an error message now. And... You have to use the "%ERRORLEVEL%" environment variable instead of the internal "ERRORLEVEL". HOWEVER... If you remove the "START" I can no longer run processes in parallel! Which the...

I read through the link tried using the variable instead of the internal reference and that still didn't work. For example, I change the error checking I had above to the following: IF %ERRORLEVEL%==0 GOTO ERR00 IF %ERRORLEVEL%==1 GOTO ERR01 IF %ERRORLEVEL%==2 GOTO ERR02 Etc... It still returns my &...

Ah. Ok. Thanks guys

I'm using Version 10.2.2

According to the documentation (link at the end), I should be able to use the "ViewMDXGet" TI function to return the MDX associated with a given View. I've tried to use it as follows, but am getting an error stating the "variable viewmdxget is not recognized": MyViewMDX = ViewMDX...

I finally got around to trying this again and I could not get the ERRORLEVEL method to work. Here's what I have. First, I created a simple TI process to create a dimension with 3 elements in it. In the the script line to add the 3rd element, I added an obvious error by supplying it the wrong element...

Thanks. I did read the users guide, but didn't catch that part. Anyway, I'll try it out and report back.

I'm trying to run some TI processes in parallel by executing TM1RunTI from a batch file. It's successfully executing and running the process in parallel, however, I'm running into issues handling errors that may occur. I'm doing it by running multiple successive "START" commands within the...

Geesh. I figured it out. I was using an unassuming invalid character in my configuration file In my configuration file below, the "-" was technically the wrong ASNI character in my text. I original copied an example from the user guide and edited it in my file. When I did that it must have...

Placing my configuration file in a location where the service has rights to didn't work. At least I don't think it did. I placed the file in two places under the folder where my TM1 server instance resides. That folder looks like this D:\TM1\MyTM1ServerInstance D:\TM1\MyTM1ServerInstance\apps D:\TM1...

The ">" in front of "tm1runti" is part of the command prompt and was not added by me.

I will try placing the file in another location and report back.

Just getting started on trying TM1RunTI. I've read the documentation and reviewed a few forum posts, but cannot get it to work. When I run it from a command prompt, I don't get an error or success message. Instead it just returns what appears to be help information. Here's what I entered at the comm...

Um. So... that was a dumb mistake

I guess I didn't read my edits close enough. I saw "HTTPPortNumber" in the documentation, but used "PortNumber" in my config file.

Thanks! That worked for me.

I have been able to successfully use VBA to automate creation and execution of TI processes as well as other objects using the traditional methods I have experience with to get my head around it. I'm now moving on to the preferred method of REST API, but am having trouble getting REST API going on o...

Ok. Thanks everyone.

Thanks to you both for your responses. [snip]... the API is something to be called only as a last resort. With the overwhelming majority of things you are far better off using macro and worksheet function calls. In addition to which, that API, along with all of the legacy APIs, will be going away. H...

I've begun delving into TM1's API and am using the sample code provided by TM1 to get started. So far so good, but the following code continues to crash Excel and I don't know why. It crashes when trying to use the "TM1ObjectListCountGet" function. Sub ListCubes() Dim hUser As Long, hPool ...

Okay thank you. I appreciate the feedback

Using a simple example to explain my question, assume I've got 2 cubes "Reporting" and "Budgeting". I use my Budgeting cube to derive my budget based on some value using rules. I then want to save the rules-derived value from my Budgeting cube in my Reporting cube as a stored val...