TM1 Forum

Hello Friends,
I need to see the list of all private subsets of a dimension. Please help me to know if there is any control object which show us the private subsets of dimension.
My requirement is that I need to list the private subsets of a given dimension in excel workbook. If there is no direct way, can someone please suggest a workaround?

Thanks,
Pavan

I do not think TM1 stores private subsets and views in a control cube - it won't be "private" then

However, if i am not mistaken, all views and subsets are stored on the server in the sdata folder in its own folder. private subset are usually stored under the user's folder in sdata so lets say you are userA have a dimension called dimA and you create a private subset called subA and a public subset called subB. You will find on the server subA.sub in a folder called "dimA}subs" and you will find subB.sub in a folder called "userA\dimA}subs".

Knowing this you probably can concoct some type of program that can scan these directories for a "dimX}sub" and retrieve the subsets.

Hope this helps.

Hi Pavan,You have to search through the data directory for .sub folder by using wildcardsearch function.Thanks