Difference between algorithm and Dataflow

Previous Member

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,

Previous Member

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

Previous Member

Hi Antonio,

I understand better now. Does this change if i apply a different TOTAL option in the layout block? 

 

Is this a feature that might resolve the behavior?

Thanks

Previous Member

Hi BOARDVille Citizen,

 

the "Summary Algorithm" influences the values of the partial and grand total rows. Here's an example with one cube having the summary algorithm 'Total' and the second one 'MAX':

The summary algorithm only takes the finished values in the cells of the table and then applies the logic to it. In case of MAX the logic would be to take the highest value.

The "Summary Algorithm" does not influence the "Dataview algorithm".

For more information lookup Board Help - Layout Data Blocks - Summary Algorithm 

 

BR, Ray