I didn't realize you had to be at the booth both days - that's rough! If you need rescuing or especially refreshments (we'll have cotton candy at the QueBIT booth) let me know. I'll be happy to "buy" you a beer during one of the expo receptions.

In general, because you have access to nearly all TI functions in Java Extensions you should not need to access other TM1 APIs, whether it be the TM1 Java API or new REST API, from Java Extensions. Java Extensions are still quite powerful, but I don't think are meant to replace TI process writing a...

Hi Uchow10: First, I don't think the description of Java Extensions on the IBM DeveloperWorks site is accurate: "Most TurboIntegrator functions are supported in Java and can be used like any other Java method. You can create TurboIntegrator processes with Java and use Java’s libraries to further exp...

As Macsir says there is likely some programming involved here - the data you're looking for can likely be extracted from the web pages you're currently using or through other web services that provide this data. Some examples here: http://stackoverflow.com/questions/4873873/realtime-currency-webserv...

Hi Firefly007: No, I don't know of an alternative. As I said below, this function has been around since 2000, but has never been officially documented by Applix, Cognos and now IBM. Why they haven't documented it is beyond me, but you should be able to use it to disconnect all clients (one at a time...

Hi Laurent: I don't think IBM officially says anywhere in their MDX support documentation that they officially support the available commenting options in the MDX language , but based on what you've found it looks like they might support at least the "--" style commenting (at least in 10.2). You can...

Hi Rduggs: I'll be at the conference (arriving very late Sunday), likely spending most of my time at the QueBIT booth. It would be great to meet any other forumers (consultants, users, or IBM'ers) that are at the conference, so please feel free to stop by and say hello. Don't be offended if I don't ...

Hi James: But some deprecated features that maybe an issue for you: • No Advisor and Data Advisor One point of clarification - Advisor and Data Advisor is not gone (yet) - CX 10.2.1 is, however, the last release where it will be available . Only the following items are totally gone in CX 10.2.1: TM1...

Hi JDLove: Sorry to come to this topic a bit late. On the topic of journal entries with TM1, I did want to take a minute to direct you to our FrameWORQ products page on the Commercial forum , specifically ControlWORQ which was sold by Applix as TM1 Consolidations many versions/moons ago and provides...

Hi Damien: Since it seems very relevant to the topic at hand, I did want to take a minute to direct you to our FrameWORQ products page on the Commercial forum , specifically ReportWORQ which is designed to help simplify the job of TM1 Excel report automation and distribution, including support for m...

QueBIT Consulting, LLC recently launched its QueBIT FrameWORQ line of software products at the IBM VISION Conference at the JW Marriott in Orlando Florida. QueBIT FrameWORQ is a comprehensive line of software products designed to improve and enhance IBM's industry leading Financial Performance Manag...

Hi All: Sorry to jump in a little late to the party, but I thought I'd share some of what we'd found out about the local server option (Start Local Server from Perspectives/Architect Server Explorer) in 10.1.x. IBM's suggestion that you just run the 32-bit client install doesn't actually work, by it...

Hi George: I had to ask for this originally - not sure why it's not been documented since I asked back in 2000. This is an old VBA/VB6 declaration, which shouldn't be too hard to rework for C/C++: Declare Function TM1ClientDisconnect Lib "tm1api.dll" (ByVal hPool As Long, ByVal hServer As Long, ByVa...

Hi: First, if you're doing this from VBA then why go to the trouble of using TM1CubeCellValueGet? Just call TM1's DBR function as noted below as it is much safer and easier in VBA - you're reinventing the wheel if you use TM1CubeCellValueGet from VBA. If this is not in VBA where you must use TM1Cube...

Hi TM1Bug: First, I'm going to warn you that retrieving TM1TOP statistics repeatedly in a loop without pause is probably not a good idea, especially using Excel and Excel VBA to do so. TM1TOP information isn't ever really "real-time", as was discussed in this thread ; at best you'd just be getting v...

Hi All: Agreed with other commenters on the only possibility of running Perspectives 2.5 with Windows 7 being through VMs, and even that's not ideal given the age of that release. Perspectives 2.5 and Server 6.0 were the first releases I started using back in 1997 (both Rev D, I think). What a blast...