Exploring TM1 - a Chartertech Company
Search
Close this search box.

Dimensions in TM1

Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes to hold data. What are Dimensions? Dimensions in TM1 are just structured lists of elements (or sometimes known as members). So a list of product, months, customers, measures, years, accounts, cost centres, WBS codes, versions, […]

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.

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.

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 is also very common to work with various other attributes. But when you create a package with framework manager you can choose what alias you want to show in reports. So you normally use the name as […]

Log In