Have you tried to create a TM1 dynamic subset with dimensional data?

TM1 dynamic subset with dimensional data allows you to choose a consolidated item in your list. Then when the list is updated the TM1 dynamic subset with the dimensional data should automatically be updated. But, in my experience, it doesn't always work as planned. Instead, you choose a specific consolidated item and the next time the dimension data is updated, the TM1 dynamic subset with dimensional data takes on a mind of its own. So, you recreate it again. Been there, done that – right? Try the following:

Creating TM1 Dynamic Subset with Dimensional Data

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

​

​

2. Record the Expression (saves some manual keystrokes)
a. Tools Record Expression

​

​

3. Select the Consolidated Element/Parent

​

​

4. Click Keep

​

​

5. [Optionally] Click Expands all Elements

​

​

6. Stop Recording
a. Tools Stop Recording

​

​

7. Click Yes to attach the expression to the subset. Attaching the expression creates a dynamic subset and new child elements will be included in the subset.

​

​

8. Replace the TM1SubsetBasis() function with the name of the Consolidated Element

​

​

9. Click Update

​

​

10. Save the Subset
a. Ensure Save Expression is selected

​

​

Yes it's that easy to create a TM1 Dynamic Subset with Dimensional Data. Hopefully this technique will save you a lot of time and headaches. At Lodestar Solutions our consultants and coaches teach you time saving tips. We empower you to deliver Faster, Cheaper Analytics. If you like our tips, consider joining our Lodestar Club to get access to our members only library of education videos. If you would like additional help on your TM1 project please contact us at Services@lodestarsolutions.com.

See Part 1 of our TM1 - Creating a TM1 Dynamic Subset