VBA in TM1 Web

Post Reply
lewerner
Posts: 3
Joined: Fri Mar 23, 2012 9:46 am
OLAP Product: Cognos TM1
Version: 9.5.2
Excel Version: 2003

VBA in TM1 Web

Post by lewerner »

Hello All,

Unfortunately I have to use TM1 Web to set up an application and it would be quite helpful to use some VBA functionality.
I know this topic has been discussed before (http://www.tm1forum.com/viewtopic.php?f=3&t=431) but the latest topic, I could find, is 4 years old now and so I hope (a little), that IBM had time to improve TM1 Web in this area.

Is there at least a possibility now to hide rows dynamically (depending on user input) or to implement some other VBA functionality?

Thanks for your responds.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: VBA in TM1 Web

Post by David Usherwood »

No change.
There's no VBA engine in TM1 Web.
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: VBA in TM1 Web

Post by tomok »

There is no VBA in TM1Web but have you spent any time with Active Forms? You can dynamically filter rows based on user selections and apply all sorts of formatting based on selections. It's not VBA but it is pretty powerful.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
lewerner
Posts: 3
Joined: Fri Mar 23, 2012 9:46 am
OLAP Product: Cognos TM1
Version: 9.5.2
Excel Version: 2003

Re: VBA in TM1 Web

Post by lewerner »

Thanks for your responds.

I suspected that IBM didn't change anything on this subject, but after 4 years its worth to aks. ;-) I'm going to try my best with active forms then, thanks for that suggestion tomok.
Post Reply