Perspectives Progress Bar

Post Reply
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Perspectives Progress Bar

Post by holger_b »

I found this post where you can find a link to a VBA solution for a progress bar http://www.tm1forum.com/viewtopic.php?f=21&t=601, but I can not yet figure out how one would retrieve the progress information in TM1 while a process runs. Is this possible at all? Did anyone ever manage to create a "real" progress bar?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Perspectives Progress Bar

Post by tomok »

You can't effectively create your own progress bar because you can't programmatically communicate with the server while a TI is being run in order to determine where the process stands. Even though it is quite poor, TI already provides a progress window so I doubt you'll be seeing anything added to the TM1 suite in the near future to address this.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Perspectives Progress Bar

Post by jim wood »

If they did add a progress bar I'm guessing like all other progress bars it would be wrong. As Tomok said they include a box that tells how many lines have been processed. I don't think TI opens the source to find the max number of lines (may be in the case of a DB query) so that might be a change needed to the underlying mechanics. As Tomok also said that won't be happening any time soon.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Re: Perspectives Progress Bar

Post by holger_b »

That is what I thought as well, though I hoped anyone might have found a way...

Thank you, Jim and tomok.

Regards
Holger
Post Reply