Subset contains duplicate consolidation member

[tm1dgw]

I'm new to TM1, and am having an odd problem that my co-workers have never seen. When I create a subset for one of my dimensions, a consolidation element is showing up in the wrong location IN ADDITION TO being displayed in the correct location. I've tried recreating the dimension (from a process) and subset several times, but the behavior keeps repeating in the same way. Does anyone have any suggestions to prevent this from happening?

[tomok]

How are you creating the subset, TI or through the subset editor? If it's subset editor then just delete the element from the "wrong" location (whatever that means) and the re-save. If you are doing it via TI then how are you looping through to do the SubsetElementInsert? Perhaps your logic is bad.

[tm1dgw]

I'm using a process, and only inserting the top consolidation level ('Products') plus its 3 colsolidation level children. After the subset is created, the element 'Core' shows up in the proper place AND with the leaf-level elements of 'Non-Core'.

#-------------- SET PARAMETER VALUES --------------------------
pDim = 'GprDimProducts';
pSubset = 'Top Levels';

#------------- DELETE ALL SUBSET ELEMENTS ------------------------------

SubsetDeleteAllElements ( pDim,pSubset ) ;

#--------------- INSERT SUBSET ELEMENTS ----------------------------
SubsetElementInsert(pDim, pSubset, 'Products', 1);
SubsetElementInsert(pDim, pSubset, 'L1 - ( Blank )', 2);
SubsetElementInsert(pDim, pSubset, 'Core', 3);
SubsetElementInsert(pDim, pSubset, 'Non-Core', 4);

[tomok]

I'm not following you as I cannot tell from your explanation exactly what "the proper place" means. You should probably post a screen shot of what you are talking about.

[tm1dgw]

We discovered that the problem was in the data used to build the dimension. There was a leaf-level element data item that contained the same value as a consolidation element data item.

Thanks for trying to help!