how to create Dynamic subset for Only Elements starting with

[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?

[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.

[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.