How to Use Data Spreading in Planning Analytics
Data Spreading is the automatic distribution of a numeric value from a parent to leaf level cells beneath it. When a value is entered at a parent intersection, that value is distributed to all input cells consolidating up to the cell where the data was entered. For example, entering 1200 to a consolidation of all […]
How to do Conditional Formatting on Consolidated and Leaf Cells in PAW – A Quick Guide
A game-changing technique for visually pinpointing leaf and consolidated members within PAW is to masterfully apply conditional formatting. While not a built-in feature of IBM PAW, this power-packed method transforms your data visualization.
Personalise the PAW User Experience
Enhance the Planning Analytics Workspace user experience by personalising it to remember previous selections. Learn how to create a User Parameters cube for a customised experience.
Automatically Display Current Period in Planning Analytics Workspace and Excel with Clever MDX
Discover a clever method to dynamically update period selectors to the current month in Planning Analytics Workspace and Excel.
How to Download Planning Analytics Local
Simple, step by step guide (including screenshots) how to download Planning Analytics Local (TM1) Server.
How to Calculate SUMIF in TM1
IBM does not provide a native function to calculate SUMIF in TM1. How do I calculate SUMIF in TM1 and perform a sum of values based on a user input? How to Calculate SUMIF in TM1 based on User Input Let’s say I want to calculate sum of the values based on the data entry […]
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 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 […]
Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1
Do you have slow reports with large subsets using MDX? Here’s a best practice guide with screenshots to fix poor performing MDX based subsets.
How to Install Mirantis Container Runtime (Docker) on Windows Server 2019
If you need to install Mirantis Container Runtime (formerly known as Docker) to Windows Server 2019, there are few steps to follow. This post takes you through the steps to download the software and install it onto Windows Server 2019. Mirantis Container Runtime License First up, note that you don’t need a Mirantis license to […]
How to Install Planning Analytics Workspace Windows 2019
Detailed instructions with screenshots for installing Planning Analytics Workspace on Windows Server 2019, including how to install MCS.
TM1 Cell Security: How To Do It and Best Practices
TM1’s security can be as simple or as complex as you need. We tend to start with the broadest possible definition of security and then refine it down to the specific, to the cell if required. TM1 cell security places an overhead for your administrator to manage as it can get complex, not only within […]
TM1 RoundUp Function: Method, Syntax and Use
The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method to achieve in TM1 what is available in Excel via the RoundUp function uses the INT function and some clever usage of negatives. Here it […]
N Level-MDX for Leaf Level Elements from an Ancestor in TM1
Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.
Cascading Picklists in TM1 – How to Create in 4 Steps
Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.
How to Download Planning Analytics Local, Workspace, Excel and Spreadsheet Services
Step by step guide (including screenshots) how to download Planning Analytics Local, Planning Analytics Workspace, Planning Analytics for Excel and Planning Analytics Spreadsheet Services.
How to Limit PAX for Specific Remote Desktop Users
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 […]
TM1 Health: How to Maintain Your TM1 Server
Regular maintenance of your TM1 server will help keep it healthy. Here is our guide for what you need to do systematically to maintain great TM1 server health.
Planning Analytics Workspace Scripts Explained
Planning Analytics Workspace scripts allow you to manage the entire PAW interface direct from a command line. Here we explain the major ones and how to use them.
How to Limit TM1 Rule Scope (and speed up your model!)
Simple method for cutting down the calculation overhead of TM1 rules for a multi year forecasting model by limiting rule scope.
How to Install Planning Analytics Workspace Windows 2016
Detailed instructions on how to install Planning Analytics Workspace and Docker onto Windows Server 2016. Updated for PAW version 2.0.57.