Subset Editor: selecting elements faster

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

Subset Editor: selecting elements faster

Post by Wim Gielis »

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
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply