TM1 Forum

Hi Alan, This is the code as it stands, which does what I want it to do. Moving the Count = Count + 1 up just puts the last element in the list into the subset. I have put + 1 on the end of Top = SUBSETGETSIZE ( ' Dim ', ' Sub ' ), because without it the last element in the list is added twice into ...

Moving up count = count + 1 : top=SubsetGetSize('Dim', 'Sub'); count=1; SubElemExists=0; while(count<top); count=count+1; if(SubsetGetElementName('Dim', 'Sub', count)@=soughtElement); SubElemExists=1; endif; end; # If element wasn't found in the subset already, then add it in&#46; if(SubElemExis...

Nearly there . . . .

Count = 1, instead of Count = 0, but the last element in my list is entered into the subset twice, any ideas why?

TIA
Matt

Thanks Martin,

Whereabouts in the code should I put the SUBSETELEMENTINSERT function?

Cheers,
Matt

Hi all,

Is there such a TI function as SUBSETELEMENTEXISTS or similar. I've checked the help files and can't find anything.

Is there a way round this in TI, without using DIMIX?

Cheers,
Matt

Hi, Yes there is. In subset editor, find the element that you wish to find out what parent it rolls up into, then select the keep option (green tick). Then highlight the element by clicking on its name, and then click on the roll up option, which looks like 4 circles ( 1 red, 3 white ) in a diagonal...