Difference between algorithm and Dataflow
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,
Answers

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
2 
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
1 
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
0
Categories
 All Categories
 1.8K Forums
 1.7K Platform
 99 Academy
 269 Resources
 Board Manual
 50 Best Practices
 41 HowTo Guides
 25 Board Advocacy Program
 153 Blog
 Groups Hub
 4 About Groups
 New Community Members
 DACH
 Japan
 Academy
 2 Board Academy
 7 ILT/VILT Course Catalogue
 13 eLearning Course Catalogue
 4 Academy Forum
 1.1K Idea Exchange
 270 Partner Hub
 1 Solution Sales Toolkits
 91 Support
 14 FAQ's
 Customer Support Portal
 54 Support Articles
 BEAP