How to make multiple selection easier?

Post Reply
initm1
Posts: 32
Joined: Mon Jul 20, 2015 7:19 am
OLAP Product: Microsoft
Version: 10.2
Excel Version: OFFICE365

How to make multiple selection easier?

Post by initm1 »

Hi, I am new to tm1 and when creating subsets sometime i need to select multiple elements from dimension to form a static subset, however selecting 100+ odd elements is painful...is there any easier way to make this selection easier? Or automated way like ti process or functions or mdx expression that i can write to include this elements?

Thanks in advance. Hope my question is clear.
I use tm1 Prespectives. Win7.
TM1.Prespectives.Win7.Office365,Excel2016,Excel2010
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to make multiple selection easier?

Post by Wim Gielis »

Hello,

Copy/paste from tools like Excel or Notepad is possible in the Subset editor. Of course you can use TI and MDX, for example create a dynamic subset with all Elements that match a certain value for an attribute. After that you can also make the subset static if you want.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
initm1
Posts: 32
Joined: Mon Jul 20, 2015 7:19 am
OLAP Product: Microsoft
Version: 10.2
Excel Version: OFFICE365

Re: How to make multiple selection easier?

Post by initm1 »

Hi Will, wow..never knew i could paste anything there just like that. Thanks much. Do I simple use windows ctrl c and ctrl v to achieve this? I'll try later and post back if stucked.
TM1.Prespectives.Win7.Office365,Excel2016,Excel2010
initm1
Posts: 32
Joined: Mon Jul 20, 2015 7:19 am
OLAP Product: Microsoft
Version: 10.2
Excel Version: OFFICE365

Re: How to make multiple selection easier?

Post by initm1 »

Works perfectly okay. thanks again Will.
TM1.Prespectives.Win7.Office365,Excel2016,Excel2010
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to make multiple selection easier?

Post by Wim Gielis »

It's Perspectives instead of Prespectives.
And it's Wim instead of Will.
Thanks.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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