TM1 Forum

As you know, there is no "out-of-the-box" solution for doing this And further to Mike's reply, TM1RunTI.exe is now included with 9.5.2 HF1. Andy: Looks interesting - spot any documentation for it (or notes on 9.5.2 HF1) yet? Not all the command options are that obvious from the command-li...

I wonder if there are limitations of entry via EV or the API? Hi Jim: I can't speak for EV, but I think it uses the same C/VB API, which I would assume is limited by what length of string TM1 can store in a cube these days. From what I know of the way TM1 stores string values in cube files, it uses...

The explaination I heard from what I would assume is a reliable source is that internally IBM are replacing many legacy Essbase reporting tools with TM1 and Essbase has an in Excel cube browser that looks and feels remarkably similar to the TM1 ISB. Since this was a feature the users were familiar ...

Please note that if you give none rights to a certain element using dimension element security, it is not possible to override this using cell security - the cell security will only be applied to the 'available' elements. Hi Michel: Actually, this is not totally true. The following scenario does wo...

We will be soon reaching the point where we need to start scheduling our loads. The TM1 scheduler, though functional, does not have enough features (and it probably shouldn't -- leave it up to the enterprise schedulers!). I have been doing some research on how to call a TI process from the command ...

Hi: I'm a little confused here. You say: My Aim : Is to compare 'vPlanNameSales' with 'SUniqueVersionName' and if does not matches then Asciioutput should execute else skip: Problem is When am using vPlanNameSales in a while loop its always pulling single record from the SQL Output. Buy your script ...

Olga: If Slicing from the Cube Viewer works properly, but doing something similar from the In-Spreadsheet Browser or Active Forms does not, then that, to me, might indicate a bug that needs to be reported to IBM. That 16-17,000 cut-off range is an interesting one, since much older versions of Excel ...

Any of the following will help me - - The directory where I can find the rule for }ElementAttributes_Time - The syntax error in the rule Thank you in advance for your help! Hi: Saved rules can be found as .RUX files in your TM1 server's data directory. I believe the syntax problem is that you didn'...

Hi All: Quick note on TIExecute and Cognos Express for anyone that is using the two together or plans to do so - these notes will ultimately make it into newer release notes at some stage (hopefully after some IBM feedback on the issues noted below). If you're using TIExecute with Cognos Express, yo...

Hi Richard: So are you just hoping to have an input value repeat across employees? If the value doesn't change for each employee then you could capture it in a cube that doesn't go to the employee level (via a single cell in the workbook) and use it in rules, if needed. If you do want the value to p...

Marcus: Thanks for posting this. There are also some DOS-based ways of doing this, too, if you'd like to use some other non-TI scheduler, or would like to use a single batch file/command from TI (using ExecuteCommand). One of the DOS command methods I've used takes advantage of the Forfiles command ...

Hi: First, I'm curious why you've jumped to building a custom ASP.NET application rather than try to use native Cognos Express components to build web-based reports against TM1 (e.g., use TM1 Web with Active Forms)? I'm not suggesting that TM1 Web and other Cognos Express components will do everythi...

Hi: This is MDX, so I'm sure there are many other ways to do this, some of which are probably simpler, but this was the first idea that popped up for me. These samples first get the leaf elements filtered by attribute, and then use that to generate (via the GENERATE function) a (sub)set via various ...

I'm currently using your old version but fell foul when trying to use it with LDAP authentication, I know you mention the new version supports LDAP but what I'm trying to do is use the TM1 Admin account to the run the processes. The new version can support TM1's Integrated Login method, which isn't...

Also, if you're talking about physical *file* size limitations, I believe any limitations there have to do with your choice of disk/partition format and, possibly, operating system. For example, if your TM1 data directory is on a FAT32 partition (I can't imagine too many are these days) I think you ...

I expect now that IBM has taken over, you are going to see more of this in the future where TM1 is embeded. I'd like to think so, but I haven't gotten the sense it's a high development priority outside of integrating with other components in the Cognos stack, which does seem to be a higher developm...

Hi Mike, thanks for your advice. I am basically investigating what options there are out there to do this. The bottom line is that being able to do this would be an enormous advantage over a competing solution within the same company, and the business needs really require as close to real time upda...

I have been asked by a client whether it is possible to somehow push data in xml format (webservices) into TM-1. (the goal is to get real real-time updates of TM-1 models) I have absolutely no idea whether this can be done. I suppose there may be other products in the cognos stack able to do this o...

Guys, I think I have narroed it down. I think for some reason it is not able retrieve the process (object) name correctly. Have any of you encoutnered this problem before? Jim. Hi Jim, Sorry for the late reply to this thread - have you verified that the server handle is also valid (an object)? If f...

Hi Steve, Using the TM1 API you can get some details about the parameters once you have a valid handle to the TI process. There are a number of not officially documented properties of a process that you can retrieve. Because they're not officially documented they could technically change at any time...