Subset Editor: selecting elements faster

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
Posts: 2792
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL
Excel Version: Microsoft 365
Location: Brussels, Belgium

Subset Editor: selecting elements faster

Post by Wim Gielis » Wed Apr 08, 2020 11:55 pm

Hi all,

Anyone who is often working in TM1 in the Subset Editor (Architect / Perspectives) knows that selecting multiple elements at a time can be a pain.
  • Sure, you can use subsets.
  • Sure, you can use the wildcard search.
  • Sure, you can "Show all" and either keep what you need or delete what you don't.
  • Sure, you can enter your element names in Excel or Notepad and copy/paste to the Subset Editor

This is not very convenient and also not fast enough. So what is the alternative ? You can:
  • show the "Expression Window" if it's not already visible
  • enter your elements there (aliases are allowed)
  • clear the main area of the Subset Editor (choose "Keep" twice, or Ctrl + k twice)
  • copy (or cut) the information from the "Expression Window"
  • and paste the clipboard into the main area above
  • hit OK in the Subset Editor
Here is a short code in AutoHotKey to automate the steps:

Code: Select all

   IfWinActive, ahk_class AfxFrameOrView100u
      Send ^k
      Send ^k
      ControlGetText, Clipboard, RichEdit20W1, A
      ControlClick, ListBox1, A,,,NA
      Send ^v
      ControlClick, Button1, A,,,NA
Please refer to: ... tor_EN.htm

Best regards,

Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 120 TM1 articles and a lot of custom code
Newest blog article: Documenting processes and rules

Post Reply