Admin Best Practices, Licencing, TM1 Management
26 Aug 2025
Planning Analytics Workspace has been available now for us to use for modelling and administration of TM1 models. I was...
johnv
3 min Read
Deployment
9 Apr 2025
4 min Read
MDX, Planning Analytics Workspace
22 Nov 2024
Kathryn Dalton
10 min Read
Planning Analytics Workspace
6 Nov 2024
I have a confession. In my article about the point chart, I disavowed IBM’s suggestion that a point chart is...
8 min Read
What's New
24 Sep 2024
If you’ve been around the TM1 community for a while, you’ve no doubt seen how IBM Planning Analytics has grown...
7 min Read
Installation / Configuration
19 Sep 2024
IBM have a version of Planning Analytics on AWS (and soon to be Azure) called Planning Analytics as a Service...
Charissa Mckie
Forms & Data Entry
10 Sep 2024
Data Spreading is the automatic distribution of a numeric value from a parent to leaf level cells beneath it. When...
Ayomiposi Fajemilehin
12 min Read
3 Sep 2024
In TM1 we have multiple administration capabilities that can be assigned for differentiating the roles different administrators have within a...
Excel Reports, Planning Analytics Workspace
2 Sep 2024
Srinivas STP
5 min Read
MDX
21 Aug 2024
2 min Read
Excel Functions, Rule Functions, TI Functions
28 Sep 2014
Dimension Best Practices, Sets
9 Jul 2013
In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked...
Nova Hartanty
Rule Best Practices, Rule Functions, Rules
26 Oct 2014
Administration, Backups
11 Mar 2015
Backing up your TM1 and/or Cognos Express environment is vital. Without it, you potentially could lose months of work and...
TI Case Studies, Turbo Integrator
10 Feb 2016
Attributes, Dimensions, Rule Functions, Rules, TI Functions, Turbo Integrator
2 Sep 2014
1 min Read
6 Sep 2023
Definition The TM1 MDX function FILTER in IBM Planning Analytics is utilised to selectively retrieve data from multidimensional cubes based...
kav1908
Administration, Attributes, Dimensions, TI Case Studies, TI Functions, tm1s.cfg, Turbo Integrator, Virtual Dimensions
1 Nov 2018
Boon Ong
TI Best Practices, TI Functions, Turbo Integrator
23 Sep 2014
Uncategorized
17 Aug 2008
Attached is the presentation I did for the Sydney TM1 Usergroup organized by Amendra Pratap. This covers most of the...
Ben Hill
This is a placeholder paragraph for the content you are advertising. This can be as big or as small as you’d like. Colour and design will change depending on the advert being featured.
Planning Analytics Workspace, Reporting Case Studies
11 Jun 2024
Max Haynes
Dimension Best Practices, Dimensions
11 Aug 2023
Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes...
6 min Read
Admin Best Practices, Administration, Dimension Best Practices, Dimensions, MDX, Sets
Gautam Narula
TI Best Practices, Turbo Integrator
5 Jan 2022
Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For...
Quick Reports
20 Mar 2024
Quick Reports are one of the “new” methods of creating reports in Planning Analytics for Excel. They are super easy to create, they are fast, hierarchy aware and easy to format. In this series we...
4 Mar 2024
24 Jul 2023
Dimensions
5 Jul 2023
Managing dimensions is one of the most important activities for any TM1 administrator. In this series we present all our posts on how to manage dimensions in TM1, from inserting elements, rolling up, or consolidating,...
22 Jun 2023
Planning Analytics Workspace has a large array of visualisations available. From bar and column charts, to pie, line, and bubble, then all the way to waterfall and marimekko and scatter charts, the options are vast....
Excel Functions
19 Jun 2023
This series takes us through Planning Analytics for Excel specific functions. From the functions used to send data to a TM1 cube, to the read write functions and picklist functions used widely, to the very...
Rule Functions
8 Oct 2021
We ran a survey to identify the Top 10 TM1 Rule functions. The results are interesting, and, dare I say it a little surprising! Here’s the results and links to each of the posts explaining...
29 Oct 2020
Here is a series that covers the installation and configuration of the core Planning Analytics server, then Planning Analytics Workspace, Planning Analytics Spreadsheet Services (TM1Web) and Planning Analytics for Excel. Int this series we cover:...
Attributes, TI Case Studies, Virtual Dimensions
6 Apr 2020
Hierarchies, or Virtual Dimensions, are a really great way of adding significant analytic capability to your TM1 model. With them, you are effectively adding new dimensions to your cube, without actually modifying the structure of...
Rule Functions, TI Functions
20 Mar 2020
All about strings. Whether you’re a cat chasing a ball of string, or a TM1 admin manipulating strings to push them out to an ASCII file, concatenating them, or sending them to a text-based attribute,...
Security
TM1 Security is one of those things that is really easy to set up and really easy to screw up. It can be really simple, or it can be a nightmare! In this series, we...
Cognos Analytics
Here is a selection of our blog posts on using Cognos Analytics (Cognos BI) over the top of TM1 cubes. Now for over ten years, IBM has owned Cognos and TM1 and only now we...
tm1s.cfg
TM1s.cfg governs the way each tm1 moel (server) works. Here’s our posts on configuring tm1s.cfg. Whether it is to set up AD security, enable virtual dimensions, to use Excel dates or changing the way feeders...
Excel Reports
Presenting a series of posts all about reporting using Excel. From Traffic Lights to GL analysis, Top 10 reports and just creating list reports.
Here is all you need to know about installing and managing Planning Analytics for Excel (PAX). Whether you need to install, connect to a TM1 server, or have some issues with PAX, we have you...
Excel Reports, Rule Functions, TI Functions
25 Feb 2020
This series focusses on the manipulation and use of date and time in TM1 and Planning Analytics. We cover not only the functions, but also how to set your TM1 model to use the same...
