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.

01.

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

johnv Vaughan

1 min read

Read

02.

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

johnv Vaughan

3 min read

Read

03.

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

johnv Vaughan

3 min read

Read

04.

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

johnv Vaughan

2 min read

Read

05.

Excel Functions | Reporting

VIEW TM1 Excel Syntax and Use

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

johnv Vaughan

3 min read

Read

06.

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

johnv Vaughan

2 min read

Read

07.

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

johnv Vaughan

2 min read

Read

08.

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

johnv Vaughan

2 min read

Read

09.

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

johnv Vaughan

4 min read

Read

10.

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

johnv Vaughan

3 min read

Read

11.

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

johnv Vaughan

3 min read

Read

12.

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

johnv Vaughan

2 min read

Read