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
Do you have slow reports with large subsets using MDX? Here’s a best practice guide with screenshots to fix poor performing MDX based subsets.
Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.
To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.
In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked and underused. In this article, I’m going to explain Custom
For those of us still using earlier versions of TM1 where Active Forms are not available, below is a set of VBA code that would enable you to recreate the
Here we explain how to use the Swap AliasWithPrincipalName function in TM1 to swap the contents of an alias with the primary ID’s of a dimension.
We sometimes get asked what are the three most important things to remember in TM1 development to make a TM1 model work well in the long term. Well, here is
There are four ways to maintain a dimension within TM1: Most consultants previously recommended using Dimension and Rule Worksheets prior to TM1 9.1 where the User Interface has been updated,
Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public Subsets, Processes, Chores and Applications are all named on creation. All too
Dimension Worksheets are a great way to manage medium sized dimensions and attributes/aliases. All Worksheets (Dimension and Rule) are held in the local data directory set in the ‘Options’ form
There are a few ways to update a dimension within TM1, the first is the simplest and most commonly used. To update a Dimension using the Dimension Editor: Right Click
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
