Sebset Export

[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

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

[Wim Gielis]

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?

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

[Wim Gielis]

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