Questions Tagged With saiku
Ask a questionareas per attribute dans collect earth
Bonsoir svp quelqu'un pourrait m'aider a résoudre un problème? J'aimerais savoir comment insérer les superficies lors de la conception d'un questionnaire a Collect Earth survey?. Je n'y arrive vraiment pas ce qui fait que quand je suis sur SAIKU je n'arrive pas a avoir les superficies de mes occupa...
Standalone Saiku tool
Is there a way to create a standalone Saiku tool without going through CE? I would like to run Saiku using a DB from CEO. I created a Collect Survey, adjusted and imported the DB into CE. But instead of running CE everytime and then start Saiku I would like to have a Saiku tool directly to run my DB...
Species vernacular name in saiku
Hi, I would like to use the vernacular name for reporting in Saiku. I notice that only the scientific name is available for reporting from the species tables. I made a new field in OF Collect to automatically populate and store the vernacular name. However, when I export the data to OF Calc and the...
Minimum number of plots for Saiku?
Hi, I have a small amount of data (10 plots over 2 clusters within a single region) that I would like to use for prototyping and testing. I have cleaned the data in OF Collect and promoted to ready for analysis. I can import the data into my OF Calc workspace with no errors and I can then view the d...
Can we load also the codes of the attributes in Saiku?
Saiku provides a very handy opportunity to produce matrix tables, e.g. Objects (names/nrs) x Plant species with cover/abundance; this table format is used in e.g. apps for classification in vegetation types. For this the codes are needed/preferred (instead of the labels): can that be made possible.a...
Updating Calc v. 2.1-a17 (Windows) and saved Saiku queries
Notice for Calc users: Calc v. 2.1-a16 fails to import a workspace file, and there is an updated version Calc 2.1-a17 for Windows available here under this link. If you have saved Saiku queries for Calc: before installing the newest version, take a safety copy of the queries from c:\opt\OpenForisCa...
Saiku calc - no results
Hey all together, when I am trying to use Saiku from Open Foris Calc and I create a query, it says "no results" and doesn't give any output, no matter what I try to query. If I use Saiku from Collect, everything works. Did someone encounter similiar difficulties or has a solution for that?
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 ano...
Saiku Collect does not create a database
Hey to all, I face the follwing problem: I am playing around with the labels in Saiku and so far I added labels in an unpublished suvey, published it, opened Saiku, had a look, closed it again, unpublished the survey, changed the labels, published it again,... I repeated this process several times a...
saiku – wrong column name for multi-language label
Dear developers, we have found an error when saiku (CE version 1.8.0 build 2019-04-12) tries to get label of lookup table with multi-language labels: PSQLException: ERROR: column c_fra_class_code_fra_class_code_code.c_fra_class_code_fra_class_code_label_ does not exist Rada: Perhaps you meant to ref...
Create drop down menues in Saiku
Hey to all, I am wondering whether it is possible to reorganize the attribute names in Saiku in drop-down menues? I can introduce groups that will be arranged in an alphabetical order, but not more. Maybe someone has more experience in this regard? Regards :)
saiku – missing PostgreSQL JDBC driver
Latest installer of Collect Earth (1.6.33 from download page) for Win is missing PostgreSQL JDBC driver. This causes Saiku error: ... driver:mondrian.olap4j.MondrianOlap4jDriver url:jdbc:mondrian:Jdbc=jdbc:postgresql://HereIsOurIPaddress:5432/CollectEarthDb;Catalog=HereIsOurPath/collectEarthCubes.x...
Querying collect earth survey results in Saiku
Hi, I have carried out a survey using Collect Earth. I now have the results and would like to be able to make use of the Saiku Analytics tool to query and presents these results. I manage to successfully start the Saiku analysis from Collect Earth (Tools > Start SAIKU anlysis). However when I try to...
how to display the classes of a query
hi, I cant display the different classes of land use in the field when i run the query in Saiku, instead i get the total of all plots who had data filled regarding land use types.
Slight difference between Saiku stats and Excel
Hi, I was checking my calculated field by comparing the average in Saiku versus in Excel. I filled 10 plots for the field to be calculated. I enter the same data in my Excel file too so I could compare between Saiku and Excel. I always have a difference: The district average is 23.21% in Excel but 2...
Saiku: How to Remove Old Cubes from Drop Down List
Dear Support Team, I have been playing/working with a number of surveys over the years. Now in Collect, the list of selectable cubes in the Saiku drop-down list has become rather long (still including surveys that have been deleted). How can I clean up this list? Maybe that would also solve my issue...
Connection between Collect and Collect Earth
Dear Community, Somebody help my ignorance. What is the difference between Collect and Collect Earth. I have used collect to design a survey and i have now access 100 plots using that survey in Collect earth. For analysis, do I need to bring the data back to Collect (I am confused since I see that ...
SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: forest_view)
Hi OFT, I am facing a problem when saiku generates the database. it always says this type of msg Generating Saiku Database FAILED Error processing RDB generation events . When I start saiku and try to drag and drop attributes this type of msg SQLException: [SQLITE_ERROR] SQL error or missing databas...
SAIKU does not start
I am trying to open SAIKU from Collect earth, the Java windows opens but then nothing happens. I made sure I have the latest version of Collect earth. Below is the error I am getting. Can someone please help me? I am unable to post the information in Java, the system is thinking it is a spam.
How to organize the fields in Saiku
Hi, I numbered my fields so they would appear in a specific order in Saiku but it does not fully work. The appearance in the "Measures" section seems to follow the order in which I entered the fields in the survey, not according to the Saiku name itself. Any idea of how to improve on this? Thanks, F...
What are "." in Saiku?
Hi, It seems that "0" appears as "." in Saiku. I think it is misleading as it could be understood as a "null" value. How can I make sure "0" appear as "0" in Saiku report? Thanks, Florence
How to perform a Saiku analysis on a calculated field nested in a table?
Hi, I have been unable to find calculated values that are within a table in Saiku (for example, I have a table where the rows are each land use-land cover class and I have 2 columns: one for the interpreter to count the number of dots in each class (I can find this one), and one for a calculated fie...
On what are based the statistical estimations in Saiku?
Hi, I am very ignorant in terms of statistics but my understanding is that statistical estimations are calculated differently according to whether the sample is built on a sampling design that is stratified or not, systematic or random, etc. How can we tell Saiku in CE which sample design was used? ...
Creating pivot report (Summarized report based on specific column)
Hi there, We have designed a survey form with following schema Forest->Forest_ regime->Forest_ block->sample_plot->(seedling, sapling, pole, tree). We have currently setup everything and data is being collected as intended using collect mobile. We import the .collect_data file which is then listed i...
Saiku server is not configured
Saiku will not launch. The error message states: The SAiku Server is not configured. Set-up the path to the folder where Saiku Server is installed in the Tools> Properties>Advanced tab. The JAVA_HOME environment variable is not configured. JAVA_HOME must oint to the root folder of a valid JDK. The ...
I'm adding a new column to CSV. But Saiku does not look.
Hello to everyone, I have a problem. I have a column of data I forgot to add to CSV. I added this column later. Import the updated ZIP file through Tools->Data Import/Export->Import But this data does not appear in XML. Because of does not appear Saiku.
How to do Saiku analysis for collect mobile?
I am testing a collect mobile survey before going to the field. My survey is working fine in the mobile app and I have filled in 3 dummy records for analysis. I was able to cleanse the data and promote it to analysis but after generating the records and launching Saiku, nothing happens and the scree...
How to use the new embedded Saiku queries feature??
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!
Java problem with Collect Earth 1.4.3 Saiku on Windows 10
Hi, I have just installed Collect Earth 1.4.3 under Windows 10 and have hit what looks like an installation problem. When I go to run Saiku Analysis I get the following message: Windows cannot find 'C:\OpenForis\CollectEarth/java\bin\java.' Make sure you've typed the name correctly, then try again. ...
Change the Saiku dimension name
Hello, I have a few attributes in my survey that have very long labels because I want them to be explanatory in the form. The problem is that when I analyze the data in Saiku the dimension names are very long and it doen't look so good. How can I change the names so that in Saiku the labels fit bett...
Most recently updated questions