Page 1 of 1

lagging TM1 Web

Posted: Wed Jun 17, 2009 3:32 pm
by iesak
I built a excel input template which loads some data from 3 different cubes and have some vba codes. it works fine.
however , I can't open the template it the web
I've check that the TM1 excel service is on and the views of the cube is working fine in the web
really have no idea about it ? please help

this is my first time to use TM1 web, can anyone give me some hint to deploy tm1 web?

it seems that the performance of TM1 web is quite poor



my system is windows XP professional
IIS 5.1

Re: lagging TM1 Web

Posted: Wed Jun 17, 2009 5:28 pm
by George Regateiro
TM1Web does not support VBA.

That is why they implemented the action buttons. Not a one to one replacement but works in most cases.

Re: lagging TM1 Web

Posted: Wed Jun 17, 2009 7:32 pm
by Wim Gielis
True, it is not a one-to-one replacement.

The more "sophisticated" your VBA code is, the more you give up on the one-to-one.

E.g. formatting, although conditional formatting could be helpful in some situations.

It all depends on what exactly your Excel VBA code does.

Wim

Re: lagging TM1 Web

Posted: Thu Jun 18, 2009 3:13 am
by iesak
We built a workflow on vba coz the requirement required to handle the read/write security , multi level workflow....etc
and not sure how to call a pre/post process in workflow...