Results of script not showing on Saiku

Question

Hi Mino, --on the tutorial database--

I have tried to add the dbh_classes using RScript instead of Category type and I am not able to see the results on Saiku. I have saved and executed it and everythinh went fine. I see the results on Calc. But when I open Saiku, it is not there (even though my other calculations appear fine).

entity: tree variable: dbh_classes

> tree$dbh_classes <- ifelse( tree$dbh <
> 10 , 1 ,  ifelse( tree$dbh < 20 , 2 ,
> ifelse( tree$dbh < 30 , 3 , ifelse(
> tree$dbh < 40 , 4, 5 )  ) ) );

Do you know what could be the problem?

Best, Marcelo

Accepted Answer · 2015-06-23T11:05:19

1

Accepted answer

Hi Marcelo,

Did you select any variables in the error settings without adding the error r code? then yes, you get an error.

Mino

Answer 2 · 2015-06-23T10:54:43

Hi Marcelo,

to add a new category to your data, you must add a new calculation step type category (as your first picture). The second one, creates a new quantitative variable.

However, in both cases, you should see respectively in Saiku a new Dimension or a new Measure.

After you execute your processing chain from the CALC main page (click the play button in the calculation section of the main page : alt text ,

open saiku, click the refresh button to update the cubes. alt text

and then select your cube to visualize the results.

If it doesn't work, please send me via email your collect backup and your calc workspace so that i can check,

Thank you, Mino

Answer 3 · 2015-06-23T10:35:20

Hi Marcelo,

The calculation step category type is an R script.

What do you mean by "I have tried to add the dbh_classes using RScript instead of Category type " ?

What kind of calculation step did you create instead of Category ?

Or have you tried to refresh the cubes in Saiku ?

Regards,

Mino

Answer 4 · 2015-06-23T10:46:27

Hi Mino,

I know the category type is a R script. However, on Calc, there are two different places to insert the code (Type = R Script and Type = Category).

Like this: alt text

And this: alt text

I have tried these different ways because no matter what I do, I cannot get them to show up in Saiku. Execution goes fine, I see the table with the correct values, but when I open Saiku, it does not display.

I have tried refreshing it. These two variables do no appear.

Thanks. Marcelo

Answer 5 · 2015-06-23T11:03:24

Thanks Mino,

Do I need the Error Script for all variables in order to run the processing chain? I have been getting the message HTTP Status 500 - Request processing failed; nested exception is java.lang.NullPointerException, probably caused by the CalculateErrorTask, everytime I run the chain.

Best, Marcelo

Answer 6 · 2015-06-23T11:14:19

0

Accepted answer

That is it then. I had one of the variables there selected (no idea why).

Problem Found and Solved! Thanks!

Answer 7 · 2015-06-23T11:16:34

0

Accepted answer

Ok good to know Marcelo.

Please, let me know if you have other issues.

Thanks,

Mino

Answer 8 · 2016-09-21T03:37:27

0

Accepted answer

I have some problen i need to help? can i get your email?

Answer 9 · 2017-06-02T14:08:02

This gives a good idea on the use/making measures(quantitative) and dimensions (categories). Now I made in Collect a code list for the (semi)quantitative Tansley abundancy/frequency decimal scale 0 - 9: to be used (pop up in Saiku) as measures but these are still (regarded) categories. Is there a better way than reading/assigning the codes in Collect in a newly created 'number'column? Could there be a way to assign codes (categories) to be treated as numbers (quantities) in Collect/Calc/Saiku. Hope I am clear, Joseph

Answer 10 · 2017-06-06T17:13:33

Hi Joseph,

the more consistent way would be to create a numeric attribute in collect ( you can use calculated attribute if you already have one).

Another way would be to create a qty variable in Calc and assign its value based on the categorical one.

Please let me know if you need more info.

Thank you

Mino

Results of script not showing on Saiku

10 Answers

Your answer

Insert a link

Insert an image

Follow this question

By Email

By RSS

Open Foris

Question tags

Related questions

Menu

Keyboard shortcuts

Anywhere

Lists of questions

Question pages

May we measure your visit?

Results of script not showing on Saiku

10 Answers

Your answer

Follow this question

By Email

By RSS

Open Foris

Question tags

Related questions