Extended TM1top

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Steve Vincent
Site Admin
Posts: 1054
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 »

Here is Ben Hills extended version of TM1top;
TM1top.zip
(2.4 MiB) Downloaded 1455 times
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Extended TM1top

Post by Steve Rowe »

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,
Technical Director
www.infocat.co.uk
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro »

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: 1054
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 »

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: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro »

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 »

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: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce »

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: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce »

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: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Alan Kirk »

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: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce »

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 25064 times
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce »

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: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Extended TM1top

Post by mce »

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 »

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: 3651
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 »

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: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro »

I have a version in progress currently. Will send an update shortly.
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Re: Extended TM1top

Post by harrytm1 »

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.
Planning Analytics latest version, including Cloud
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 »

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: 7
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 »

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: 351
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Extended TM1top

Post by Andy Key »

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: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: Extended TM1top

Post by Kyro »

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