TM1 Forum

I inherited a model with a number of terrific rules which I dare not touch if I can avoid it. These days, the client moved the application to a new server and we took the opportunity to upgrade to 10.1.1. Unfortunately we see now that some Excel and TM1Web reports which used to be slow but more or less tolerable, take twice the time compared to 9.5.2.

Anything else is neat and quick as it should, just this one cube is a problem. Any ideas?

Regards
Holger

Have you your setting in the CFG file? I would do this and look at some options for the CFG file in 10.1.1. This way hopefully you'll be able to see a difference without touching the rules,

Jim.

Thank you Jim, but the tm1s.cfg is identical... Here is the contents - nothing special in it in other words...

ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
ServerName=Contdata
DataBaseDirectory=d:\TM1Data\dbname
LoggingDirectory=d:\TM1Data\Logging
AdminHost=DEMUAPP40000
PortNumber=12346
Language=DEU
SaveTime=
DownTime=
GroupsCreationLimit=20
excelwebpublishenabled=false
IdleConnectionTimeOutSeconds=14400

holger_b wrote:Thank you Jim, but the tm1s.cfg is identical... Here is the contents - nothing special in it in other words...

Although the contents that you can see may be identical, there will be different results. Such as Parallel Interaction for version 10 defaults to True if it isn't specified int he CFG file, this wasn't the case in version 9.5.2.

Ah! Good to know. Are there more hidden secrets like this? Or how could I have known?

This type of stuff is generally put out in the new features guide with every release. The specific one about parallel interaction is mentioned in the third link down in the doc.

http://pic.dhe.ibm.com/infocenter/ctm1/ ... ainer.html

If it makes you feel any better we actually have seen performance improvements in the web between 9.5.2 and 10.1.1 FP1

So did I up to now, this is the first time I saw the reverse effect. I will send the model to the IBM support and let you know what they think.