Automated Subset Maintenance 9.5.2

[rfielden]

I am going round and round with no working on how to automatically update a subset within our cost center region.

Requirements:
All Locations (c)
Division (c)
Region (c)
District (c)
Location (n)

I have written sql script to pull information out of ERP system where it is maintained. If maintained within a unique dimension, I have no problems deleting and recreating. My intent is to create and maintain this hierarchy within our current cost center dimension. I have played with the Subset functions and MDX and just not getting it right.

Can someone possibly provide me with the basic guidelines/functions/tools I should be following to make this work correctly?

Maybe one day I will get off this novice plateau. Anybody willing to mentor!

[tomok]

Well, I think you are actually talking about a hierarchy, not a subset. You need to create a TI process to build/maintain this hierarchy in the Cost Center dimension. This is pretty standard out of the box functionality in TM1 and is covered in the documentation.

[rfielden]

Tomak, when I created TI process (ODBC) to create hierarchy it creates additional sub-consolidation elements with the same children. This would cause the rollup to double up.

For example:
Region 1
--- District 1
------Loc 10
------Loc 11
------Loc 12
--- 1
------10
------11
------12

[tomok]

Tomak, when I created TI process (ODBC) to create hierarchy it creates additional sub-consolidation elements with the same children. This would cause the rollup to double up.

Then this means you either 1) didn't configure the TI process correctly, and/or 2) the data source you are building the dimension build from has conflicting data in it.

[rfielden]

During original testing, I created a unique cost center dimension to run the TI process against. The hierarchy was created successfully with no duplications. When running against the production clone of our cost center dimension is when I get replicate data. Where could I look to discover source of these entries into the hierarchy?

What are the pros/cons between a hierarchy and creating as a subset? I thought it might be 'cleaner' to just delete/destroy a subset and rebuild but guess that is a rookie mistake.

[rfielden]

Also, the DimensionDeleteAllElements is not working in the test dimension.

[rfielden]

In my 'isolated' dimension the pieces all work with: 1) a TI process to delete all elements and (2) epilog that fires off a second TI process to build hierarchy.

My open questions are why is process against the base cost center dimension creating/adding additional elements and how do I delete/change that hierarchy as there are many other hierarchies and subsets associated with this dimension.

[rfielden]

Thank you to all those helped me overcome struggles! I found the answer here on this forum after a little search and seek:

DimName = 'CstCtrs';

eCnt = DIMSIZ(DimName);

x = eCnt;

WHILE( x >= 1);

ElName = DIMNM( DimName,x);

IF( DTYPE( DimName,ElName) @= 'C');
IF (ATTRS(DimName,ElName,'All Level Parent') @= 'SH');
DimensionElementDelete( DimName,ElName);
ENDIF;
ENDIF;

x = x -1;

END;