Another TM1 TOP

Ideas and tips for enhancing your TM1 application
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Another TM1 TOP

Post by Ricky Marwan »

Monitor client(s) activities and Message Log at the same time.
TM1 Server Monitor
TM1 Server Monitor
tm1 server monitor.jpg (110.93 KiB) Viewed 26363 times
Compatible TM1 Version(s):
TM1 9.5.2
TM1 10.1

Features:
1. Log activities
2. Open log directly from app
3. Broadcast message
4. Cancel Thread
5. Disconnect Client
6. Send Message
7. Auto connect
8. Monitor Message Log

Requirements:
.Net Framework 4

How to Setup:
TM1 Server Monitor - User Guide.pdf
User Guide
(430.96 KiB) Downloaded 1594 times
TM1 Server Monitor 1.1.rar
TM1 Server Monitor 1.1
(331.47 KiB) Downloaded 1152 times
TM1 Server Monitor 1.1.zip
TM1 Server Monitor 1.1 (ZIP)
(746.05 KiB) Downloaded 1263 times
Last edited by Ricky Marwan on Wed Oct 10, 2012 4:38 am, edited 4 times in total.
Ricky Marwan
JDLove
Posts: 49
Joined: Thu May 21, 2009 1:16 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Another TM1 TOP

Post by JDLove »

Hi Ricky,

Installed ok

W7
TM1 10.1

Thanks for that !
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Another TM1 TOP

Post by Olivier »

Nice and easy to get up and running, tested with 9.4MR1 FP3.
HTH
Olivier
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Another TM1 TOP

Post by Harvey »

Nice work, Ricky! This looks really nice.
Take your TM1 experience to the next level - TM1Innovators.net
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

Updated Version 1.0.1

- View log in Excel for easy analysis, filters etc.
- Allow to refresh connection when unavailable without closing tab
Ricky Marwan
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

Updated Version 1.0.2

- Auto connect to server(s) at startup (app)
- Reconnect button shown if connection unavailable
Ricky Marwan
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

Updated Version 1.1

- Monitor TM1 Server Message Log
Ricky Marwan
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Another TM1 TOP

Post by iansdigby »

Probably the best thing since sliced bread.

Thank you.
"the earth is but one country, and mankind its citizens" - Baha'u'llah
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: Another TM1 TOP

Post by Steve Vincent »

for people who can't expand RAR files i have just updated the original post with a ZIP version too
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
sleepyEDB
Posts: 6
Joined: Mon Jan 31, 2011 4:14 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Another TM1 TOP

Post by sleepyEDB »

A most excellent tool...thank you very much!


sleepy
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: Another TM1 TOP

Post by Steve Vincent »

I'm having an issue where the program crashes on start up. I suspect it's a bug related to the number of services i asked it to load on start up (4, i think) but i don't know where its storing the start up config. Is there any way to edit that manually to get the program working again?
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
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

Steve,

Thanks for the feedback, will fix the bug soon.

the settings file is located in (Win XP):
C:\Documents and Settings\<user>\Application Data\TM1 Server Monitor

you may delete the file.

cheers
Ricky Marwan
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: Another TM1 TOP

Post by Steve Vincent »

Superb, thank you. I can confirm i had 4 services listed, i just altered the flag of one to "<AutoConnect>false</AutoConnect>" and it's loaded just fine. It also autoloaded the service i flagged as false, which may point you to where the bug is :)
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
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Another TM1 TOP

Post by Paul Segal »

I've been meaning to post about this - I've had the same problem, just to confirm what Steve is saying.
Paul
show75
Posts: 7
Joined: Thu Mar 07, 2013 7:23 pm
OLAP Product: oracle and sql server
Version: TM1 9
Excel Version: 2013

Re: Another TM1 TOP

Post by show75 »

Hi
I need your help i use tm 9 and tm1top but i can not do any dthing when this massege come "object duplicate" and i can not kill or stop this thing so i need your help please
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

show75,

are you reporting bug? if so, provide me a screenshot of the error please.

check this out http://www.tm1forum.com/viewtopic.php?p=9378
Ricky Marwan
ppos
Posts: 1
Joined: Fri Mar 15, 2013 3:02 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: Another TM1 TOP

Post by ppos »

Hello Ricky,
Your tool is really great but as I assume there is no way to "verify admin access" if TM1 server uses CAM authentication. Are you planning to add such functionality?

Kindes regards
Pawel
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

Hi Pawel,

I plan to have all security type, but currently i don't have TM1 server configured with CAM security.
I can add function to verify CAM easily, but for sure i need to test it myself before releasing the tool.

If you keen to help, i can give you the tool compiled with CAM for you to test, email me if you interested.
Ricky Marwan
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Another TM1 TOP

Post by Ricky Marwan »

New Version, build using Qt no .Net Framework required

If TM1 installed other than C:\Program Files\Cognos\TM1 add your TM1 bin directory to PATH environment variables or copy executable and related dlls into TM1 bin folder
printscreen.png
printscreen.png (24.11 KiB) Viewed 25560 times
download here:
http://sdrv.ms/16KJzuI

Note:
For those using CAM, the program won't check whether supplied user has ADMIN group assigned.
Last edited by Ricky Marwan on Thu Mar 21, 2013 3:40 am, edited 4 times in total.
Ricky Marwan
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Another TM1 TOP

Post by Paul Segal »

Excellent job Ricky - this looks and feels really good. I'll give it a soak test on four servers for a day or two and let you know how it does.
Paul
Post Reply