TM1 Forum

I am trying to filter large number of elements at once for example filter by wildcards *102,103,104.....115* but it is giving me an error.Is any workaround for this?Please help.Thanks
,

1. what error?
2. Are you using the subset editor to filter?
3. For large number of filtering, better to use MDX function in a proccess to filter.

Actually I am working on security setup and quite often i need to test 15-20 accounts against the individual user in subset.Writing TI for each time not feasible for me in this particular scenario.Thanks

*102,103,104.....115*

are those your selected account no?
if it is just 15-20 acount no for testing at once, why not put them into excel and copy/paste them into your subset editor?

Thanks for your reply,This was just an example,these are different accounts under different parent nodes and it is quite a large number.So each time i have to do filter by wildcard search to each time,Appreciate your help.

TM1ethusiast wrote:I am trying to filter large number of elements at once for example filter by wildcards *102,103,104.....115* but it is giving me an error.Is any workaround for this?Please help.Thanks
,

Workaround for what? The fact that you don't know how the wildcard search works? What EXACTLY are you trying to do? What you typed in above makes no sense for any wildcard search in any tool I've ever used. It looks like you are trying to do something similar to the IN function in SQL. Is that what you were trying to do? Macsir gave you an excellent suggestion. If you have the nodes you want to include (the ones you included in your version of the wildcard) then you can easily make a subset out of them by cutting and pasting them into the subset editor. That's what i would do. The other option would be to create an attribute to do an MDX filter on. Then you can just turn on or off the attribute at will for each element you want and the subset will update automatically.