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

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

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

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

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

US is now part of the Subset:

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

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:

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

[dimension name].[element]

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