Detail to Summary Cube - Feeders

[RSK]

Afternoon all

I have a scenario where I have a "Warehouse" cube which contains sales and forecast data down to a pack level for my products. There are a significant number of packs in this dimension and on the whole the cube is fairly chunky and itself data is fed to it by 4 or 5 different cubes.

On that basis I have created a summary cube which replicates the Warehouse cube data but it's product dimension is one level shorter than the other, therefore the lowest level being a level above the pack. All other dimensions are exactly the same.

When when placing the feeder into the rule of the warehouse cube it is now taking over 25 mins to save where before it wouldn't take anywhere near that before I put it in. Am I being thick with the feeder i'm using?

Summary cube rule:

Code: Select all

[]=DB('Sales Warehouse',!Years,!Months,!ProductBrand,!Versions,!Currency Calc,!Sales Warehouse Calcs);

Warehouse Feeder

Code: Select all

[]=>DB('Sales Warehouse Summary',!Years,!Months,'TOTAL',!Versions,!Currency Calc,!Sales Warehouse Calcs);

I think where I am going wrong is specifying the 'TOTAL' element in the DB formula, this is the Summarised product dimension and I imagine this could be handled better? I did try !Products ( The full product hierarchy) but this caused the summary to have unfed cells.

Any thoughts? Many thanks in advance.

[David Usherwood]

There are a number of ways to make this work. My recommendation would be to maintain an attribute against the N level product in the source cube which holds the Product Brand and use this for the feeders. Remember feeders only fire from base level cells.

[RSK]

There are a number of ways to make this work. My recommendation would be to maintain an attribute against the N level product in the source cube which holds the Product Brand and use this for the feeders. Remember feeders only fire from base level cells.

So in that case would the feeder include an ATTRS function of the product dimension Parent value (Brand) and that would replace the 'TOTAL' entry in the feeder?

[RSK]

There are a number of ways to make this work. My recommendation would be to maintain an attribute against the N level product in the source cube which holds the Product Brand and use this for the feeders. Remember feeders only fire from base level cells.

David, just amended this and works swimmingly,

Thanks for your input.