Dimensions in TM1

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

Roll Forward

How to Roll Forward Values from One Period to the Next in TM1

Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.

TM1 Clear Attribute – an AttrClear Function

The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example

General Ledger Analysis with TM1

Do you have Excel based TM1 reports with hard coded Excel SUM formulae? Or manually entered line descriptions on your P&L or Balance Sheet, or a General Ledger cube with negatives for credits and positives for debits, when your users want to see all positive values? Here’s a quick case study for what we achieved for a new client last week that delivers all this and enables the GL cube to be easily used in Planning Analytics Workspace.

How to Create Virtual Dimensions in TM1/Planning Analytics

Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.

"Joining" Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

DBRA TM1 Excel Syntax and Use

Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display the contents of an Attribute in the Excel sheet.

Understanding Attributes in TM1 – Made Easy with Examples

Attributes are one of the core components of TM1. They allow you to describe and categorise elements, use alternate descriptions or IDs and to build virtual hierarchies and dimensions.

How to use TM1 Attributes in Report Studio

TM1 best practice guides recommend using codes for creating hierarchies and using names as aliases. With TM1 it…

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement