Feeders evaluation

[ultrakocka]

Hi All,
we've had problem with time taking server to start, most time consumed by processing feeders in one cube. Colleague updated most rules in the cube in this fashion:

Code: Select all

['item':'cost_per_unit']=>['item':'total_cost'];

->

Code: Select all

['fiscal_year':{'2020','2021','2022'},'item':'cost_per_unit']=>['item':'total_cost'];

and the start-up time got to almost half. Fiscal_year is a dimension with elements 2000 to 2030. But there are data ONLY for 2020,2021,2022, so no more feeders are actually set compared to previous state. I would never expect this, but in retrospect can make sense. Has anyone encountered this? Should all feeders (in large cubes) be written as specifically as possible even though nothing is fed because of 0 values? I'm confused.

Thanks for opinions!

[Elessar]

Hi,

Your "zero" years can be overfed by a feeder like

Code: Select all

['Something'] => ['fiscal_year':'Total years']

and feed further other zero cells.

And seriously, this "=>['item':'total_cost'];" feeder would confuse me more than your question.

[MarenC]

Should all feeders (in large cubes) be written as specifically as possible even though nothing is fed because of 0 values?

I would hope not or that would incur some extra admin resource if feeders needed to be updated, for example to account for a new years data!

[gtonkin]

Why not create a rollup of relevant years and reference that on the left?
Children (Leaf elements) of that rollup are then used to feed to the right.

[ultrakocka]

My question is why given cube like this (with more dimensions, large cube, just simplest slice for reference)

Capture.PNG (7.83 KiB) Viewed 1099 times

feeder

Code: Select all

['item':'cost_per_unit']=>['item':'total_cost'];

should take longer to process than

Code: Select all

['fiscal_year':{'2020','2021','2022'},'item':'cost_per_unit']=>['item':'total_cost'];

or as gtonking and MarenC (Thanks!) pointed out, better would be this, to reduce maintenance overhead:

Code: Select all

['fiscal_year':'C_planning_years','item':'cost_per_unit']=>['item':'total_cost'];

Why does it take longer given the other years 2015-2019 are empty? Hope this makes sense.

Thanks!

[MarenC]

I think Elessar was asking the question, is 'item':'total_cost' a consolidated element?

[ultrakocka]

I think Elessar was asking the question, is 'item':'total_cost' a consolidated element?

My bad, no it is not it's just total_cost=cost_per_unit * quantity. N level elements.

[MarenC]

If you change to feed from Quantity, instead of cost_per_unit, do you get the same problem?

[ultrakocka]

Yep, it's the same.