Planning Analytics for Excel Functions

This series takes us through Planning Analytics for Excel specific functions. From the functions used to send data to a TM1 cube, to the read write functions and picklist functions used widely, to the very special TM1 functions used in Dynamic Reports, we will take you through all the most frequently used Planning Analytics for Excel functions.

Excel Functions | Reporting

TM1USER TM1 Excel Syntax and Use

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

Excel Functions | Reporting

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 | Reporting

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 | Reporting

DBR TM1 Excel Syntax and Use

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

Excel Functions | Reporting

VIEW TM1 Excel Syntax and Use

The VIEW function enhances the efficiency of a Planning Analytics for Excel Custom Reports or...

Excel Functions | Reporting

DBSS TM1 Excel Syntax and Use

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

Excel Functions | Reporting

DBSA TM1 Excel Syntax and Use

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

Cognos Analytics | Excel Reports | Reporting | TI Functions | Turbo Integrator

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

Excel Functions | Reporting

Dynamic TM1 Server Name in Excel Workbook

Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean...

DBRW Example

Dynamic Reports | Excel Functions | Excel Reports | Reporting

DBRW TM1 Excel Syntax and Use

Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display...

Excel Functions | Reporting

DBRA TM1 Excel Syntax and Use

Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display...

ELPARN TM1

Rule Functions | TI Functions

ELPARN TM1 Function: How to Use and Syntax

ELPARN is a TM1 function for calculating the number of parents an element has. This includes the...