Exploring TM1

Latest Posts

What's New

24 Sep 2024

The Future of TM1/Planning Analytics: Trends and Innovations to Watch

If you’ve been around the TM1 community for a while, you’ve no doubt seen how IBM Planning Analytics has grown...

John Vaughan

7 min Read

Installation / Configuration

19 Sep 2024

Migrating On-Premise TM1 Server to Planning Analytics as a Service

IBM have a version of Planning Analytics on AWS (and soon to be Azure) called Planning Analytics as a Service...

Charissa Mckie

4 min Read

Forms & Data Entry

10 Sep 2024

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...

Ayomiposi Fajemilehin

12 min Read

Admin Best Practices, Licencing, TM1 Management

3 Sep 2024

What are the TM1 Administration Admin Roles

In TM1 we have multiple administration capabilities that can be assigned for differentiating the roles different administrators have within a...

John Vaughan

3 min Read

Excel Reports, Planning Analytics Workspace

2 Sep 2024

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...

Srinivas STP

5 min Read

MDX

21 Aug 2024

SIBLINGS MDX Function in TM1: Syntax, Use and Examples

Revolutionize your planning process with Siblings MDX. This powerful function simplifies data comparison, uncovers hidden insights, and drives smarter business...

Srinivas STP

2 min Read

MDX

8 Aug 2024

TOPCOUNT MDX Function in TM1: Syntax, Use and Examples

Have you ever wanted to identify the cream of the crop within your data in IBM Planning Analytics? Well, look...

Srinivas STP

4 min Read

MDX

15 Jul 2024

BOTTOMCOUNT MDX Function in TM1: Syntax, Use and Examples

While the world often focuses on top performers, IBM Planning Analytics empowers you to delve deeper with the BOTTOMCOUNT MDX...

Srinivas STP

4 min Read

MDX

28 Jun 2024

HEAD MDX Function in TM1: Syntax, Use and Examples

Unleash the power of the HEAD MDX function in IBM Planning Analytics! This function is both user-friendly and versatile. It...

Srinivas STP

4 min Read

MDX

27 Jun 2024

TAIL MDX Function in TM1: Syntax, Use and Examples

Discover the awesomeness of the TAIL MDX function for IBM Planning Analytics! It's easy to use and lets you get...

Srinivas STP

4 min Read

What's New

24 Sep 2024

The Future of TM1/Planning Analytics: Trends and Innovations to Watch

If you’ve been around the TM1 community for a while, you’ve no doubt seen how IBM Planning Analytics has grown...

John Vaughan

7 min Read

Installation / Configuration

19 Sep 2024

Migrating On-Premise TM1 Server to Planning Analytics as a Service

IBM have a version of Planning Analytics on AWS (and soon to be Azure) called Planning Analytics as a Service...

Charissa Mckie

4 min Read

Forms & Data Entry

10 Sep 2024

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...

Ayomiposi Fajemilehin

12 min Read

Admin Best Practices, Licencing, TM1 Management

3 Sep 2024

What are the TM1 Administration Admin Roles

In TM1 we have multiple administration capabilities that can be assigned for differentiating the roles different administrators have within a...

John Vaughan

3 min Read

Excel Reports, Planning Analytics Workspace

2 Sep 2024

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...

Srinivas STP

5 min Read

MDX

21 Aug 2024

SIBLINGS MDX Function in TM1: Syntax, Use and Examples

Revolutionize your planning process with Siblings MDX. This powerful function simplifies data comparison, uncovers hidden insights, and drives smarter business...

Srinivas STP

2 min Read

MDX

8 Aug 2024

TOPCOUNT MDX Function in TM1: Syntax, Use and Examples

Have you ever wanted to identify the cream of the crop within your data in IBM Planning Analytics? Well, look...

Srinivas STP

4 min Read

MDX

15 Jul 2024

BOTTOMCOUNT MDX Function in TM1: Syntax, Use and Examples

While the world often focuses on top performers, IBM Planning Analytics empowers you to delve deeper with the BOTTOMCOUNT MDX...

Srinivas STP

4 min Read

MDX

28 Jun 2024

HEAD MDX Function in TM1: Syntax, Use and Examples

Unleash the power of the HEAD MDX function in IBM Planning Analytics! This function is both user-friendly and versatile. It...

Srinivas STP

4 min Read

MDX

27 Jun 2024

TAIL MDX Function in TM1: Syntax, Use and Examples

Discover the awesomeness of the TAIL MDX function for IBM Planning Analytics! It's easy to use and lets you get...

Srinivas STP

4 min Read

This is a Placeholder Title for an Advert

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.

Best Practices

Admin Best Practices, Licencing, TM1 Management

3 Sep 2024

What are the TM1 Administration Admin Roles

In TM1 we have multiple administration capabilities that can be assigned for differentiating the roles different administrators have within a...

John Vaughan

3 min Read

Dimension Best Practices, Dimensions

11 Aug 2023

Dimensions in TM1

Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes...

John Vaughan

6 min Read

Admin Best Practices, Administration, Dimension Best Practices, Dimensions, MDX, Sets

11 Aug 2023

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...

Gautam Narula

4 min Read

TI Best Practices, Turbo Integrator

5 Jan 2022

How to Convert a Text Date-time to a Numeric Element

Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For...

John Vaughan

3 min Read

Dimensions, Exploring TM1, Picklists, Rule Best Practices, Rules, TM1 Case Studies

3 Aug 2021

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...

John Vaughan

4 min Read

Series

Quick Reports

