Planning Analytics for Excel

Planning Analytics Spreadsheet Services Explained

Planning Analytics Spreadsheet Services replaces TM1Web. We explain what it is, why, where to get it, installation and where to get more info.

Why Should You Upgrade from TM1 to Planning Analytics

IBM’s Planning Analytics is a great improvement from TM1 version 10.2, but is it right for you? Here we discuss the major benefits of upgrading.

ViewConstruct TM1 Function: Syntax and Use

The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.

Thousands Format an Excel Report

Here we explain how to format an Excel based report to show values in thousands, even though the source is in whole numbers.

Cell Annotations in Planning Analytics for Excel

Annotations in Planning Analytics for Excel allow you to record notes on a specific cell of a TM1 cube direclty in PAX or PAW.

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 Planning Analytics Workspace

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

TM1 Links

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

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