TM1 Dynamic Subset with Dimensional Data

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

TM1 Dynamic Subset with dimensional data

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

TM1 Dynamic Subset with dimensional data

3. Select the Consolidated Element/Parent

TM1 Dynamic Subsets

4. Click Keep

TM1 Dynamic Subset with dimensional data

5. [Optionally] Click Expands all Elements

TM1 Dynamic Subset with dimensional data

6. Stop Recording
a. Tools Stop Recording

TM1 Dynamic Subset with dimensional data

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.

TM1 Dynamic Subset with dimensional data

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

TM1 Dynamic Subset with dimensional data

9. Click Update

TM1 Dynamic Subset with dimensional data

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

TM1 Dynamic Subset with dimensional data

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

HERE

Leave a Comment

X
Send this to a friend