Simple, step by step guide (including screenshots) how to download Planning Analytics Local (TM1) Server.
A Universal Report is a new type of dynamic report that is hierarchy aware. It utilises TM1SET formulas and named ranges to achieve this. The Prerequisites vary depending on your environment, as explained below. PA Server Prerequisites for Universal Reports on IBM Cloud Customers must request that their PA server be upgraded to 188.8.131.52 IF2. […]
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 in Perspectives and Architect. That is, until now. Introducing DefineCalc. DefineCalc is a function in IBM Planning Analytics for Microsoft Excel (PAfE), that allows users […]
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 an example of how this function is used, let’s consider a simple scenario. Suppose there is a server named “NebulaFit” and a user named Tom […]
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, meaning the order of the elements is important. e1 corresponds to an element from the first dimension of the cube, e2 corresponds to an element […]
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 the dimensions : Year, Month, Customer, Product, and Measures. Suppose we want to insert the value of $1000 in the intersection of: Syntax of DBS […]
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 regarding the arguments e1 through en: Importance of Sequence in DBR Syntax The sequence of the arguments is crucial. e1 should correspond to an element […]
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 retrieval, especially during slicing operations in Perspectives or when exporting a Custom Report in PAX. It achieves faster retrieval by establishing an optimised representation of […]
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 arguments (e1…en) follow a specific sequence in which e1 corresponds to an element from the first dimension of the cube, e2 corresponds to an element […]
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 DBSA We have a dimension, Employee, with the attributes Name, ID-Name, Department and Age. We want to update the Name attribute for employee with the […]
We are about to upgrade one of the largest TM1 sites in the world from using Perspectives to Planning Analysis for Excel (PAX/PAfE). This is a guide to what you should consider when upgrading from TM1 Perspectives to Planning Analytics for Excel. Perspectives to Planning Analytics for Excel Upgrade Process Generally speaking, the upgrade from […]
Updated for PAX 2.0.63. How to install or upgrade IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots and warnings about keeping PAX, PAW and PA versions up to date.
Step by step guide (including screenshots) how to download Planning Analytics Local, Planning Analytics Workspace, Planning Analytics for Excel and Planning Analytics Spreadsheet Services.
We have a client who operate remote desktop centrally for all their users – so most people don’t have, say, Microsoft Office installed directly on their local desktop. The exception is some laptops, but even then when they need to access shared resources, they need to connect to remote desktop to gain access to shared […]
Planning Analytics Spreadsheet Services replaces TM1Web. We explain what it is, why, where to get it, installation and where to get more info.
IBM’s Planning Analytics is a great improvement from TM1 version 10.2, but is it right for you? Here we discuss the major benefits of upgrading.
The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.
Here we explain how to format an Excel based report to show values in thousands, even though the source is in whole numbers.
Annotations in Planning Analytics for Excel allow you to record notes on a specific cell of a TM1 cube direclty in PAX or PAW.
The Planning Analytics for Excel ribbon is somewhat unreliable. Here we explain what drives the PAX toolbar, the add-ins and how and what to activate and a registry change that might be required.