Exploring TM1

Latest Posts

Deployment

9 Apr 2025

Planning Analytics IRAP Certification in Australia

IBM is set to enhance Planning Analytics with IRAP certification on AWS, ensuring a robust cybersecurity framework for government and...

johnv

4 min Read

MDX, Planning Analytics Workspace

22 Nov 2024

Asymmetrical Views in Planning Analytics Workspace

Unlock the power of asymmetrical views in Planning Analytics Workspace (PAW) and transform your reporting! While traditional views offer symmetry,...

Kathryn Dalton

10 min Read

Planning Analytics Workspace

6 Nov 2024

The Point-as-Line Chart, PAW and Beyond – I Was Wrong

I have a confession. In my article about the point chart, I disavowed IBM’s suggestion that a point chart is...

Kathryn Dalton

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

johnv

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

johnv

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

Deployment

9 Apr 2025

Planning Analytics IRAP Certification in Australia

IBM is set to enhance Planning Analytics with IRAP certification on AWS, ensuring a robust cybersecurity framework for government and...

johnv

4 min Read

MDX, Planning Analytics Workspace

22 Nov 2024

Asymmetrical Views in Planning Analytics Workspace

Unlock the power of asymmetrical views in Planning Analytics Workspace (PAW) and transform your reporting! While traditional views offer symmetry,...

Kathryn Dalton

10 min Read

Planning Analytics Workspace

6 Nov 2024

The Point-as-Line Chart, PAW and Beyond – I Was Wrong

I have a confession. In my article about the point chart, I disavowed IBM’s suggestion that a point chart is...

Kathryn Dalton

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

johnv

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

johnv

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

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

johnv

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

johnv

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

johnv

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

johnv

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

johnv

Installation / Configuration

4 Mar 2024

SSL Configuration for Planning Analytics

...

johnv

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

johnv

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

johnv

Latest Posts

Planning Analytics IRAP Certification in Australia

Asymmetrical Views in Planning Analytics Workspace

The Point-as-Line Chart, PAW and Beyond – I Was Wrong

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

Planning Analytics IRAP Certification in Australia

Asymmetrical Views in Planning Analytics Workspace

The Point-as-Line Chart, PAW and Beyond – I Was Wrong

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

Popular Articles

Naming Conventions and Syntax

Linking Cubes with Performance Modeler

How to use SPSS Modeler and Time Series Algorithms to Forecast Revenues

Picklists in Planning Analytics: How to Create and Use Them

Generating a Time Dimension in Performance Modeller

First TM1 Feeder!

Feeding from a Consolidation to a Leaf Element in TM1

ExecuteProcess TM1 Function: How to Use, Example and Syntax

Official IBM Documentation

How to Install or Upgrade Planning Analytics for Excel (PAX/PAfE) Add-in

This is a Placeholder Title for an Advert

Featured Posts

Asymmetrical Views in Planning Analytics Workspace

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

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