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?