Posts
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
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
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
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
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)?
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
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
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
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
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
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
Keen to chat? Book a discovery call!