Planning Analytics for Excel (PAX/PAfE)

How to Download Planning Analytics Local

Simple, step by step guide (including screenshots) how to download Planning Analytics Local (TM1) Server.

Universal Reports Prerequisites

A Universal Report is a new type of dynamic report that is hierarchy aware. It utilises TM1SET formulas…

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…

TM1USER TM1 Excel Syntax and Use

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

DBSW TM1 Excel Syntax and Use

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

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…

DBR TM1 Excel Syntax and Use

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

VIEW TM1 Excel Syntax and Use

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

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…

DBSA TM1 Excel Syntax and Use

DBSA allows you to send a value (numeric or string) to an attribute of an element in a…

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