Changes

__NOEDITSECTION__The primary purpose Two of most important purposes of any an information system must be to are:* ensure high quality of data and* support operational use of the information .One important use of the data is reporting. If it collectsnot possible in an easy way to create reports/statistics which reflect the data correctly the credibility of the data is lost. That’s why IMSMA^NG {{IMSMANG}} was designed with a robust reporting and analysis component that supports various reporting options. These options include:

{| class="wikitable" width="8001000"

| align="center" colspan="57" | '''Table 15. Comparison of IMSMA^NG {{IMSMANG}} Reporting Options'''

| width="195pt" | '''External MINT'''| width="195pt" | '''Other external reporting tool'''

| align="left" | Includes printing data entry formsData Entry Forms, summaries Summary items and maps

| align="left" | *Navigating data in IMSMA^NG {{IMSMANG}}*General summaries of pre-provided data

*Any report where the data is more important than the formattingCharts

*Creating dashboards targeted to specific audiences*Ad-hoc online data analysis (reports and charts can be created online)*Creating reports online or uploading them from iReport or Jaspersoft Studio*Sharing data and/or dashboards/reports/chart*Scheduling, executing, storing and sharing reports| align="left" | *Linking or exporting IMSMA^NG {{IMSMANG}} data for use in external tools*Building customised reporting tools for IMSMA^NG {{IMSMANG}} data

*Easiest way to get IMSMA^NG {{IMSMANG}} data into Excel

==Basic Reporting==__NOEDITSECTION__IMSMA^NG {{IMSMANG}} provides several reporting options that allow users to produce basic reports directly from IMSMA^NG{{IMSMANG}}. These include printing data entry forms Data Entry Forms entered into the system, maps from the main navigation window and item summariesSummary items. Any of these reports can be sent directly to a printer or to an intermediate format such as rich text format (.RTF) or portable document format (.PDF) for transmitting in electronic format or for further editing.

IMSMA^NG {{IMSMANG}} also includes a Map Layout manager that allows users to define map layouts and print high-quality maps with IMSMA^NG {{IMSMANG}} data. Information managers can define map layout templates that include scale bars, annotations and legends or use more sophisticated tools like ArcGIS Desktop to prepare more complicated map layouts for displaying IMSMA^NG {{IMSMANG}} data.

* Map layouts can be printed and scaled to any size paper. This is a simple way of producing IMSMA^NG {{IMSMANG}} maps without needing additional GIS software.* Map layout templates can be prepared and distributed to individual IMSMA^NG {{IMSMANG}} clients, allowing information managers to prepare templates based on user preference preferences or functional needneeds.}}  ==Embedded Reporting==__NOEDITSECTION__{{IMSMANG}} supplements the basic reporting options available to all users with several more sophisticated reporting tools that are embedded within the system. In addition to reporting on individual elements, these embedded tools allow for statistical and aggregate reporting of data within the database. Instead of reporting the contents of a single report, statistical reporting allows information managers to produce reports about multiple items and to use functions such as sum, average and count to summarise data.  There are two options for embedded reporting: iReports and data export. Both functions rely on {{IMSMANG}} searches to filter data. Using iReports, information managers can build reporting templates to visualise data in a specific and repeatable format. Using data export, managers can export search results to an external tool such as Microsoft Excel and perform aggregation and statistical analysis.

