Page 1 of 1
Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 10:17 am
by dan.kelleher
After installing the Xcelerator client on Vista Excel 2007, connecting to the TM1 Server causes Excel to run extremely slowly.
Moving from cell to cell takes 1/2 a second.
The client residing on the server is performing fine, as is TM1 Web accessed from a client machine.
I have installed the latest fixpack 1 for CE and have installed SP2 for Excel.
Any ideas would be greatly appreciated.
Thanks,
Dan
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 10:47 am
by dan.kelleher
Update: Architect is absolutely fine. Server Explorer through Excel is the only issue.
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 11:40 am
by Michel Zijlema
Hi Dan,
There is a problem with the TM1 ribbon in Excel 2007 slowing down Perspectives. If you switch of the ribbon I assume performance will be better.
You can do a search on Ribbon on the forum to find more info on this.
Michel
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 11:57 am
by dan.kelleher
Update: tm1s.cfg below:
Code: Select all
[TM1S]
CAMPortalVariableFile = portal/variables_TM1.xml
ServerCAMURI = http://upf-vm-min04:19300/p2pd/servlet/dispatch
Language = ENG
IntegratedSecurityMode = 1
ClientMessagePortNumber = 19307
#DataBaseDirectory = C:/Program Files (x86)/IBM/Cognos Express/Xcelerator/Custom/TM1Data/CXMD
UseSSL = F
ClientCAMURI = http://upf-vm-min04:19300/p2pd/servlet/dispatch
#PortNumber = 19306
PortNumber = 12345
ClientPingCAMPassport = 900
#LoggingDirectory = C:\Program Files (x86)\IBM\Cognos Express\logs\express
ServerName = MIN_UniquK
DataBaseDirectory="\\upf-vm-Min04\E$\Data_Tm1\Database\MIN_Uniquk"
LoggingDirectory="\\upf-vm-Min04\E$\Data_Tm1\Archive\MIN_Uniquk\Logs"
AdminHost=upf-vm-Min04
#SaveTime=00:22:00
AllowseparateNandCrules = T
#UserDefinedCalculations=T
#ViewConsolidationOptimization=T
#IdleConnectionTimeOutSeconds=3600
DisableWorksheetView = F
ProgressMessage=F
LockPagesInMemory=T
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 12:06 pm
by dan.kelleher
If I disable the ribbon by renaming it, is there an easy way to allow users to connect to the TM1 Server etc without having to create my own add-in?
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 12:54 pm
by Mike Cowie
dan.kelleher wrote:If I disable the ribbon by renaming it, is there an easy way to allow users to connect to the TM1 Server etc without having to create my own add-in?
Dan,
You should not need to create your own add-in. When the TM1 ribbon tab is disabled all of the Excel 2003 TM1 toolbar buttons/menus will appear on the AddIns ribbon tab in Excel 2007. As long as you instruct your users to look there, they'll have all the same buttons/commands that they had on the ribbon. Not ideal, but it works (without the lag you saw with the ribbon loaded).
Regards,
Mike
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 2:20 pm
by dan.kelleher
If I deactivate the TM1 ribbon, the TM1 ribbon disappears but I have no Add-Ins ribbon.
If I then open another add-in (as in the 2nd screenshot), the Add-ins ribbon appears, however there is no TM1 menu in the Add-in.
- Screenshot of Excel Ribbon
- Sceenshot.jpg (47.66 KiB) Viewed 6166 times
Re: Cognos Express Xcelerator Performance Issue
Posted: Thu Dec 09, 2010 2:36 pm
by Mike Cowie
Dan:
I'm confused by your screenshot. You say the ribbon is disabled, but I still see a TM1 tab there. How are you disabling the TM1 ribbon add-in? Typically I just rename the tm1pRibbonX.xlam file so that TM1 won't be able to find it when loading TM1P.XLA in Excel. If the TM1P.XLA add-in can't find the ribbon add-in (tm1pRibbonX.xlam), that is when it populates various items on the Add-Ins tab (assuming macros are enabled and all that).
Regards,
Mike