Feeder an Ode why I HATE them!

[Eric]

As always feeders will be the death of me.

Code: Select all

Cube 1 = 2009 HC Expense
  Dim1 = 2009 Budget HC
        Con. Elmt = 80400
             LfElmt = Employee1
             LfElmt = Employee2
  Dim2 = Cost Element
        Con. Elmt = Compensation and Benefits
             LfElmt = 601100
  Dim3 = Month
         Con. Elmt = Year
             LfElmt = 1

Code: Select all

Cube 2 = Operating Expenses
 Dim3 = Cost Element
        Con. Elmt = Compensation and Benefits
             LfElmt = 601100
  Dim2 = Cost Center
        Con. Elmt = 270FR Finance
             LfElmt = 80400   *****Leaf matches Cube1 Dim1 Consolidations  *****
  Dim3 = Year
        Con. Elmt = All Years
             LfElmt = 2009
  Dim3 = Month
        Con. Elmt = Year
             LfElmt = 1
  Dim3 = Scenario
             LfElmt = Actual
             LfElmt = Working Budget
  Dim1 = Company
        Con. Elmt = 10000
             LfElmt = 1000
             LfElmt = 3000
  Dim4 = Currency
             LfElmt = USD
             LfElmt = Local Currency
             LfElmt = CAD
  Dim5 = Measure
             LfElmt = Amount
             LfElmt = Explaination

Rule works perfectly, but I have posted it below

Code: Select all

#BUDGET HC EXPENSES
['601100','2009','Working Budget','1000','USD','Amount']=DB('2009 HC Expenses',!Cost Center,'601100',!Month);

Cube2Rule.png (20.7 KiB) Viewed 5461 times

Cube1.png (23.11 KiB) Viewed 5461 times

Feeder not working. Feeder is in Cube 2

Code: Select all

['601100']=>DB('Operating Expenses',!Cost Element,!2009 Budget HC,'2009',!Month,'Working Budget','1000','USD','Amount');

Cube2Feeder.png (20.8 KiB) Viewed 5461 times

After a bunch of trouble shooting I found out the following.

1) The issue appears to be !2009 Budget HC. If I hard coded it to '80400' the feeder works, but other wise it doesn't.
2) I thought the problem might the feeder flags needed to reset, so I rebooted the server....Still doesn't feed.

God help me if I am missing a comma or if something is misspelled!

[Martin Ryan]

My first guess would be that it doesn't like your dimension name, specifically that it starts with a number. Any chance of changing the dimension to "BudgetHC09" and rebuilding the cube?

Martin

[Eric]

I would really not want to do that, but if that is my only option I do not have a choice. Any other ideas?

[Andy Key]

Well, being from this side of the pond, I would say that it was because your spelling of Cost Centre is wrong...

But seriously...

Is your feeder really in Cube 2 Operating Expenses? Looks like it should be in Cube 1 2009 HC Expense.

Assuming that is a typo, what you want to happen is for HCExp['601100', '80400'] to feed OpEx ['601100', '80400'], where the HCExp 80400 is a consolidation, OpEx 80400 is a leaf.

I think your problem is that feeders only work at the leaf level, so the left hand side of your feeder will never attempt to process 80400, it will only look at {'Employee1', 'Employee2'} feeding OpEx, and as your Cost Center dimension doesn't have elements called Employee1 and Employee2 it won't feed.

Assuming that the 80400 level is always one above Employee1 level, try something along the lines of:

Code: Select all

['601100']=>DB('Operating Expenses',!Cost Element,ElPar('2009 Budget HC, !2009 Budget HC, 1),'2009',!Month,'Working Budget','1000','USD','Amount');

[Eric]

Didn't work at first but then I noticed a ' was missing. Popped that bad boy in and BAM! Thanks!

Is your feeder really in Cube 2 Operating Expenses?

Nope, you were right, typo.

feeders only work at the leaf level

Didn't know that.... or maybe I did and forgot..... Either way I will remember now.

If I use the ELPAR() in the feeder, and the cost centER has 3 employees I am feeding the same cell 3 times when I only need to do it once. Correct? Memory is not an issue right now, but in case I need to optimize I will make a not to start here.

Remind me if we meet at the next Cognos Forum, I owe you a beer. And don't worry I won't make you choke down an American brew.

[Andy Key]

Hmm, not sure, but I don't think memory will be a problem. Yes you end up feeding it three times, but my understanding of how feeders work is as a kind of behind the scenes flag. Almost like a shadow copy of the cube, but populated with flags where cells are fed and therefore need to be calculated. So it populates the same flag three times, but I don't see that the memory used for the flag cube would be bigger than if you just fed it once.

Of course, that might just be how it was explained, and it might actually do it completely differently!

[Eric]

Hmmm.... I am curiuos. I will do some research and get back to you on that one.