Planning Analytics for Excel Functions

28 min total time

11 articles

2 authors

Start Reading

Playlist

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…

11 posts - 2 authors

Cognos Analytics | Excel Reports | TI Functions

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

Dynamic TM1 Server Name in Excel Workbook

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

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

DBRW Example

Dynamic Reports | Excel Functions | Excel Reports

DBRW TM1 Excel Syntax and Use

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

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

Excel Functions

DBRA TM1 Excel Syntax and Use

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

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

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

TM1USER TM1 Excel Syntax and Use

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

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

Excel Functions

VIEW TM1 Excel Syntax and Use

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