AnsweredAssumed Answered

Data flow: How to distribute a value on different entities

Question asked by sandrocarosso on Apr 21, 2019
Latest reply on Apr 24, 2019 by maltenberg@board.com

Hi everyone,

I have to distribute one value per customer and month on a cube per customer, month, item and agent, based on the turnover cube, also with customer, month, item and agent. On these 2 last cubes, "customer", "article" and "agent" are in sparsity. I made a dataflow with the following steps:
a: value per customer / month to be distributed
b: turnover cube with "references" function for customer month.
c: turnover cube
d: (value distributed per month, customer, agent, article) result of c * (a / b).

 

Question 1) Is the approach correct?
Question 2) if it is correct, why are only some customers calculated?

Outcomes