Page 1 of 1
TM1 hierarchy limit
Posted: Fri Jul 04, 2014 4:18 am
by 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.
Re: TM1 hierarchy limit
Posted: Fri Jul 04, 2014 4:37 am
by 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.
Re: TM1 hierarchy limit
Posted: Fri Jul 04, 2014 6:59 am
by hyunjia
True , and I totally agree the advise . But knowing that limitation is also a great selling point in PPT too
Re: TM1 hierarchy limit
Posted: Tue Jul 08, 2014 7:23 am
by 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);
Re: TM1 hierarchy limit
Posted: Tue Jul 08, 2014 10:25 am
by Alan Kirk
hyunjia wrote: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.
Re: TM1 hierarchy limit
Posted: Tue Jul 08, 2014 1:38 pm
by 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