Hi OF Team,

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?

Thanks for your help!!

Alex

asked 24 Mar '17, 15:18

wexxo's gravatar image

wexxo
14511641
accept rate: 4%


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.

Saludos desde Chile.

permanent link

answered 24 Mar '17, 16:30

francisco_lillo_r's gravatar image

francisco_li...
3636
accept rate: 25%

Hi Alex, Francisco,

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.

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.

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.

Thank you,

Mino

alt text

alt text

permanent link

answered 27 Mar '17, 10:40

Mino%20Togna's gravatar image

Mino Togna ♦♦
52116
accept rate: 12%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×83

question asked: 24 Mar '17, 15:18

question was seen: 3,417 times

last updated: 27 Mar '17, 10:40