|
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 |
|
Hi Johathan. Yes, if you change it to categorical variable it will be available in Saiku! regards, Lauri |
|
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 |
|
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 |
|
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 |
|
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 |
|
Hi Lauri, This worked perfectly! Thank you very much for your clear explanation. Best Regards, Jonathan |