Hi, i have a question about dataflows and algorithms

Why does the applied algorithm returns different values for the following two cases?

1) as a result of a Dataview algorithm

2) as a result of a dataflow procedure

I am performing a simple c=(a*b) dataflow process

Thanks,

Hi,

When you use an algorithm in a dataview to calculate the result of a function, data is aggregated first, then the function is applied.

When you use the dataflow, the function will be performed at the maximum detail level (cell level - therefore per every element of every dimension of the cube), and only after having calculated the result of the formula per every cell, data is aggregated at the level you are displaying it into the dataview.

At the maximum granular level the dataflow and the algorithm will show the same result, but as you aggregate values and dimensions (by default BOARD aggregates data by sum), you will see the sum of the product [dataflow] instead of the product of the sum [algorithm].

Hope this helped,

Regards,

Antonio Speca,

Product specialist