TM1 Forum

Hi Experts,

Need some explanation or better solution if there is.

I have a cube named Report sourcing from another cube REVENUE. This Report cube has Period Week dimension in which the lowest levels are the week elements. While the REVENUE dimension has the months as its lowest level elements.

In my rule below, I'm passing the value of the whole consolidated quarter revenue for each week element.


REPORT Cube

['Quarter Revenue']=N:DB('Revenue',ATTRS('Reference Period',!Period Week,'Quarter'),!Site,'Revenue');


But in my feeders, I feed the Quarter Revenue measure this way. AND IT DOES WORK.

But isn't the week elements that I should be feeding? In my case below, I'm feeding the Consolidated months.

The way the cube behaves is fine but is it the proper way to do this feeding?


REVENUE Cube

['Revenue']=>DB('Report',ATTRS('Reference Month',!Period Month,'First Qtr CoMember'),!Site,'Quarter Revenue');

['Revenue']=>DB('Report',ATTRS('Reference Month',!Period Month,'Second Qtr CoMember'),!Site,'Quarter Revenue');

['Revenue']=>DB('Report',!Period Month,!Site,'Quarter Revenue');


Thanks very much for your help.

Bunch

what is comember?

seems to be right way to feed as i think, i use the same way for ex in ...regions/cities/streets...

Hi Ioscat,

CoMem is the month's co-members in the quarter. For example, January's co-members in Q1 are February and March. Same goes with May, its co-members are April and Jun.

It does work, but I'm confused because in the feeder, I'm pointing to these months, where in fact the elements that are calculated in the Report cube are the week elements.

Thanks.

Sorry I think my attibute name causes confusion. It should be Qtr first comem and Qtr second comem.

bunchukokoy wrote:It does work, but I'm confused because in the feeder, I'm pointing to these months, where in fact the elements that are calculated in the Report cube are the week elements.

Feeding a consolidated node is equivalent to writing separate feeders for each of the children of that node.

I see. Thanks for the explanation Tomok.

Hi,

Forgive me guys. I just want to have a confirmation.

Feeding a consolidated node is equivalent to writing separate feeders for each of the children of that node.

Does it also feed the grand children of that node? Up to the leaves?

Feeders are implicitly a LEAF concept. What Tomok said was a shortcut of expression, it would have been more accurate to say

Feeding a consolidated node is equivalent to writing separate feeders to all ultimate leaf descendants of that consolidated node.

It is important to understand that only leaf cells are fed, intermediate consolidations are NOT FED. When consolidations are referred to in feeders it is only as a shortcut to mean all leaf descendants of the consolidation.

Very well explained Sir.

Thanks very much.