Page 1 of 1
how to create Dynamic subset for Only Elements starting with
Posted: Tue May 13, 2014 3:05 am
by satya.bhamidipati
how to create Dynamic subset for Only Elements starting with alphabets in Tm1?
How to Get total Public View and private View Information ?
How to Get total Public Subset and private subset Information?
Re: how to create Dynamic subset for Only Elements starting
Posted: Tue May 13, 2014 9:07 am
by BariAbdul
Satya,Don't know what you are actually after,Anyway,You can create dynamic subset with whatever alphabets you want to begin with by using MDX a conjuction with Like function,For the second and third queries you have to loop through Data Directory for .vue for public views as well as .sub folders for subset.My apologies if I didn't get your question correctly.
Re: how to create Dynamic subset for Only Elements starting
Posted: Tue May 13, 2014 10:10 am
by Wim Gielis
For the first question, here's an example for an MDX statement:
Code: Select all
{TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [FIN_Account] )}, 0)}, "6????*")}
The other 2 questions, also, make me think (1) you did not use the Search function here and/or (2) you did not use Google and/or (3) your level of TM1 knowledge is not matching the kind of questions you ask.