How to use DefineCalc to Create a User Defined Calculation
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
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 function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: Where: Example and Usage To provide
The DBSW function in TM1 sends a numeric value to a TM1 cube. Syntax The syntax for using DBSW function is: Where: The arguments e1 through en are sequence sensitive,
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 function is used to retrieve a value from a specified TM1 cube. DBR Syntax The syntax for DBR function is as following: Where: A few things to note here
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
The DBSS function sends a string value to any TM1 cube’s cell. DBSS Syntax The syntax for DBSS is: Where: Importance of Sequence It is important to note that the
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: Where: Example of
Need to get a primary element name from an alias in a TM1 Excel report or TM1 Rule? Simple solution for deriving an element principal name in Rules or Excel.
Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to follow to create them and a series of ideas for their use.
SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel, PAX, TM1Web or PAW report or form and open the subset editor to select elements.
Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.
The Control Tab in Excel is a great way to keep system relevant variables for your TM1 Excel based reports.
Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.
Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.
Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display the contents of a specific intersection of a TM1 cube.
Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA
Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display the contents of an Attribute in the Excel sheet.
ELPAR is a TM1 worksheet function for showing the parent value of an element. This explains the syntax and use of ELPAR, however it is better to use ATTRS.
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976