Category Archives: Planning Analytics Excel

Logging in Planning Analytics for Excel

Here is a simple step by step guide to enabling logging in Planning Analytics for Excel. PAX logging is easy!

How to Upgrade (or Update) Planning Analytics Workspace

Step by step instructions for updating Planning Analytics Workspace server on Windows Server 2016.

Useful TM1 and Planning Analytics URLs

Here is a collection of useful TM1 and Planning Analytics related URL’s. They include TM1Web, PAW, Ops Console, the Cognos Dispatcher and Gateway

How to Connect Architect or Perspectives 10.2.x to Planning Analytics

Here is how to use TM1 Architect or Perspectives with both a new and old server environment, so with both older TM1 10.2.2 server and Planning Analytics.

TM1 Excel Reporting Best Practices – Control Tab

The Control Tab in Excel is a great way to keep system relevant variables for your TM1 Excel based reports.

PAX Connection Greyed Out

Troubleshooting and correcting a greyed out connection to a TM1 server from within Planning Analytics for Excel.

Connecting Planning Analytics for Excel (PAX) to TM1

Here we detail how to create a new connection in Planning Analytics for Excel (PAX) to a TM1 model or server with screenshots to guide you along the way.

How to Take a Snapshot in Planning Analytics for Excel

Here is how to create a snapshot of a TM1 report in Planning Analytics for Excel – PAX. This essentially does a copy, paste special, values on the TM1 formulae only, leaving all your Excel formulae untouched. It is very useful for creating a version of a TM1 report that is disconnected from the underlying TM1 data.

How to Install Planning the Analytics for Excel (PAX) Add-in to Excel

How to install IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots.

How to Enable the TM1 Excel Addin and TM1 Perspectives Ribbon in Excel

I recently started working with a new PC and it did not have the TM1 Excel Perspectives add-in enabled and obviously I therefore did not have the TM1 Perspectives Ribbon included in Excel. So I thought I would do a quick blog about how to enable it. What this does is then automatically add the Perspectives add-in to Excel on your PC so that TM1 automatically opens each time you … Continue Reading