Planning Analytics for Excel

Planning Analytics for Excel (PAX) Ribbon Not Visible

The Planning Analytics for Excel ribbon is somewhat unreliable. Here we explain what drives the PAX toolbar, the add-ins and how and what to activate and a registry change that might be required.

Dynamic TM1 Server Name in Excel Workbook

Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.

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 and really helps IBM resolve problems with PAX.

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.

Creating a Dynamic Print Area in a Dynamic Report in TM1

Need to create a dynamic print area in a TM1 Dynamic Report or Active Form? Here are detailed instructions of exactly how to do this really easily!

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.

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement