---
title: "Saiku drop-down menu is empty"
url: "https://openforis.support/questions/176/saiku-drop-down-menu-is-empty"
tags: ["saiku"]
status: "answered"
score: 0
answer_count: 1
asked: "2015-02-10T15:58:56"
last_activity: "2015-02-10T16:38:17"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Saiku drop-down menu is empty

Asked by gmarchi on 2015-02-10

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][1]

This is a screenshot of the window

![http://i.imgur.com/6tod34D.png][2]

Could you please assist in having Saiku working again?

Thanks.


  [1]: http://i.imgur.com/hGydJUc.png
  [2]: http://i.imgur.com/6tod34D.png


## Answer (score 0, by collectearth on 2015-02-10)

Link: https://openforis.support/questions/176/saiku-drop-down-menu-is-empty/177

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.