lagging TM1 Web

[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

[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.

[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

[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...