TM1 Forum

Posted: **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

SC029::
{
   IfWinActive, ahk_class AfxFrameOrView100u
   {
      Send ^k
      Send ^k
      ControlGetText, Clipboard, RichEdit20W1, A
      ControlClick, ListBox1, A,,,NA
      Send ^v
      ControlClick, Button1, A,,,NA
      Return
   }
}

Please refer to: https://www.wimgielis.com/tm1_ahkpickel ... tor_EN.htm

Best regards,

Wim

TM1 Forum

Subset Editor: selecting elements faster

Subset Editor: selecting elements faster