20 Mar 2024

Quick Reports in Planning Analytics for Excel

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...

John Vaughan

Installation / Configuration

4 Mar 2024

SSL Configuration for Planning Analytics

This series takes you through how to configure SSL for the entire TM1 stack, from the core server itself, to the Cognos server for CAM security, through to the PAW and TM1Web servers....

John Vaughan

MDX

24 Jul 2023

MDX in Planning Analytics

MDX, or Multi Dimensional Expressions, are at the core of Planning Analytics for Excel, Planning Analytics Workspace and the Set Editor right throughout TM1. This series covers the basics through to more complex uses of...

John Vaughan

Dimensions

5 Jul 2023

Dimension Management

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,...

John Vaughan

Planning Analytics Workspace

22 Jun 2023

Planning Analytics Workspace Visualisations

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....

John Vaughan

Excel Functions

19 Jun 2023

Planning Analytics for Excel Functions

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...

John Vaughan

Rule Functions

8 Oct 2021

Top 10 TM1 Rule Functions

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...

John Vaughan

Installation / Configuration

29 Oct 2020

Planning Analytics + Components Installation

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:...

John Vaughan

Attributes, TI Case Studies, Virtual Dimensions

6 Apr 2020

Virtual Dimensions (Hierarchies)

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...

John Vaughan

Rule Functions, TI Functions

20 Mar 2020

Strings: All You Can Eat!

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,...

John Vaughan

Security

20 Mar 2020

TM1 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...

John Vaughan

Cognos Analytics

20 Mar 2020

Cognos Analytics and TM1

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...

John Vaughan

tm1s.cfg

20 Mar 2020

TMs.cfg: Useful Tips for Configuring TM1 via 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...

John Vaughan

Excel Reports

20 Mar 2020

Reporting from Excel: Methods and Best Practices

Presenting a series of posts all about reporting using Excel. From Traffic Lights to GL analysis, Top 10 reports and just creating list reports.

...

John Vaughan

Installation / Configuration

20 Mar 2020

Planning Analytics for Excel – PAX – Installation, Connection, Errors, Version Management

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...

John Vaughan

Excel Reports, Rule Functions, TI Functions

25 Feb 2020

Dates and Time in TM1

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...

John Vaughan

Latest Posts

The Future of TM1/Planning Analytics: Trends and Innovations to Watch

Migrating On-Premise TM1 Server to Planning Analytics as a Service

How to Use Data Spreading in Planning Analytics

What are the TM1 Administration Admin Roles

How to do Conditional Formatting on Consolidated and Leaf Cells in PAW – A Quick Guide

SIBLINGS MDX Function in TM1: Syntax, Use and Examples

TOPCOUNT MDX Function in TM1: Syntax, Use and Examples

BOTTOMCOUNT MDX Function in TM1: Syntax, Use and Examples

HEAD MDX Function in TM1: Syntax, Use and Examples

TAIL MDX Function in TM1: Syntax, Use and Examples

The Future of TM1/Planning Analytics: Trends and Innovations to Watch

Migrating On-Premise TM1 Server to Planning Analytics as a Service

How to Use Data Spreading in Planning Analytics

What are the TM1 Administration Admin Roles

How to do Conditional Formatting on Consolidated and Leaf Cells in PAW – A Quick Guide

SIBLINGS MDX Function in TM1: Syntax, Use and Examples

TOPCOUNT MDX Function in TM1: Syntax, Use and Examples

BOTTOMCOUNT MDX Function in TM1: Syntax, Use and Examples

HEAD MDX Function in TM1: Syntax, Use and Examples

TAIL MDX Function in TM1: Syntax, Use and Examples

Popular Articles

What is the IBM License Metric Tool (ILMT)

Why Should You Upgrade from TM1 to Planning Analytics

How to Save Data in TM1 – Manually and Automatically

ViewExtractSkipCalcsSet TM1 Function: Syntax and Use

How to Define a TM1 User as an TM1 Administrator

TM1 Health: How to Maintain Your TM1 Server

Running a TI Process from within another Process

Commenting Out Rule and TI Lines

How to Create a Secure Gateway for Planning Analytics

Setting Default Element and Level Names in TM1 for use in Cognos BI

This is a Placeholder Title for an Advert

Featured Posts

The Future of TM1/Planning Analytics: Trends and Innovations to Watch

How to Use Data Spreading in Planning Analytics

How to do Conditional Formatting on Consolidated and Leaf Cells in PAW – A Quick Guide

Personalise the PAW User Experience

Automatically Display Current Period in Planning Analytics Workspace and Excel with Clever MDX

Best Practices

What are the TM1 Administration Admin Roles

Dimensions in TM1

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

How to Convert a Text Date-time to a Numeric Element

Cascading Picklists in TM1 – How to Create in 4 Steps

Series

Quick Reports in Planning Analytics for Excel

SSL Configuration for Planning Analytics

MDX in Planning Analytics

Dimension Management

Planning Analytics Workspace Visualisations

Planning Analytics for Excel Functions

Top 10 TM1 Rule Functions

Planning Analytics + Components Installation

Virtual Dimensions (Hierarchies)

Strings: All You Can Eat!

TM1 Security

Cognos Analytics and TM1

TMs.cfg: Useful Tips for Configuring TM1 via tm1s.cfg

Reporting from Excel: Methods and Best Practices

Planning Analytics for Excel – PAX – Installation, Connection, Errors, Version Management

Dates and Time in TM1

Contact

Company

Resources

Log In