How best practice of dataflow ?

Ilham Maulana Habibie

Hi all,

I want to ask about related like this documentation below captures :

So, Let's say I have same case like above capture, and then let's say Product = Part Number and Salesperson = Material Consumed. And then I didn't use Month dimension to calculate it in dataflow. For Part Number and Material Consumed is standalone entity. How can I calculate sum only that Part Number which is related to Material Consumed? Because I got issue that dataflow show the result as that all Part Number cube values has been summed.

Do you have any ideas?

Best regards,

Ilham

Helmut Heimann

Hi @Ilham Maulana Habibie ,

I must admit that I don't quite understand your aim and will need your input on whether my assumptions are correct: Cube A is dimensioned by Part Number and Material Consumed, no time dimension. So I'd assume that this cube just holds information on what Material is consumed by what Part, making this a mapping cube. Regarding the quoted abstract where the target of the dataflow has one dimension more than the source—what is that dimension?

Best,
Helmut