Planning Analytics

PAFE (Planning Analytics for Excel)

Most of the recommendations related to PAFE performance with local computers relate to software requirements and the recommendation of using 64-Bit.

PAFE is designed to work with any computer if the pre-requisites are met. PAFE introduce hub less as way to removed to PMHub dependency - https://www.ibm.com/support/pages/using-planning-analytics-microsoft-excel-without-performance-manager-hub

It is also recommended that you PC have decent CPU, RAM and disk memory as part working with Planning Analytics for Excel

1. Prerequisites - https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_inst_pax_prereq.html
2. Conformance - https://www.ibm.com/support/pages/ibm-planning-analytics-microsoft-excel-conformance-requirements (It is always recommended to stay no more than two releases of PAFE behind PAW and your TM1 server. If you are upgrading your TM1 server, then it is recommended that you also upgrade PAFE -
3. Trouble Shooting / PAFE issues - https://revelwood.com/ibm-planning-analytics-tips-tricks-troubleshooting-planning-analytics-for-excel/
4. Microsoft Excel Optimization issues (older versions of Microsoft Excel - https://www.ibm.com/support/pages/office-365-supported-ibm-planning-analytics-microsoft-excel-or-tm1-perspectives
5. PAFE works as an add-in as such it is important to understand differences between 32-Bit and 64Bit Machine - https://support.microsoft.com/en-ie/office/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261 or https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_ig_cor_installcognos8analysisforexcel.html
6. Exploration settings / PAFE - https://quebit.com/askquebit/IBM/pax-application-and-exploration-settings/
7. Management of refreshing / PAFE - 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