Google Summer of Code 2009: Ideas 4 GeoReport !

Google's Summer of Code program allows for students to receive a stipend for developing open source software under the supervision of one or two mentors.


GeoSoa Research Group proposed some projects related to Geo Business Intelligence thematics here.
In this context INOVA and GeoSoa propose the integration of Spatialytics and GeoReport in PentahoBI platform using CDF as described in the fifth idea


GSoC: Integration of Spatialytics and GeoReport into Pentaho CDF

• This idea stems from an active collaboration on Geospatial Business Intelligence between the GeoSOA research group and Inova, an italian company. The GeoBI blog details the open source software stack Inova plans to develop. It is mainly based on GeoKettle (spatial ETL tool), GeoMondrian (Spatial OLAP Server). GeoReport is a web cartographic component that enables the display of charts, diagrams and indicators on cartographic features click by running BI processes. It has been recently integrated to Pentaho CDF, the new dashboard framework provided by Pentaho. Together with these developments, the GeoSOA research group has implemented Spatialytics, a web cartographic component that enables the navigation in Spatial OLAP data cubes and the display of thematic maps. Spatialytics allows then users to drill down and roll up in the different levels of details/aggregations present in the geospatial data cubes served by a GeoMondrian Spatial OLAP server instance. Both Spatialytics and GeoReport rely on OpenLayers. Spatialytics aims at being integrated in different analytical dashboard tool in order to provide them with geo-analytical capabilities. With the perspective of setting up a geo-analytical dashboard framework, some works have been initiated in the GeoSOA research group in order to couple JasperServer and Spatialytics. First results are very promising, even if a lot of work remain to be done. In order to support this integration effort, the idea proposed here both by the GeoSOA research group and Inova deals with the integration of Spatialytics and GeoReport into Pentaho CDF in order to step up the developments already initiated and provide the users with a first integrated solutions for the design of light, interactive and drillable geo-analytical dashboards over the web. The student in charge of the project will thus have: 1) to take some time in order to be more familiar with GeoBI concepts and the different tools, 2) start the integration work by defining small integration steps to be acheived in order to consistently merging capabilities provided by the the different tools, 3) if time remains, extend the thematic capabilities of the integrated tool. The student will be supervised both by the GeoSOA research group and Inova.