Page 1 of 1

Problem with TM1 Feeders in destination cube

Posted: Thu Nov 18, 2010 4:22 pm
by busdee
Hi All,
I need some help here with the feeders. I got the destination cube which is P&L cube pulling data from the source cube which is Revenue cube. The P&L cube has skipcheck and feeders in the rule and feed back to Revenue cube. In the Revenue cube it's pulled data from other cubes such as Price and Sales Volume but I didn't write skipcheck and feeders for Revenue cube rule, just only feeders of P&L cube in Revenue cube.
Here is sample situation

Price, Volume(no skipcheck and feeders) ---> Revenue (no skipcheck, feeders only for P&L) ----> P&L (skipcheck and feeders)

The consolidated value in P&L cube doesn't work properly, it's zero and show 'not fed' when check feeders. Since I'm quite sure that the feeders between P&L and Revenue cube is already correct because the rule is pretty simple, just db from Revenue.
So I wonder that "Do we need also need to write the feeders for Revenue Rules which is middle cube???" Now the consolidated value that db to P&L in Revenue Cube works fine because I didn't put the skipcheck for this cube. I try to avoide feeders in the revenue cube since after I try feeding in the revenue and its source cube, it consumes a lot of memory and server keeping slower and slower.

Please give me some Advice

Thanks :)

Re: Problem with TM1 Feeders in destination cube

Posted: Thu Nov 18, 2010 5:02 pm
by tomok
Are you aware that when you have intercube rules the feeder statement goes in the cube where the data you are using to feed is stored? What is the driving factor that would cause your revenue GL account(s) to have a value? Isn't it volume? If that is the case then you should feed from the Price/Volume cube, assuming it has a logical dimensionality connection with the P&L cube, meaning you've got volume by GL account or your products roll up to GL accounts or some other way of making the connection. If not, then you may need to rethink your design.

Re: Problem with TM1 Feeders in destination cube

Posted: Thu Nov 18, 2010 11:52 pm
by olapuser
Yes, you need to write feeders statement on both side or you may have a TI that transfer data to P&L