---
title: "How to use the new embedded Saiku queries feature??"
url: "https://openforis.support/questions/986/how-to-use-the-new-embedded-saiku-queries-feature"
tags: ["saiku", "collectearth"]
status: "answered"
score: 0
answer_count: 1
asked: "2016-12-15T17:09:25"
last_activity: "2016-12-16T21:44:56"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# How to use the new embedded Saiku queries feature??

Asked by collector on 2016-12-15

Hello,

I just saw in the website news that the new version of Collect Earth can incorporate Saiku queries lined to a survey.

Could you please explain how to do this for my survey?

Thanks!


## Answer (score 0, by collectearth on 2016-12-16)

Link: https://openforis.support/questions/986/how-to-use-the-new-embedded-saiku-queries-feature/987

The process to add Saiku queries to your survey is quite straight forward.

Say that you have a survey that is already tested and you have already developed some Saiku queries to analyze the data. 

If you saved those queries they should be located in a folder in your computer ( [HERE IS HOW TO SAVE QUERIES][1] ). Usually this folder will be here (in Windows):

> C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\webapps\saiku\WEB-INF\classes\saiku-repository

The saiku queries are actually files (you can open them with a text editor) with the extension .saiku!

So you have your queries. Now you need to add them to the survey itself. This is done through Open Foris Collect *Survey Designer*. Once you go start editing a survey, in the main tab there is a section called "Files" . Here you can add the .saiku files to the survey.

![alt text][2]

![alt text][3]

Done!!! Now you need to export the survey using the Collect Earth format. This generates a .CEP file and if you double click on the file it is open by Collect Earth.

If you run the Saiku analysis now ( Tools->Start Saiku analysis ) you will notice that the Saiku queries that you added to the survey will be available in the Open query window.

![alt text][4]

And here it is

![alt text][5]


  [1]: http://www.openforis.org/tools/collect-earth/tutorials/saiku.html#accordion-311-34
  [2]: http://www.openforis.org/support/upfiles/chrome_2016-12-16_21-39-55.png
  [3]: http://www.openforis.org/support/upfiles/chrome_2016-12-16_21-41-00.png
  [4]: http://www.openforis.org/support/upfiles/chrome_2016-12-16_21-46-03.png
  [5]: http://www.openforis.org/support/upfiles/chrome_2016-12-16_21-46-25.png