Answers to: Where to calculate advanced statistics in Calc/Saiku?http://www.openforis.org/support/questions/1195/where-to-calculate-advanced-statistics-in-calcsaiku<p>Hi OF Team,</p>
<p>I understand basic statistics are calculated directly in Saiku, using the button labelled with a Sigma. However, using this merely displays min, max, mean, sum and std. dev.
Where would you recommend to calculate additional statistics like confidence intervals, SE%, etc.? Does this require an additional R script?
Is there any information in the tutorials/manuals on this issue that I have overlooked?</p>
<p>Thanks for your help!!</p>
<p>Alex</p>enMon, 27 Mar 2017 10:40:26 +0200Answer by Mino Tognahttp://www.openforis.org/support/questions/1195/where-to-calculate-advanced-statistics-in-calcsaiku/1197<p>Hi Alex, Francisco,</p>
<p>Francisco is correct, but adding calculation in R will allow you to add information to the raw data that will be then aggregated in Saiku.</p>
<p>If you instead want to produce results directly to the aggregated data (for example the information you want to aggregate doesn't follow basic aggregation currently available in Saiku) you can use advanced MDX mode. </p>
<p>Attached a small example of MDX to calculate results from an aggregated member.
Please let me know if this is enough or you need more info.</p>
<p>Thank you,</p>
<p>Mino</p>
<p><img src="http://www.openforis.org/support/upfiles/mdx-in-saiku.jpg" alt="alt text"></p>
<p><img src="http://www.openforis.org/support/upfiles/mdx-in-saiku2.jpg" alt="alt text"></p>Mino TognaMon, 27 Mar 2017 10:40:26 +0200http://www.openforis.org/support/questions/1195/where-to-calculate-advanced-statistics-in-calcsaiku/1197Answer by francisco_lillo_rhttp://www.openforis.org/support/questions/1195/where-to-calculate-advanced-statistics-in-calcsaiku/1196<p>According to my experience with collect and calc, in order to calculate these statistics, it is necessary to incorporate them from R in Calc, where, according to the cube that you want to add information, you can calculate the statistics using RStudio for the data inside the cube and then you can analyze this information in Saiku.</p>
<p>Saludos desde Chile.</p>francisco_lillo_rFri, 24 Mar 2017 16:30:54 +0100http://www.openforis.org/support/questions/1195/where-to-calculate-advanced-statistics-in-calcsaiku/1196