Creating TM1 Dynamic Subset of Individual Elements

Have you ever laboriously scrolling through a dimension in TM1 containing dozens or hundreds of elements. The goal is to select 3 or 4 elements for creating that one of a kind subset. A few minutes of scrolling . . .success. Then you realize you left out one item. And so the scroll and click begins once again. Ick. There's a solution to this by using a TM1 Dynamic Subset. TM1 Dynamic Subset replaces the scroll and click. . .

1. While in the Subset Editor, ensure the Expression Window is visible:
a. View Expression Window

TM1 Dynamic Subset

Let’s assume we want a subset comprised of UK, Germany, Canada, and PacRim

2. Type the Element names in the Expression Window:
a. {[UK],[Germany],[Canada],[PacRim]}

3. Click Update

TM1 Dynamic Subset

The Elements in the Expression Window should be the only Elements visible:

TM1 Dynamic Subset

4. Save the Subset:
a. Ensure Save Expression is selected

TM1 Dynamic Subset

Let’s add the US:
5. Add [US] to the Expression
6. Click Update

TM1 Dynamic Subset

US is now part of the Subset:

TM1 Dynamic Subset

7. After making a modification, ensure you select “Yes” to Overwrite the existing subset definition:

TM1 Dynamic Subset

So, you see it's easy to leverage TM1 Dynamic Subsets.

TM1 DYNAMIC SUBSET POINTS TO PONDER:

The order of the Elements in the subset is based on the order of the elements in the Expression Window:

TM1 Dynamic Subset

If an Element exists in another dimension, preface the Element with the Dimension Name:

[dimension name].[element]

TM1 Dynamic Subset

Hopefully you are already thinking of ways you can leverage a TM1 Dynamic Subset to save time and aggravation. Our Lodestar Solutions' coaches are trained to coach you on many time saving techniques to deliver Faster Cheaper Analytics. If you would like more information on our frameworks and tips, join the Lodestar Solutions Club on our website. Club members get access to a free library of videos and information.

You can see the 2nd of Lodestar's posts on "Creating a TM1 Dynamic Subset" HERE

Leave a Comment

X
Send this to a friend