Useful IBM Planning Analytics for Excel (PAFE) Batch Scripts

Here are some useful batch scripts for IBM Planning Analytics for Excel (PAFE) Operations. Can use this as baseline to automate install / setup / deployment / configuration of IBM PAFE to end users. If you don’t want to run in Windows Command Prompt or Batch file, you can review the below and navigate directly to the appropriate registry keys or directories and adjust manually.

Seamlessly connect Salesforce with Tableau Cloud

Before you embed a Tableau View (from Tableau Cloud) onto a Salesforce Lightning Page, consider these extra setup steps to ensure a seamless experience, without extra login screens for users.

Customize New Record Page

Salesforce gives you a lot of flexibility. At times you need pointers to customize your App the way you imagined. One such example is customizing the layout of a new record page. I’ll show you exactly how to accomplish that.

TM1 Rule-based Approach for Internal Rate of Return (IRR)

TM1 does not offer a native IRR function. After three years of on-again/off-again thinking through and researching online how to construct a proper TM1 rule-based IRR calculation, I’ve built this methodology which has been used in a production environment for several years.

RunProcess in PAFE

You can use the ExecuteFunction PAX API method to execute a TI process using Excel VBA. There are several limitations. I took the challenge and created my own RunProcess subroutine to solve for these limitations.

Scroll to Top