Feeder Query

[BigDSter]

Although I've now got over 5 years experience with TM1, building endless cubes and TI's I still have a blind spot for feeders. Just trying to do a simple cube which works with the rules, but as soon as I introduce feeders it goes wrong.

feeder_failure1.jpg (145.28 KiB) Viewed 3730 times

When you run it without the feeders it does what I expect.

feeder_failure2.jpg (139.78 KiB) Viewed 3730 times

The problem appears to be that the 27,287 number isn't being fed. I've tried overfeeding it, by feeding from lots of grandtotals, but this has no effect. I need it to be fed so that I can use its consolidated total as a part of the next rule.

Again as usual I'm probably being stupid, but any help would be appreciated

[Martin Ryan]

Hi David,

vb nb, ,,,,,,,, jm (that was my one year old daughter's contribution, she thinks VB solves everything. Maybe with nb and jm it would)

The short answer to your problem is

['Standing', 'Weight per 1000'] => ['Calc 1', 'Some consolidation in your NSM Period Dim that has all Pxx'];
['Calc1'] => ['Calc2'],['Calc3'];

The long answer is that when you write a feeder (or rule for that matter) the right hand side of the 'transaction' will be the same as the left, unless you tell it otherwise. Even though you have lots of consolidations on the left side of your feeder, all the elements are only feeding themselves, because you haven't specified somewhere different on the right hand side of the feeder.

HTH,
Martin

[BigDSter]

Thanks Martin, works brilliantly.

Say thanks to your daughter too

David