CAFE 10.2.2: Experiencing slow performance in some Excel versions

Post Reply
arthur_r
Posts: 2
Joined: Tue Nov 01, 2016 12:08 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.20700.43
Excel Version: 2010-2016

CAFE 10.2.2: Experiencing slow performance in some Excel versions

Post by arthur_r » Thu Jan 31, 2019 11:47 am

One day our Cognos users began experiencing slow performance of Cognos Analysis for Excel (Cognos CAFE).
We use
TM1 10.2.2 FP7 (TM1 Build Number: 10.2.20700.43)
CAFE 10.2.2 FP7
MS Office 2013

I tried different ways to increase performance due to IBM recommendations but there was no effect. https://www.ibm.com/support/knowledgece ... s_cor.html
Files in Office Connection directory (C:\Users\Username\AppData\Local\Cognos\Office Connection) are the same for both versions of Excel.

I have no idea why this is happening except the theory that users became facing slow CAFE performance after Excel updates.
For example in Excel version 2013 (15.0.4569.1504) MSO (15.0.4569.1506) CAFE works well & quickly
In Excel Version 2013 (15.0.5093.1000) MSO (15.0.5101.1000) it works very very slowly.

We cannot rollback excel updates because all microsoft products must be up-to-date in our company.

If anyone has any ideas how to fix slow performance I will appreciate it very much

Post Reply