How to use the new embedded Saiku queries feature??

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 ). 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.

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.

And here it is