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

asked 23 Jun '15, 09:54

Marcelo's gravatar image

Marcelo
807918
accept rate: 18%


Hi Marcelo,

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

Mino

permanent link

answered 23 Jun '15, 11:05

Mino%20Togna's gravatar image

Mino Togna ♦♦
52116
accept rate: 12%

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

permanent link

answered 23 Jun '15, 10:54

Mino%20Togna's gravatar image

Mino Togna ♦♦
52116
accept rate: 12%

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

permanent link

answered 23 Jun '15, 10:35

Mino%20Togna's gravatar image

Mino Togna ♦♦
52116
accept rate: 12%

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

permanent link

answered 23 Jun '15, 10:46

Marcelo's gravatar image

Marcelo
807918
accept rate: 18%

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

permanent link

answered 23 Jun '15, 11:03

Marcelo's gravatar image

Marcelo
807918
accept rate: 18%

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

Problem Found and Solved! Thanks!

permanent link

answered 23 Jun '15, 11:14

Marcelo's gravatar image

Marcelo
807918
accept rate: 18%

Ok good to know Marcelo.

Please, let me know if you have other issues.

Thanks,

Mino

permanent link

answered 23 Jun '15, 11:16

Mino%20Togna's gravatar image

Mino Togna ♦♦
52116
accept rate: 12%

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

permanent link

answered 21 Sep '16, 03:37

phuquy188's gravatar image

phuquy188
1123
accept rate: 0%

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

permanent link

answered 02 Jun '17, 14:08

joseph's gravatar image

joseph
14321025
accept rate: 0%

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

permanent link

answered 06 Jun '17, 17:13

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: 23 Jun '15, 09:54

question was seen: 10,860 times

last updated: 06 Jun '17, 17:13