Species list empty in Saiku

Hi OF Team,

I included a short species list in my survey, imported data and would like to show the recorded species grouped by another variable in Saiku (OF Collect). However, clicking the filter of the scientific name or code variable shows an empty box. When I try to group species according to another variable, I get the following error:

SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: household_view.fw_species_code)

Any hint that could help?

Thanks a lot!!

saiku collect

asked 09 Jul '19, 13:41

wexxo
145●2●18●42
accept rate: 4%

One Answer:

active answers oldest answers newest answers popular answers

Dear Alex,
The problem can be related to the use of a multiple "Taxon" attribute, that is not yet fully supported by the Saiku database generator.
Please try to convert the structure of your schema into a multiple entity with a single Taxon attribute inside of it.
Many thanks,
Open Foris Team

permanent link

answered 02 Aug '19, 12:17

Stefano (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

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

learn more about Markdown

Question tags:

collect ×494
saiku ×42

question asked: 09 Jul '19, 13:41

question was seen: 2,371 times

last updated: 02 Aug '19, 12:17

Species list empty in Saiku

Follow this question

Related questions