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.

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…

Dimensions in TM1

Posted on Aug 11, 2023 by John

Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes to hold data. What are Dimensions? Dimensions in TM1 are…

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

Posted on Aug 11, 2023 by Gautam Narula

Having MDX based dynamic subsets in TM1 is a fantastic way to ensure that reports, forms and processes that use those subsets contain all required elements. But there is an…

Do you need IBM’s License Metric Tool (ILMT)?

Posted on Aug 9, 2023 by Kleber

Introduction Most organisations that own IBM server software are required in their contract with IBM to manage those licences in a way that is able to be audited and show…

Descendants MDX Function in Planning Analytics

Posted on Aug 7, 2023 by Kleber

Definition The ‘Descendants’ MDX function in TM1/Planning Analytics is used to generate a set containing all descendant members (i.e. children, grand children, great grand children etc) below a specified member…

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…

DimensionElementComponentAddDirect TM1 Function: How to Use, Examples and Syntax

Posted on Jul 5, 2023 by John

DimensionElementComponentAddDirect adds an existing element in a TM1 dimension into a hierarchy as a child of another element immediately.  In other words, it is used to create rollups as the command…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!