There are numerous ways to filter data in Saiku. Data can be filtered before and during a query. Data can also be filtered after running a query, while viewing results in Sauki’s interactive tables and charts.
Filtering data in a query: option 1
Example: Number of deforested plots per land use category
Deforested plots are those that were initially forest, but now belong to a different land use category. Start by selecting the non-forest land use categories. Move the land use category cube to the columns field.
Click on the filter icon (the magnifying class) beside the cube name to view the filter window. Select the “members,” the land use categories in this case, that you wish to use. Use the arrows to move them to the column on the right. To select multiple members, hold the Control key. Click OK to save the filter settings.
Filtering data in a query: option 2
Drag the land use category cube to the Columns field and the initial land use cube to the Filter field. The filter window will immediately pop up.
Move Initially Forest to the column on the right.
Click OK and view the results.
Filtering data in tabular mode
With land use category in the columns field and initial land use in the rows field, click on Initially Forest in the chart, then select Keep Only.
Click on Initially Forest again, and select Remove Filter to return to the original table.
Filtering data in chat mode
With land use category in the columns field and initial land use in the rows field, view the query results as a bar chart. Every item in the table can be selected, including the colored boxed and the data series names in the legend.
- Click on the blue box for forest in the legend to display only forest data.
- Click on the circular arrows symbol in the upper-left corner to re-render the chart.
- Click on the Forest data series title to only remove forest data from the chart.