Saiku drop-down menu is empty

  • Asked
  • Active
  • Viewed 7620 times
0

Hi there,

The Saiku window is showing an empty drop-down menu, also after having Collect Earth recreate the Saiku database.

http://i.imgur.com/hGydJUc.png

This is a screenshot of the window

http://i.imgur.com/6tod34D.png

Could you please assist in having Saiku working again?

Thanks.

0

Accepted answer

Dear Giulio,

In the Saiku window ( the black dialog that is title Tomcat is actually the container that is running the Saiku server) we can see in the message that there was an error on the way that Saiku built the query. The Measure called TreeCount is missing but there is a CalculatedeMeasure (TreesPerHectar) that is trying to use TreeCount it.

I am checking the Collect Earth Project (.cep) file that I sent you and I see in the file called collectEarthCubes.xml.fmt ( you can change the name of the cep file to zip and decompress it ) that the TreeCount measure has a different name. You should add change the

< Measure name="Tree_Count" column="trees_outside_forest" formatString="#,###" aggregator="sum" visible="true"> < /Measure>

so where it says Tree_Count change it to TreeCount so that the calculated measure can actually find the tree count measure.

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.