TM1 hierarchy limit

[hyunjia]

Hi Gurus

Has anyone reach or happen to know the limit of TM1 dimension hierarchy ? Just curious to see if this would become an issue in the future. Take below hierarchy for example :

----Jul 2014 beginning TD
----------Jun 2014 beginning TD
----------Jul 2014

This is a hypothetical structure only, in practical sense , we will have a closing balance for each year.

[EvgenyT]

Theoretical limit for dimension is 2 billion elements, I guess hierarchy limit would be bound within this rule.
I have never reached a theoretical maximum nor I think it would be acceptable from performance perspective. I guess once you start hitting more than 10 levels I think it's time to review your design and assumptions.

[hyunjia]

True , and I totally agree the advise . But knowing that limitation is also a great selling point in PPT too

[yyi]

You could try this if you're game

Code: Select all

# \\\\\\\\\\\\\\\\\\\\\\\\\\\\\
# Process1
# \\\\\\\\\\\\\\\\\\\\\\\\\\\\\
# Prolog
DimName='Two_Billion';
If (DimensionExists(DimName) = 0);
	DimensionCreate(DimName);
else;
	DimensionDeleteAllElements(DimName);
EndIf;
if (dimix(DimName, 'Total')=0);
	DimensionElementInsert(DimName, '', 'Total', 'c');
endif;


# Epilog
pElStart = 1;
While (pElStart <= 2000000000);
	executeprocess('zTemp_Process2', 'pElStart', pElStart);
	pElStart = pElStart + 1000000;
End;



# \\\\\\\\\\\\\\\\\\\\\\\\\\\\\
# Process2
# \\\\\\\\\\\\\\\\\\\\\\\\\\\\\
# Parameters
pElStart, Numeric

# Prolog
cProcess = getprocessname( );
fPath = '\\svrname\logs\tmp\';
fName = fPath | cProcess | '.txt';

pElEnd = pElStart + 1000000;
While (pElStart < pElEnd);
	elName = NumberToString(pElStart);
	DimensionElementInsert('Two_Billion', '', elName, 'n');
	DimensionElementComponentAdd('Two_Billion', 'Total', elName, 1);
	pElStart = pElStart + 1;
End;
asciioutput(fName, 'Element count:= ' | elName);

[Alan Kirk]

True , and I totally agree the advise . But knowing that limitation is also a great selling point in PPT too

Then just punch it into the Powerpoint as "2 billion".

Any pointy haired boss who is too thick to see that a 2 billion level hierarchy is an incredibly stupid design will be suitably impressed. and will never be able to generate a real world example to disprove the bullet point.

Much like Wikipedia entries, there's no harm in making stuff up... only if there's a chance that you'll get caught making it up.

[yyi]

Much like Wikipedia entries, there's no harm in making stuff up... only if there's a chance that you'll get caught making it up.

If it's on the internet, then it must be true ?

right boss, back on the case