Extended TM1top

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Steve Vincent
Site Admin
Posts: 1049
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Extended TM1top

Post by Steve Vincent » Thu Nov 20, 2008 11:30 am

Here is Ben Hills extended version of TM1top;
TM1top.zip
(2.4 MiB) Downloaded 867 times
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

User avatar
Steve Rowe
Site Admin
Posts: 1802
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Extended TM1top

Post by Steve Rowe » Tue Feb 17, 2009 4:00 pm

Note I could not get this to work on version 845 of TM1, not sure if it doesn't support the first release of TM1Top or if I am doing something wrong.

Cheers,

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro » Wed Nov 04, 2009 2:39 am

I'm unsure but I think that the attached is the version adapted for TM1 9.X's new locking status top fields. I'll take a look and see if I have older versions. I might as well support it.
Ben

*Edit: Here is a newer 9.1X version - Tested with 9.1 SP4
http://www.tm1tutorials.com/downloads/TM1top%209.1X.zip

I'll create other versions when I next upgrade to 9.4 and next downgrade to 9.0

User avatar
Steve Vincent
Site Admin
Posts: 1049
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Extended TM1top

Post by Steve Vincent » Tue Jun 08, 2010 1:56 pm

the 9.0 version kind of works on 9.5 but various bits don't (like status colour changes when server is busy). Are there any plans to release a 9.5 compatible version because this is streets ahead of what IBM offer...
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro » Wed Jun 09, 2010 11:23 am

Sure, I'll take a look when I next get some time off Keystone.

anoops81
Posts: 101
Joined: Tue May 12, 2009 8:20 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Office 2010

Re: Extended TM1top

Post by anoops81 » Fri Jun 11, 2010 1:11 pm

Hi Steve/Kyro ,

I have configured the Extended TM1top in our server . I am able to monitor the clients also. Could you please tell me where i can find the explanation on the colors which is coming live in the Extended tm1top application ? Please provide me the link , so that I can go through.

Regards
Anoop

User avatar
mce
Community Contributor
Posts: 275
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.3
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce » Fri Aug 20, 2010 10:53 am

Steve Vincent wrote:Here is Ben Hills extended version of TM1top;
TM1top.zip
Hi,

I downloaded this into my client machine and configured for the TM1 server. It opens fine. But it does fail when I verify access even when entering correct credentials. It gives "Couldnot Verify:Authentication Failed" error message.
- Do I have to copy any of these files into server's Applix\bin directory?
- Does version 1.0 of TM1Top works well in 9.0 SP1?

Thanks in advance.
Regards,

User avatar
mce
Community Contributor
Posts: 275
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.3
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce » Fri Aug 20, 2010 11:51 am

TM1 Top Custom Client.pdf wrote: Copy the files listed below from your old TM1 top Directory into the new TM1
Top Directory Replacing the Existing Files:
a. Tm1api.dll
b. Tm1lib.dll
c. Tm1sip.dll
In version 9.0, there is no TM1Top, so there is no TM1Top directory. Should I replace these files in Applix\bin folder with the ones coming in TM1top.zip ?

User avatar
Alan Kirk
Site Admin
Posts: 5830
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Alan Kirk » Mon Aug 23, 2010 6:15 am

mce wrote:
TM1 Top Custom Client.pdf wrote: Copy the files listed below from your old TM1 top Directory into the new TM1
Top Directory Replacing the Existing Files:
a. Tm1api.dll
b. Tm1lib.dll
c. Tm1sip.dll
In version 9.0, there is no TM1Top, so there is no TM1Top directory. Should I replace these files in Applix\bin folder with the ones coming in TM1top.zip ?
Other way around. Copy those files out of your Applix\bin directory and put them into your TM1Top one to make sure that they're the current ones for your version. You don't need a system-created TM1Top directory; you can extract the files into any folder that you create. In my case I just created a folder that sits alongside the data directories, unpacked the files into there and copied the three files in from Applix/bin.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
mce
Community Contributor
Posts: 275
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.3
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce » Mon Aug 23, 2010 8:16 am

When I copy these 3 files from applix\bin to the tm1top folder, tm1top works but veryfiy still does not work and I receive the error message below.
tm1toperror.JPG
tm1toperror.JPG (8.77 KiB) Viewed 10047 times

