I have a client that is struggling with PAFE (Planning Analytics for Excel) performance issues. There are options like fiddler traces / Excel logs but they would have to be capture by each user.

Are there any options that BP and/or consultants have used to help with improving PAFE performance.

------------------------------
paul YOUNG
------------------------------

#PlanningAnalyticswithWatson

Hi Paul,

Not a tool but found that I had some major issues in performance due to volatile functions which were recalculating.
In my case they were on the column headings which the DBRW formulas on the rows referenced.
Basically, every entry into a cell caused the entire sheet to recalculate.

Look out for OFFSET, INDIRECT, SUMIF etc.and get rid of them, especially where TM1 formulas are dependent on these.

Edit: Assumes you are having issues with Dynamic Reports or Custom Reports.
------------------------------
George Tonkin
------------------------------

Hi Paul,
If these performance issues exist across all actions taken by the PAfE Excell Add-in, by multiple users (PAfE installs), and across multiple Excel workbooks, then you likely will want to do some testing on the network(Fidler)      If the performance issues are isolated to specific Excel workbooks, then a deeper analysis into the construction of those workbooks needs to get done to see if any known issue exists, similar to those highlighted by George in this chat thread.  The first step is to identify the performance issue's scope and then take remediation actions from there.    PAfE performance issues are typically tied to one of four items;   Network bandwidth,  physical workstation hardware, Excel software(was it installed configured correctly), or the specific Excel /PAfE workbook and how it was constructed.

------------------------------
JOHN Rittenhouse
------------------------------