Hi,

I would like to use the vernacular name for reporting in Saiku. I notice that only the scientific name is available for reporting from the species tables.

I made a new field in OF Collect to automatically populate and store the vernacular name. However, when I export the data to OF Calc and then publish to Saiku the vernacular name that I stored is not visible. I confirmed that the vernacular name is in the results tables in R but is not available in Saiku.

Am I missing an additional step that I need to make the vernacular name visible?

Thank you for your help.

Best regards,

Jonathan

asked 28 Sep, 12:46

jpdash's gravatar image

jpdash
212
accept rate: 0%


Dear Jonathan,

Unfortunately vernacular names do not show up in Saiku. If you need to report them, you need to join these with the result tables outside of Saiku.

Best regards, Lauri

permanent link

answered 28 Sep, 15:55

LauriV's gravatar image

LauriV ♦♦
5152613
accept rate: 21%

Hi Lauri,

Thanks for your reply.

I understand that the vernacular names are not populated from the species list into Saiku. I hoped that because I had added an additional field containing the vernacular name in my surveys I would be able to access this from within Saiku. Other fields that are populated at the tree-level (for example tree health data or crown form) are available as Dimensions in Saiku. I notice that they are categorical variables whereas my new vernacular name field is a stored as a character in R. Is this the reason that the field is not available as a Dimension and could there be a workaround to write this field to Saiku as a categorical variable?

Many thanks

Jonathan

permanent link

answered 28 Sep, 16:55

jpdash's gravatar image

jpdash
212
accept rate: 0%

Hi Johathan.

Yes, if you change it to categorical variable it will be available in Saiku!

regards, Lauri

permanent link

answered 28 Sep, 17:02

LauriV's gravatar image

LauriV ♦♦
5152613
accept rate: 21%

Hi Lauri,

Can you suggest a workflow for this? Does the new vernacular name field need to be a categorical variable prior to export from Collect? I hoped that changing the datatype in R might have some effect but it doesn't. The vernacular name field in OF Collect is currently automatically populated based on the users selection of species and I wouldn't want users to have to select from another list.

Thanks

Jonathan

permanent link

answered 28 Sep, 17:39

jpdash's gravatar image

jpdash
212
accept rate: 0%

Hi Jonathan,

Your species list is probably so long that it can not be added into Calc as a new category (manually). So the only option is to have this field in Collect. In order to avoid conflicts between current data types, I recommend to create a new categorical variable in Collect, just for reporting, and keep the existing text field as it is now. This categorical variable can be function, and it gets the input value (code) from the species code (i.e. tree_species/@code where 'tree_species' is a attribute name ). When you publish the survey in Collect, this new field should get the value automatically. Check that your function works in Collect.

Export data from Collect and read it into Calc. Rerun the scripts in Calc UI (in order to publish the results to Saiku). You do not need to play with RStudio in this case.

regards, Lauri

permanent link

answered 28 Sep, 18:29

LauriV's gravatar image

LauriV ♦♦
5152613
accept rate: 21%

Hi Lauri,

This worked perfectly!

Thank you very much for your clear explanation.

Best Regards,

Jonathan

permanent link

answered 28 Sep, 20:20

jpdash's gravatar image

jpdash
212
accept rate: 0%

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:

×78
×41

question asked: 28 Sep, 12:46

question was seen: 104 times

last updated: 28 Sep, 20:20