User avatar
mce
Community Contributor
Posts: 275
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.3
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce » Tue Aug 24, 2010 9:23 am

I am still having problems with TM1Top in version 9.0. I am able to monitor and but not able to verify and kill procceses or disconnect users.
Is there any other way in TM1 to kill hanging user requests or to disconnect hanging users?

Any help will be highly appreciated.

User avatar
mce
Community Contributor
Posts: 275
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.3
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce » Tue Aug 24, 2010 3:43 pm

Here is the response frm IBoglix;
Unfortunately, TM1TOP is not compatible with 9.0.1. The first fully compatible release is 9.0.2.

applix_mc
Posts: 16
Joined: Mon Jun 02, 2008 3:11 pm

Re: Extended TM1top

Post by applix_mc » Mon Aug 30, 2010 7:49 pm

Just an observation but if anyone is trying to use this Tm1Top version beyond 9.1.x you will run into problems because there is no tm1sip.dll created for Tm1 versions 9.4 >.

lotsaram
MVP
Posts: 3126
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Extended TM1top

Post by lotsaram » Mon Apr 11, 2011 7:04 am

applix_mc wrote:Just an observation but if anyone is trying to use this Tm1Top version beyond 9.1.x you will run into problems because there is no tm1sip.dll created for Tm1 versions 9.4 >.
It works well enough with 9.5.1 with v 8.0000 of tm1api, tm1lib and tm1sip for display only purposes but some of the fields are a little screwed up (eg lock is duplicated, wait time does not display) and although you can verrify it isn't possible to kill a thread.

If @kaikyro is listening, Ben I'd be interested if you might considder supporting 9.4 and 9.5 ...

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro » Mon Jul 18, 2011 6:47 am

I have a version in progress currently. Will send an update shortly.

harrytm1
Regular Participant
Posts: 225
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: TM1, PA, CX, Controller
Version: Latest version
Excel Version: 2003 to 2016

Re: Extended TM1top

Post by harrytm1 » Fri Oct 28, 2011 6:06 am

Using it with version 9.5.2. Seems ok but the wait time is not showing. I managed to kill a hung TI using it. Unless it is really coincidental that the TI ended by itself right after I killed it through Extended TM1Top, it is working.
TM1 Version 9.4.1 to latest version

winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: Extended TM1top

Post by winsonlee » Thu Nov 03, 2011 11:32 pm

hi kyro.

i tried downloading TM1top%209.1X.zip but the link is broken.
Does the TM1top%209.1X.zip work on Cognos Express 9.5 ?

show75
Posts: 5
Joined: Thu Mar 07, 2013 7:23 pm
OLAP Product: oracle and sql server
Version: TM1 9
Excel Version: 2013

Re: Extended TM1top

Post by show75 » Sat Mar 23, 2013 8:23 pm

I can not end any process execute or object duplicate .
there is one way... restart service.
is there any solution to this issue?
I have TM1 9.0 SP2
Last edited by show75 on Wed Dec 24, 2014 11:31 am, edited 1 time in total.

Andy Key
MVP
Posts: 337
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1 CX
Version: 2-5 to 10-2-x
Excel Version: 2003 2007 2010 2013
Location: Sydney
Contact:

Re: Extended TM1top

Post by Andy Key » Mon Mar 25, 2013 7:40 am

show75 wrote:I can not end any process execute or object duplicate .
There were issues with some of the early releases of 9 whereby threads showing ObjectDuplicate could hang the server.

I don't have a copy of the 9.0 manuals, so check your documentation to see if ReceiveProgressResponseTimeoutSecs is available as a tm1s.cfg parameter and if so, set it to a reasonable value, say 20 or 30 seconds.

Once your server gets into the situation where one of these threads occurs, after the 20 or 30 seconds the thread will get disconnected and all other waiting threads will resume.

The client who created the sticking thread will have to crash their session, as the client end of the thread doesn't realise that it has been disconnected and will continue to wait.
Andy Key

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro » Tue Jul 02, 2013 2:46 am

Hey,

Just an FYI on this one, The TM1 Top Windows Desktop application has been replace by:
  • Windows Desktop Application - by Ricky Marwan. See Here
  • TM1 Monitor in the Cloud - See Here
Kind Regards,
Ben

Post Reply