C: rule and next consolidation level

[EP_explorer]

Example from Sdata

01.JPG (32.74 KiB) Viewed 4560 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?

[jim wood]

In the refernce guide you'll find:

Code: Select all

ConsolidateChildren(DimName1, DimName2, ...)

[BariAbdul]

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

[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');

[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 4531 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

[BariAbdul]

Sorry ,I am still at loss,Doesn't Europe value added naturally to world by TM1 natural consolidations.

[EP_explorer]

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.

[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.