TM1 Forum

http://publib.boulder.ibm.com/infocente ... 8022C.html

Cube1 : Purchase

Cube2 : Inventory

Purchase.rux
Feeders:
['Total Markets','Price/Kg - USD']=>DB('Inventory',!fishtype,!date,'1','Purchase
Cost');


The issue I am facing is there are times where Inventory cube will no longer get feeded and when I open the inventory cube, there isnt any value. I have to reopen the Purchase.rux and make some changes to it and resave the file then only the data will gets feed into the Inventory cube again.

has any one faces such issue before ?

is there any reason why ppl choose the above approach instead of putting the following on the Inventory rules ?

['1','Purchase Cost'] = N:DB('Purchase',!FishType,'Total Markets',!Date,'Price/Kg
- USD')

SkipCheck and Feeders work in tandem. You can have a rule without a feeder if you don't use skipcheck, but if you use skipcheck then you must have both a rule and a feeder.

A feeder by itself will not produce any calculation results.

Click here for more info on feeders: http://wiki.tm1forum.com/index.php/TM1_Feeders

Martin

so that means in order for feeders and skipcheck to works, it willl have to be

Cube1 : Purchase

Cube2 : Inventory

Purchase.rux
Feeders;
['Total Markets','Price/Kg - USD']=>DB('Inventory',!fishtype,!date,'1','Purchase Cost');

Inventory.rux
skipcheck;
['1','Purchase Cost'] = N:DB('Purchase',!FishType,'Total Markets',!Date,'Price/Kg - USD');



If i am not using the above approach, will the following works ?

Inventory.rux

skipcheck;
['1','Purchase Cost'] = N:DB('Purchase',!FishType,'Total Markets',!Date,'Price/Kg - USD');

Feeders;
['Total Markets','Price/Kg - USD']=>['1','Purchase Cost'];

winsonlee wrote:so that means in order for feeders and skipcheck to works, it willl have to be

Cube1 : Purchase

Cube2 : Inventory

Purchase.rux
Feeders;
['Total Markets','Price/Kg - USD']=>DB('Inventory',!fishtype,!date,'1','Purchase Cost');

Inventory.rux
skipcheck;
['1','Purchase Cost'] = N:DB('Purchase',!FishType,'Total Markets',!Date,'Price/Kg - USD');

Yes.

winsonlee wrote: If i am not using the above approach, will the following works ?

Inventory.rux

skipcheck;
['1','Purchase Cost'] = N:DB('Purchase',!FishType,'Total Markets',!Date,'Price/Kg - USD');

Feeders;
['Total Markets','Price/Kg - USD']=>['1','Purchase Cost'];

No. There's no value in the Price/Kg-USD field in inventory cube (correct me if I'm wrong) so nothing will get fed.

How feeders work: When the feeders are fired the system goes through the cells defined on the left hand side of the feeder statement. Where it finds a non-zero value it puts a flag on the right hand side of the feeder statement, indicating that it needs to be calculated. So if the left side of your feeder cube will yield only zeroes, then you will get no feeder flags.

When it comes to do the calculation the system whips through looking for feeder flags and calculates only these cells (oversimplifcation, read herefor a lot of detail) ignoring all cells that don't have a feeder flag.

Martin

thanks martin, you have explain it very clear. I might have given many scenario. But just wanted to get my understanding right to see what is possible and what is not.


Will the following work ? will it be the case on the left side it has to be physical value or I can use a reference value in feeders as well ? from the example i saw, the left side is always a physical value and if there is value, flag the right side. If the left side is a reference value from another cube, will it be able to flag the right side ?

GL Cube

SkipCheck;
['Quantity'] = N: DB('HR', !Month, !Year, 'All Staff', !Department, 'Quantity');
['Price'] = N: DB('HR', !Month, !Year, 'All Staff', !Department, 'Price');
['Sales Value'] = ['Quantity'] * ['Price'];

Feeders;

['Quantity''] => ['Sales Value'];

If you would spend the time you are wasting asking questions in this forum reading the TM1 Rules Guide you would be far more productive enhancing your TM1 knowledge. Answers that are spoon fed, rather than researched in the documentation, are too easily forgotten.

I have read through the documentation Rules Guide provided by IBM awhile ago. But i find the answer i get from the expert is much easier to understand then what i find in the IBM website. Therefore i posted the IBM link in my first post asking the doubt I have in relation to the information I read on the documentation. Not unless from your point of view, trial an error is the way to go, then i wouldnt ask any further and create a dummy cube and try it out.

but of course i would appreciate if from the glance of the rules someone can just tell if it is possible.

Martin Ryan wrote:So if the left side of your feeder cube will yield only zeroes, then you will get no feeder flags.

Just to flag this as yet another oversimplification (however, convenient when introducing the concept of feeders) - the left hand side is not checked for non-zero cells, it's checked for fed cells. It is a techicality and often makes a minimal practical difference, but to be entirely accurate, if you have a zero cell that is fed, it will also trigger a feeder on the right hand side.