Perspectives

Reporting Case Studies, Sets

How to Create a User Defined Consolidation in TM1 Architect & Perspectives

Sometimes we want to create a rollup of elements from a dimension that does not exist in the…
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…
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.
Installation/Configuration, TM1 Management

Use 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.

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