SpagoBI allows to realize structured reports, using structured information views (ex. lists, tables, crosstabs, graphs) and to export them using several formats (HTML, PDF, XLS, XML, TXT, CSV, RTF).
SpagoBI integrates the following reporting engines: BIRT, JasperReport, BusinessObjects 6.5.
SpagoBI allows the multidimensional analysis through OLAP engines, which are more flexible and user-friendly, compared to structured reports. After having set the analysis axis according to hierarchies and observed measures, the users can monitor the data on different detail levels and from different perspectives, through drill-down, drill-across, slice-and-dice, drill-through processes.
SpagoBI integrates the following OLAP engines: JPivot/Mondrian, JPalo/Mondrian, JPivot/XMLA Server (ex. MS Analysis Services).
SpagoBI offers a specific graphics engine, based on JFreeChart, which allows to develop single ready-to-use graphical widgets (such as histograms, pie graphs, bar graphs, area graphs, scatter diagrams, line graphs, bubble graphs, dispersion graphs) and interactive ones (temporal sliders, add/delete series), to be used separately, by choosing the properties to be included into the reports for a richer data view.
SpagoBI offers a graph visualization engine, in SWF format, allowing to display KPIs (Key Performance Indicators) for real-time graphical performance views.
SpagoBI offers all the necessary tools to create, manage, view and browse KPI hierarchical models, through different methods, calculation rules, thresholds and alarm rules.
SpagoBI offers a specific engine for the realization of complex c***pits which allow to aggregate several documents into a single view, connecting them with one another, fostering their interactive and intuitive usage.
SpagoBI offers some geographical engines allowing to set real-time connections between the geographical data and the business data of the Data Warehouse. SpagoBI offers two engines in this domain:
- A GEO engine, which uses a static catalogue in order to display data, allowing users to dynamically re-aggregate the information, according to geographical hierarchies (ex. nation, country, city). This engine can also be used out of the geographical "context" in the strict sense of the word: the indicators distribution can be displayed through any graphical structure (ex. process flow charts, topological schemes of hardware infrastructures)
- A GIS engine, which interacts with real spatial systems, according to the WFS/WMS scheme. This engine integrates the open source GEO Report solution.