Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Monitoring Planning Analytics for Excel (PAFE) Performance

    Posted Wed February 24, 2021 04:04 PM
    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


  • 2.  RE: Monitoring Planning Analytics for Excel (PAFE) Performance

    Posted Wed February 24, 2021 11:58 PM
    Edited by System Admin Fri January 20, 2023 04:34 PM
    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
    ------------------------------

    Original Message


  • 3.  RE: Monitoring Planning Analytics for Excel (PAFE) Performance

    Posted Thu February 25, 2021 12:39 PM
    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
    ------------------------------

    Original Message