Difference between revisions of "Reporting"

From Hornbill
Jump to navigation Jump to search
Line 31: Line 31:
 
* [[Table Info: Main Request Table|Main Request Table (h_itsm_requests)]]
 
* [[Table Info: Main Request Table|Main Request Table (h_itsm_requests)]]
 
* [[Table_Info: h_sys_ccodes|ISO Country Codes (h_sys_ccodes)]]
 
* [[Table_Info: h_sys_ccodes|ISO Country Codes (h_sys_ccodes)]]
 +
* [[SQL_Reference: Date Time Functions|SQL date Time Functions]]
 
Full schema information and table descriptions can be found in the Application entity viewer located in Hornbill Administration: [[Application_Entity_Viewer|'''''Click here for more info''''']]
 
Full schema information and table descriptions can be found in the Application entity viewer located in Hornbill Administration: [[Application_Entity_Viewer|'''''Click here for more info''''']]
 
[[Category:Administration]]
 
[[Category:Administration]]

Revision as of 17:47, 20 November 2018

Home > Administration > Reporting

Introduction

The Hornbill Administration comes with a powerful, enterprise reporting solution to allow you build and extract the business intelligence that you require. Standard reporting comes as part of the service manager application while the Measures, Widgets, Dashboards and Slideshows features form the Hornbill Performance Analytics package which can be purchased separately.

Related Articles

Features

Measures

In order to provide strategic business intelligence through reporting one of the key requirements is to define measures that are sampled and stored periodically. Once these measures are stored over a period of time the type of reporting possible is expanded considerably and include things like trending, performance measurement against goals and thresholds, and predictions based on historical trends

Widgets

Widgets are provided to create plug in data that can be used to build Dashboards. Some widget types make use of existing measures and provide the ability to display them in a more appealing format. Certain widget types allow you to return and display data based on configuration carried out within the widget.

Dashboards

Dashboards are used to display widget content.

Slideshows

Slideshows provide a way of automatically presenting a number of Dashboards one after another, and against definable transitions periods.

Reports

Reports are used to collect specific data for your reporting needs. The reports in Hornbill are point in time, meaning that the data is accurate at the point when the report is run. There are various different options with reports which will be explored in more detail in the following sections.

Useful References

Full schema information and table descriptions can be found in the Application entity viewer located in Hornbill Administration: Click here for more info