Another TM1 TOP

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

Another TM1 TOP

Post by Ricky Marwan » Thu Sep 27, 2012 11:08 am

Monitor client(s) activities and Message Log at the same time.
tm1 server monitor.jpg
TM1 Server Monitor
tm1 server monitor.jpg (110.93 KiB) Viewed 11677 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 1035 times
TM1 Server Monitor 1.1.rar
TM1 Server Monitor 1.1
(331.47 KiB) Downloaded 625 times
TM1 Server Monitor 1.1.zip
TM1 Server Monitor 1.1 (ZIP)
(746.05 KiB) Downloaded 790 times
Last edited by Ricky Marwan on Wed Oct 10, 2012 4:38 am, edited 4 times in total.
Ricky Marwan

JDLove
Posts: 41
Joined: Thu May 21, 2009 1:16 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Another TM1 TOP

Post by JDLove » Thu Sep 27, 2012 2:26 pm

Hi Ricky,

Installed ok

W7
TM1 10.1

Thanks for that !

User avatar
Olivier
Community Contributor
Posts: 156
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 9.4MR1 FP3 HF12
Excel Version: Excel 2003
Location: Sydney

Re: Another TM1 TOP

Post by Olivier » Fri Sep 28, 2012 5:25 am

Nice and easy to get up and running, tested with 9.4MR1 FP3.
HTH
Olivier

User avatar
Harvey
Community Contributor
Posts: 210
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: TM1, CX, Palo
Version: 9.4+
Excel Version: 2003+
Contact:

Re: Another TM1 TOP

Post by Harvey » Mon Oct 01, 2012 12:17 am

Nice work, Ricky! This looks really nice.
Flow OLAP - adding value to Cognos Partners worldwide.

Ricky Marwan
Posts: 31
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 » Mon Oct 01, 2012 11:16 am

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: 31
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 » Fri Oct 05, 2012 10:57 am

Updated Version 1.0.2

- Auto connect to server(s) at startup (app)
- Reconnect button shown if connection unavailable
Ricky Marwan

Ricky Marwan
Posts: 31
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 » Wed Oct 10, 2012 4:39 am

Updated Version 1.1

- Monitor TM1 Server Message Log
Ricky Marwan

iansdigby
Community Contributor
Posts: 104
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10
Excel Version: 2007 Professional
Location: Isle of Wight, UK

Re: Another TM1 TOP

Post by iansdigby » Wed Nov 07, 2012 4:11 pm

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: 1048
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 » Tue Jan 29, 2013 1:41 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, 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 » Fri Feb 15, 2013 3:35 pm

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


sleepy

User avatar
Steve Vincent
Site Admin
Posts: 1048
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 » Wed Mar 06, 2013 8:54 am

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Ricky Marwan
Posts: 31
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 » Thu Mar 07, 2013 2:58 am

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: 1048
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 » Thu Mar 07, 2013 1:07 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Paul Segal
Community Contributor
Posts: 228
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Another TM1 TOP

Post by Paul Segal » Thu Mar 07, 2013 2:00 pm

I've been meaning to post about this - I've had the same problem, just to confirm what Steve is saying.
Paul

show75
Posts: 5
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 » Wed Mar 13, 2013 9:23 pm

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: 31
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 » Thu Mar 14, 2013 2:28 am

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 » Fri Mar 15, 2013 3:38 pm

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: 31
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 » Sat Mar 16, 2013 11:28 am

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: 31
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 » Wed Mar 20, 2013 8:21 am

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 10874 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: 228
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Another TM1 TOP

Post by Paul Segal » Wed Mar 20, 2013 8:49 am

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