Page 1 of 1
Sebset Export
Posted: Fri Mar 21, 2014 10:00 pm
by ravi
Hi All,
Need a suggestion- we are on 952 version of tm1. We need export list of subset's building under Dimension under tm1 model.
Please help to suggest work around or is it need to done through IT process?
I understand it possible only 10.1 version - please advise.
http://www.ibm.com/developerworks/data/ ... ge625.html
Regards,
Ravi
Re: Sebset Export
Posted: Fri Mar 21, 2014 11:10 pm
by declanr
Ravi,
You just need to look under the correct directory, the following code will give you a list of the public subsets, you can expand the code to find private subsets by cycling through the }clients dimension on top of it also if required.
Code: Select all
sSubsetDirectory = sDataPath | pDimName | '}subs\*';
sSubNameFull = WildCardFileSearch ( sSubsetDirectory, '' );
While ( sSubNameFull @<> '' );
sSubName = Subst ( sSubNameFull, 1, Scan ( '.sub', sSubNameFull ) - 1 );
AsciiOutput ( sOutputFile, sSubName );
sSubNameFull = WildCardFileSearch ( sSubsetDirectory, sSubNameFull );
End;
You need to define:
sDataPath - The data directory.
sOutputFile - Details of where you will output the data to.
pDimName - Create a parameter to put in the name of your dimension; if you wish to do it for all dims just do a loop on the }dimensions dim instead.
Re: Sebset Export
Posted: Sun Mar 23, 2014 9:12 am
by Wim Gielis
ravi wrote:I understand it possible only 10.1 version - please advise.
What is this idea based off? Why do you think it would only work in 10.1?
Re: Sebset Export
Posted: Sun Mar 23, 2014 9:16 am
by declanr
I hadn't actually opened the link until Wim's comment and had assumed that the link referred to the new thing in performance modeler where you can get an export view of everything in your system; cubes, dims, rules etc.
Looking at it; it obviously did exactly the same I would but to be fair to the OP it does say at the top of the page applicability is "10.1 onwards".... however I am guessing that is just due to the pointless "bring it into insight to see how flashy our new tools are" part at the bottom.
Re: Sebset Export
Posted: Sun Mar 23, 2014 8:47 pm
by Wim Gielis
declanr wrote:I hadn't actually opened the link until Wim's comment and had assumed that the link referred to the new thing in performance modeler where you can get an export view of everything in your system; cubes, dims, rules etc.
Looking at it; it obviously did exactly the same I would but to be fair to the OP it does say at the top of the page applicability is "10.1 onwards".... however I am guessing that is just due to the pointless "bring it into insight to see how flashy our new tools are" part at the bottom.
I think the same way Declan
