Page 1 of 1
C: rule and next consolidation level
Posted: Thu Jul 03, 2014 12:15 pm
by EP_explorer
Example from Sdata
- 01.JPG (32.74 KiB) Viewed 4569 times
And only rule
Code: Select all
SKIPCHECK;
['1 Quarter' ] = C: 5 ;
I need that
1 Quarter wil be added to the
Year. Is possible to do it (after I put C: rule to
1 Quarter)?
We see that TM1 consolidated to Year only Feb detail value and ignored rule based 1 Quarter value
Or TM1 use only detail elements for consolidation and ignore C: level intermediate elements?
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 12:57 pm
by jim wood
In the refernce guide you'll find:
Code: Select all
ConsolidateChildren(DimName1, DimName2, ...)
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 1:07 pm
by BariAbdul
EP_explorer wrote:Example from Sdata
01.JPG
And only rule
Code: Select all
SKIPCHECK;
['1 Quarter' ] = C: 5 ;
I need that
1 Quarter wil be added to the
Year. Is possible to do it (after I put C: rule to
1 Quarter)?
We see that TM1 consolidated to Year only Feb detail value and ignored rule based 1 Quarter value
Or TM1 use only detail elements for consolidation and ignore C: level intermediate elements?
Ok.But doesn't it give incorrect totals and what is the need to add subtotals to the totals.Sorry for not getting it.Thanks
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 1:18 pm
by David Usherwood
Since you want (for reasons I do not follow) to interfere with the natural consolidation calculation, you need to consolidate year explicitly ie
Code: Select all
['Year'] = consolidatechildren('Month');
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 1:33 pm
by EP_explorer
Thank you for anwer.
it helps
although it neccessary to add all intermediate consoliadtion elements in hierarchy.
For the same example if we want to sum through region hiearachy
- 2.JPG (49.02 KiB) Viewed 4540 times
It is neccessary to add in ConsolidatedChildren both 'World' and 'Europe'
Code: Select all
SKIPCHECK;
['Scandinavia' ] = C: 18 ;
[{'World','Europe'} ] = ConsolidateChildren('region');
if we add only Europe we will see correct value in Europe but incorrect in World
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 1:38 pm
by BariAbdul
Sorry ,I am still at loss,Doesn't Europe value added naturally to world by TM1 natural consolidations.
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 1:46 pm
by EP_explorer
BariAbdul wrote:Sorry ,I am still at loss,Doesn't Europe value added naturally to world by TM1 natural consolidations.
I would be better if it does
but consolidatechildren function sums only children of the element which you put before it.
Re: C: rule and next consolidation level
Posted: Thu Jul 03, 2014 5:09 pm
by tomok
When you have a nested consolidation, like what you have with World, then each underlying consolidation is treated as a separate entity. What that means is that World looks at all the N level elements underneath it and sums them according to their weights, it does not calculate Europe and America and then add them to get World. This is why modifying Europe, so that it is not what the natural consolidation would make it, will not carry forward to World.