CosolidateChildren error

[Mems]

Hey All,

I am using tm1 v9.5.2 FP2, but have replicated the issue on tm1 v9.5.1 ans Express v9.5.

The rule I am using is

['Weighted Formula Calc Inners'] =
IF(ELLEV('Item',!Item)<>0,
ConsolidateChildren('Item'),
['Inner Case Cost']*['Inner Case']);

The problem being, the cube runs at about 1GB and when I open cube viewer and specifically ['Weighted Formula Calc Inners'] the server (24GB) runs out of memory.

I have also tried writing it in different ways...


['Weighted Formula Calc Inners'] =
IF(ELLEV('Item',!Item)=0,
['Inner Case Cost']*['Inner Case'],
ConsolidateChildren('Item');


['Weighted Formula Calc Inners' ] =N:['Inner Case Cost']*['Inner Cases'];
['Weighted Formula Calc']=C:
ConsolidateChildren('Item');

Thinking that it might have something to do with a circular ref of sort.

Any ideas?

Admin note: moved from the bugs forum as it's not yet a proved bug.

[David Usherwood]

Are you using feeders? You need to, then you can drop ConsolidateChildren. CC has its uses but can be very memory hungry.

[Mems]

David,

I broke it down to just one cube to fix the error.

The one extra rule.

['Inner Case Cost' ]=['Activity Cost']\['Inner Case']

Feeders;

['Inner Case' ]=>['Inner Case Cost' ] ;
['Inner Case' ] => ['Weighted Formula Calc Inners' ];
['Inner Case' ]=> ['Weighted Inner Case Cost' ];

The cube has 6 dimensions. Really small cube. Without the CC if I expand all elements the cube runs at 1GB. With CC server crashes.

Thanks,

[Duncan P]

So do you have a satisfactory solution not using ConsolidateChildren? I couldn't quite make out from your post if your problem was resolved.

[David Usherwood]

If you are doing weighted averages you need to roll them up:

Code: Select all

['Weighted Formula Calc Inners'] = n:
  ['Inner Case Cost']*['Inner Case']
  ;

[Mems]

Hey,

Nope I believe I have to use ConsolidateChildren

https://docs.google.com/a/venncubed.co. ... li=1#gid=0

Please see URL

I want to get the 2.39.

My calcs are as follow

Code: Select all

Skipcheck;

['Case Cost' ]=['Total Activity Cost']\['Cases']

['Weighted Formula Calc'] =
IF(ELLEV('Item',!Item)<>0,
ConsolidateChildren('Item'),
['Case Cost']*['Cases']);

Feeders;

['Cases' ]=>['Case Cost' ] ;
['Cases' ] => ['Weighted Formula Calc' ];
['Cases' ]=> ['Weighted Case Cost' ];

[Mems]

Apologies,

[Mems]

Any feedback, regarding alternative ways except consolidatechildren to calculate?

[declanr]

Hey,

Nope I believe I have to use ConsolidateChildren

https://docs.google.com/a/venncubed.co. ... li=1#gid=0

Please see URL

I want to get the 2.39.

My calcs are as follow

Code: Select all

Skipcheck;

['Case Cost' ]=['Total Activity Cost']\['Cases']

['Weighted Formula Calc'] =
IF(ELLEV('Item',!Item)<>0,
ConsolidateChildren('Item'),
['Case Cost']*['Cases']);

Feeders;

['Cases' ]=>['Case Cost' ] ;
['Cases' ] => ['Weighted Formula Calc' ];
['Cases' ]=> ['Weighted Case Cost' ];

Having had a look at your excel example (if I followed it correctly) I think you could solve your problem by simply using an =N: as below:

Code: Select all

Skipcheck;

['Case Cost' ]=['Total Activity Cost']\['Cases']

['Weighted Formula Calc'] =N:
['Case Cost']*['Cases'];

['Weighted Case Cost']=
['Weighted Formula Calc'] \ ['Cases'];

Feeders;

['Cases' ]=>['Case Cost' ] ;
['Cases' ] => ['Weighted Formula Calc' ];
['Cases' ]=> ['Weighted Case Cost' ];

Or have I missed something really obvious, because the above code would be the equivalent of changing cell E2 in your example to be SUM(E3:E10) which would sebsequently change F2 to equal 2.39...

[Mems]

Hahahaha, ok I should get a new job thanks! My apologies for wasting time.