Business Intelligence Reporting
The reporting features of DecisionCentric® provide a powerful business intelligence tool for your end users, enabling them to integrate, analyze, and publish enterprise data from disparate databases—independent of IT staff availability.
If you need to deliver the ability to produce complex reports and forms in any format to your employees, DecisionCentric provides the ideal solution. DecisionCentric includes a powerful business intelligence reporting tool for organizations that have data stored in disparate operational systems or databases.
The DecisionCentric Report Designer is a full-featured, business intelligence reporting tool that creates anything from simple columnar reports to complex forms and documents. The Report Designer intelligently interprets field lengths of the data and adjusts the column widths automatically. This ensures that valuable real estate is conserved even when the database field is larger than the displayed data.
DecisionCentric is a reporting tool that delivers business intelligence to users based on criteria they define, and in real time. Save reports in multiple formats. Publish (export) reports as .PDF, .RTF, .XML and Excel files, or as HTML files for use on your organization’s intranet and web site.
Detail and Summary Processing
DecisionCentric requests create reports and files at various levels of aggregation for detailed business intelligence reporting. Aggregation functions include sum, average, count, minimum, maximum and expression (a formula that is a function of other cells and values). A summary request can be as simple as summing one field by another or as sophisticated as having a unique set of records aggregated for each cell of a spreadsheet or report.
Calculated Fields
Calculated fields are useful to translate or transform data in a report. For example, where you have access to shipment information that includes price and quantity, you can create a new field (call it TotalOrder if you like) by multiplying price and quantity together.
In addition to doing regular, numerical data calculations like in the example above, you can also use this feature to translate code fields into descriptions, split a single column into multiple columns, run data calculations and do character manipulation.
All types of data, numerical, time/date and alpha/numeric, are fair game. In all cases, the calculated field becomes part of the “result set” produced by the end user’s information request.