Search found 231 matches

by Mike Cowie
Mon Aug 06, 2018 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 32
Views: 2520

Re: Planning Analytics using twice the memory of 10.1

Big thanks to Lotsa, Paul and others for this-- has been a really interesting thread. If anyone needs a pre-REST API method of counting MUNs, just create an MDX subset like this and count/SUBSIZ the elements in that dynamic subset: GENERATE( TM1SUBSETALL( [Your Dimension Name] ), DESCENDANTS( [Your ...
by Mike Cowie
Tue Nov 01, 2016 5:31 pm
Forum: General
Topic: World of Watson 2016
Replies: 4
Views: 3404

Re: World of Watson 2016

Jim:

Sorry I missed you among the 20K or so people! I saw Mr. Waters a few times, but that was about the only familiar non-IBM'er face I saw.

-Mike
by Mike Cowie
Tue Oct 20, 2015 12:09 pm
Forum: General
Topic: Insight 2015
Replies: 2
Views: 2065

Re: Insight 2015

Hi Jim:

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.

Regards,
Mike
by Mike Cowie
Fri Aug 29, 2014 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SDK JavaExtensions ( Any early adopters )
Replies: 9
Views: 4143

Re: TM1 SDK JavaExtensions ( Any early adopters )

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...
by Mike Cowie
Fri Aug 29, 2014 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SDK JavaExtensions ( Any early adopters )
Replies: 9
Views: 4143

Re: TM1 SDK JavaExtensions ( Any early adopters )

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...
by Mike Cowie
Fri Aug 29, 2014 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automation of Currency data from the open source into TM1
Replies: 5
Views: 2230

Re: Automation of Currency data from the open source into TM

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...
by Mike Cowie
Thu May 22, 2014 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE and Cognos Express
Replies: 6
Views: 1940

Re: CAFE and Cognos Express

Hi All:

I've asked this a few times at the Vision conference and the consistent answer is that CAFE is currently not included with Cognos Express.

Regards,
Mike
by Mike Cowie
Tue Mar 11, 2014 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: C/C++ API Function Question
Replies: 4
Views: 1553

Re: C/C++ API Function Question

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...
by Mike Cowie
Thu Dec 05, 2013 7:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx expression with comment (really ?)
Replies: 4
Views: 1371

Re: Mdx expression with comment (really ?)

Wim:

That's a little scary/strange, but interesting... hadn't tried that before.

Regards,
Mike
by Mike Cowie
Thu Dec 05, 2013 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx expression with comment (really ?)
Replies: 4
Views: 1371

Re: Mdx expression with comment (really ?)

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...
by Mike Cowie
Sat Nov 02, 2013 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IOD conference 2013
Replies: 3
Views: 1445

Re: IOD conference 2013

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 ...
by Mike Cowie
Thu Oct 17, 2013 2:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express 10.2.1 coming out today
Replies: 13
Views: 11960

Re: Cognos Express 10.2.1 coming out today

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...
by Mike Cowie
Wed Jun 26, 2013 12:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidated Financial Statements in TM1 ?
Replies: 13
Views: 6040

Re: Consolidated Financial Statements in 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...
by Mike Cowie
Wed Jun 26, 2013 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Automated Report Generation Tools/Processes
Replies: 8
Views: 3344

Re: TM1 Automated Report Generation Tools/Processes

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...
by Mike Cowie
Tue Jun 25, 2013 11:48 pm
Forum: Commercial and Events
Topic: Make TM1 Even Better with the QueBIT FrameWORQ
Replies: 0
Views: 2799

Make TM1 Even Better with the QueBIT FrameWORQ

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...
by Mike Cowie
Tue Jun 18, 2013 6:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OLAPOBJECTS 5.0 and TM1API.DLL
Replies: 10
Views: 2362

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Hi Ben:

We'll contact you offline to assist further - it could be things like licensing, TM1 SSL settings or something similar preventing TM1 Servers from being seen via OLAPObjects and the TM1 API.

Regards,
Mike
by Mike Cowie
Thu Apr 18, 2013 3:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with running local server (models)
Replies: 10
Views: 3539

Re: Problem with running local server (models)

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...
by Mike Cowie
Wed Mar 20, 2013 5:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: C/C++ API Function Question
Replies: 4
Views: 1553

Re: C/C++ API Function Question

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...
by Mike Cowie
Thu Feb 14, 2013 6:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help for API fuction TM1CubeCellValueGet
Replies: 11
Views: 3012

Re: Help for API fuction TM1CubeCellValueGet

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...
by Mike Cowie
Wed Jan 23, 2013 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 TOP API results in excel
Replies: 1
Views: 781

Re: TM1 TOP API results in excel

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...