Planning Analytics

 View Only
Expand all | Collapse all

Working with Planning Analytics for Excel (PAFE) Reports

  • 1.  Working with Planning Analytics for Excel (PAFE) Reports

    Posted Tue June 09, 2020 07:20 AM

    Planning Analytics for Excel (PAFE) working with PAFE reports

    Improving how PAFE reports refresh/recalculate

    Improving how information is recalculated within Planning Analytics for Excel reports like Dynamic or Custom Reports

    Benefits:

    You can use Constrained Calculations to limit the recalculations strictly to the specified worksheet. Because Planning Analytics for Microsoft Excel is only recalculating the single worksheet, you may notice improved performance when refreshing a single worksheet. Other content in your workbook that is flagged as dirty will not be recalculated if you use Constrained Calculations.

    Links:

    1. https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_pax_constrainedcalculations.html


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

    #PlanningAnalyticswithWatson