|[[Working with the Map in IMSMANG#How to Print the Map Layout Use iReport | Print Maps]]|[[Working with the Map in IMSMANG#Map and Data | Print Maps and DataUse iReport]]

 ==Embedded Reporting==IMSMA^NG supplements the basic reporting options available to all users with several more sophisticated reporting tools that are embedded within the system. In addition to reporting on individual elements, these embedded tools allow for statistical and aggregate reporting of data within the database. Instead of reporting the contents of a single report, statistical reporting allows information managers to produce reports about multiple items and to use functions such as sum, average and count to summarize data.  There are two options for embedded reporting: iReports and data export. Both functions rely on IMSMA^NG searches to filter data. Using iReports, information managers can build reporting templates to visualize data in a specific and repeatable format. Using data export, managers can export search results to an external tool such as Microsoft Excel and perform aggregation and statistical analysis. ===iReports===With the iReport tool, information managers have access to an entire suite of report generation functions. iReport provides the ability to design report templates from the desired data elements; add page layout and formatting information including images, colours and text; and import the reports into IMSMA^NG {{IMSMANG}} for data entry personnel to run. Information managers can also design complex reports to summarize summarise data using sum, count, average, subreports and other statistical reporting functions similar to packages such as Crystal Reports. Being fully integrated into IMSMA^NG{{IMSMANG}}, iReport can be translated into any language supported by the system. Using this approach, only information managers are presented with the complexity of designing reports while traditional users simply have to select a report (and any preceding search) and run it.

*data quality: number and list of lands land with incorrect status

Because iReport templates are initiated with a search, they provide a scalable reporting solution that allows one template to be developed for many reports. For example, a report template that shows number a list of lands and size of lands by province land with associated ordnance details can produce different reports depending on the search parameters.

In the first example, no search parameter is applied and all data in IMSMA^NG {{IMSMANG}} is used in the report. But by adding a search parameter, for example, limiting this to lands land whose status is activeWorked on, a different report is generated.

Moreover, if the lands are land is further limited to minefields (excluding UXO and battle areas)a specific type, another report is generated, all using again the same template. In this This way, information managers can build templates and searches to fulfil fulfill multiple reporting needs.

Reports created with iReport can be printed directly within IMSMA^NG {{IMSMANG}} or saved to an intermediate format such as .RTF, .PDF or .XLS for electronic transmission or additional editing or inclusion in other reports. iReport supports the inclusion of charts, images and headers and footers, and it acts as a complete reporting package similar to Crystal Reports.

|[[HowTo: Use i-Report Exporting| Use i-ReportExport data]]

===Data Export===IMSMA^NG {{IMSMANG}} also provides data export functionality designed to allow users to export data to external tools such as Microsoft Excel for additional reporting and analysis. This lets users take advantage of functionality in these tools such as sums, counts, charts, pivot tables and other data manipulation functions to format and present data. Users access this functionality by performing a search in IMSMA^NG {{IMSMANG}} and then exporting the results to .CSV format. Users can choose which columns to export, and the data can be manipulated in any external tool that supports .CSV.

Because data export is initiated with a search, it provides a flexible approach for getting data to an external tool. However, once the data is used in a tool outside of IMSMA^NG{{IMSMANG}}, it is impossible to control how this data is manipulated which may limit the consistency of reports produced in this way.

{{note|IMSMA^NG {{IMSMANG}} searches return information on only one item at a time, and data export is limited to the data returned by the search. Data from linked items (such as victim data linked to accidents) is not available for export.}}

==Reporting Tools provided for IMSMA==__NOEDITSECTION__ ===MINT===__NOEDITSECTION__The Mine Action Intelligence Tool (MINT) is available as of {{HowTo's|IMSMANG}} version 6.0. It is a web-based tool for reporting, data analysis and indicator tracking. As such, it allows users to create and view digital dashboards, perform ad-hoc data analysis online in a very intuitive way, create reports and charts online, and upload reports created in a report designer tool. MINT is available on a web server managed by GICHD. Each organisation/programme/country can however manage its own space, create roles and users, manage data sources and data domains, etc. MINT is the most advanced and complete reporting solution provided for IMSMA. It is recommended to connect MINT to the [[IMSMA Staging Area]]. A more detailed description, instructions, how-to pages etc. are available on the [[ExportingMINT| Export dataMINT pages of this WIKI]]}}.

==External Reporting Tools==[[Image:MINT_dashboard.png|center|700px|''Example of a dashboard created in MINT'']]IMSMA<supdiv align="center">NG</sup> also allows information managers to connect advanced reporting tools such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced report generation. With this capability, information managers can use custom reporting solutions to connect with IMSMA^NG, allowing for complete control ''Example of IMSMA^NG outputs. Or, managers can modify existing reporting solutions to connect to IMSMA^NG, which leverages technology already implemented a dashboard created in the programme and limits the need for retraining. MINT''

</div> ==External Reporting Tools==__NOEDITSECTION__{{note|Using external IMSMANG}} also allows information managers to connect advanced reporting tools is a complex activity requiring an such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced understanding report generation. With this capability, information managers can use custom reporting solutions to connect with {{IMSMANG}}, allowing for complete control of SQL{{IMSMANG}} outputs. Or, managers can modify existing reporting tools solutions to connect to {{IMSMANG}}, which leverages technology already implemented in the programme and limits the IMSMA^NG data model}}need for retraining.

===Connecting External Reporting Tools===The process for connecting {{note|When using external reporting tools is essentially the same for all tools. External tools we recommend to connect to the '''[[IMSMA^NG relational Staging Area | Staging area]]''' instead of the {{IMSMANG}} database via an ODBC connection. Information managers establish this connection by installing It does require knowledge about the ODBC driver for MySQLIMSMA data model. When this is complete, information managers can connect any ODBC-compliant tool to the IMSMA^NG database, including reporting tools, other database packages and SQL management toolsContact contact your [[Information Management Team | GICHD IM advisor]] if you have questions. Examples include:}}

===Connecting other External Reporting Tools===__NOEDITSECTION__The process for connecting external reporting tools is essentially the same for all tools. External tools connect to the {{IMSMANG}} relational database via an ODBC connection. Information managers establish this connection by installing the ODBC driver for PGSQL. When this is complete, information managers can connect any ODBC-compliant tool to the {{IMSMANG}} database, including reporting tools , other database packages and *Crystal Reports*ArcGIS Desktop*iReport*Microsoft Excel Database packages *Microsoft Access*OpenOffice Base*Microsoft SQL Server*OracleSQL management tools*MySQL Query Browser*Navicat*TOAD SQL*Heidi SQL. Examples include:

{| class="wikitable"! scope="col" | Reporting tools || scope="col" | Database packages || scope="col" | SQL management tools|-| Crystal Reports || Microsoft Access || PGSQL Query Browser|-| ArcGIS Desktop || OpenOffice Base || Navicat|-| iReport || Microsoft SQL Server || TOAD SQL|-| Microsoft Excel || Oracle || Heidi SQL|} When connecting an external reporting tool to IMSMA^NG{{IMSMANG}}, it is recommended that information managers build database views within the database to do any necessary data transformations. While it is possible to directly import or connect IMSMA^NG {{IMSMANG}} database tables in external tools and perform transformations within the external tools, the recommended method is to do transformations within the IMSMA^NG {{IMSMANG}} database using database views and then import the resulting views into the external tools.

{{note|Building database views to transform data before importing it into other tools significantly reduces the performance hit associated with connecting external tools.}}

===Building Database Views===__NOEDITSECTION__Building database views is the primary way of transforming data to support external reporting. Information managers can use SQL editing tools to build and save database queries as views that can be used to format data for easier reporting. Using database views, information managers can join data together into flat tables that allow for easier incorporation into reports or other analysis tools. Database views act like database tables and can be imported or queried from external tools. Moreover, views automatically refresh as data is added to IMSMA^NG {{IMSMANG}} and provide an up-to-date data source for other applications.

Using database views, information managers can perform statistical and other operations on the IMSMA^NG {{IMSMANG}} set for reporting purposes including sum, count and average or more complicated functions available in SQL. These operations can be combined with search criteria to provide a highly precise mechanism for providing data to reports. For example, information managers can create a view that returns the name of each clearance and a sum of the hours worked, AP mines found and area cleared on all progress reports linked to each clearance.

This view could then be pasted into Excel, linked with additional IMSMA^NG {{IMSMANG}} data or external data or linked with a map to provide additional analysis. As such, database views provide a powerful way of formatting and analysing IMSMA^NG {{IMSMANG}} data.

* Database views created in IMSMA^NG {{IMSMANG}} are backed up by the IMSMA^NG {{IMSMANG}} backup functionality. However, it is important to correctly set the database permissions on views or it will cause problems when restoring the databases.* Information managers should maintain separate files containing the view creation scripts so that they can be quickly and easily restored or modified. Using the CREATE OR UPDATE REPLACE VIEW syntax from SQL is an easy way to build scripts for creating or updating replacing views if they already exist.}} {{NavBox IMSMA NG Administration}}