Planning Analytics for Excel (PAX/PAfE)

Excel Functions, Excel Reports

How to use DefineCalc to Create a User Defined Calculation

One of the most useful features of TM1 is the ability for users to create custom rollups, by…
Excel Functions

TM1USER TM1 Excel Syntax and Use

TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER…
Excel Functions

DBSW TM1 Excel Syntax and Use

The DBSW function in TM1 sends a numeric value to a TM1 cube.  Syntax The syntax for using…
Excel Functions

DBS TM1 Excel Syntax and Use

DBS is an Excel based function, used to send numeric values to a TM1 cube’s cell. Example To…
Excel Functions

DBR TM1 Excel Syntax and Use

DBR function is used to retrieve a value from a specified TM1 cube. DBR Syntax The syntax for…
Excel Functions

VIEW TM1 Excel Syntax and Use

The VIEW function enhances the efficiency of a Planning Analytics for Excel Custom Reports or Dynamic Reports by…
Excel Functions

DBSS TM1 Excel Syntax and Use

The DBSS function sends a string value to any TM1 cube’s cell. DBSS Syntax The syntax for DBSS…
Excel Functions

DBSA TM1 Excel Syntax and Use

DBSA allows you to send a value (numeric or string) to an attribute of an element in a…
Reporting Case Studies, Training

How to Upgrade from Perspectives to Planning Analytics for Excel (PAX/PAfE)

We are about to upgrade one of the largest TM1 sites in the world from using Perspectives to…
Installation/Configuration

How to Install or Upgrade Planning Analytics for Excel Add-in up until 2.0.64

Updated for PAX 2.0.63. How to install or upgrade IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots and warnings about keeping PAX, PAW and PA versions up to date.

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

Subscribe Now