Excel Functions

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

How to use DefineCalc to Create a User Defined Calculation

Posted on Aug 21, 2023 by Max Haynes

One of the most useful features of TM1 is the ability for users to create custom rollups, by way of User Defined Consolidation (UDC). Unfortunately, this feature is only available…

TM1USER TM1 Excel Syntax and Use

Posted on Aug 18, 2023 by Rehmat Walia

TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: TM1User(“ServerName”) Where: ServerName : The name…

DBSW TM1 Excel Syntax and Use

Posted on Aug 11, 2023 by Rehmat Walia

The DBSW function in TM1 sends a numeric value to a TM1 cube.  Syntax The syntax for using DBSW function is: DBSW(value, cube, e1, e2[,…en]) Where: Value: The numeric value…

DBS TM1 Excel Syntax and Use

Posted on Jul 30, 2023 by Rehmat Walia

DBS is an Excel based function, used to send numeric values to a TM1 cube’s cell. Example To illustrate the usage of DBS, let’s consider a Sales Analysis cube with…

DBR TM1 Excel Syntax and Use

Posted on Jul 23, 2023 by Rehmat Walia

DBR function is used to retrieve a value from a specified TM1 cube. DBR Syntax The syntax for DBR function is as following: DBR(server:cube, e1, e2,[…en]) Where: server:cube: name of…

VIEW TM1 Excel Syntax and Use

Posted on Jul 16, 2023 by Rehmat Walia

The VIEW function enhances the efficiency of a Planning Analytics for Excel Custom Reports or Dynamic Reports by establishing an optimised representation of a cube. This feature speeds up report…

DBSS TM1 Excel Syntax and Use

Posted on Jun 29, 2023 by Rehmat Walia

The DBSS function sends a string value to any TM1 cube’s cell. DBSS Syntax The syntax for DBSS is: DBSS (string, cube, e1, e2,…en) Where: string: The string value that…

DBSA TM1 Excel Syntax and Use

Posted on Jun 23, 2023 by Rehmat Walia

DBSA allows you to send a value (numeric or string) to an attribute of an element in a dimension. DBSA Syntax The syntax for this function is: DBSA(attribute_value, dimension, element,…

How to Get an Element ID from an Alias in an TM1 Excel Report

Posted on Dec 14, 2020 by John

Have you ever needed to derive the primary element name from a TM1 alias in Excel? Essentially, do the equivalent of DimensionElementPrincipalName (a TI and Rule function) in a TM1…

How to Display Traffic Lights using TM1

Posted on Dec 20, 2019 by John

Have you ever needed to create a TM1 report that uses Traffic Lights? You know, those little Red, Green or Orange (Amber) indicators that everything is good in your world,…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles

Keen to chat? Book a discovery call!

pen