Server & Client

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Server & Client

Post by appleglaze28 »

How do you scale the hardware needed by both client (TM1 Perspective) and TM1 Server for like 99 Users.

I also heard that Excel 2007 takes up alot of memory but I'm not sure how much? How can I incoorporate to the client unit for bettr performance.

I know all of these are dependent on the models but a rough basic scaling tip would be nice.
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Server & Client

Post by Steve Vincent »

so many things influence performance that its near impossible to say. certain areas are critical (RAM on server etc) but performance for x number of users will be difficult to guess without actually building some models and getting users to test it in your environment.

for instance, are all the users connecting via the LAN or are some WAN based?
do all of them connect at once, or is it spread out over the month?
is it all via server explorer or do they use web / excel?
are they grabbing data or changing it too?
are the models heavy or light on rules?

+ million other things ;)
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply