BI & Analytical Logic
Displays details, summaries, and statistical results.
The following describes some of the basic reporting functions of all IRI software products, which SortCL metadata using, including CoSort, FieldShield, NextForm, and RowGen – and the Voracity data management and ETL platform, which encompasses these products. The reports can be in custom layouts formatted and are merely optional goals within the same job script and I/O run as the core engine functions (transformation, masking, cleansing, migration, generation, etc.).
| Capability | Functions | Use |
|---|---|---|
| Conditional logic | Dataset filtering and field evaluation | Input data reduction through selection and deduplication, as well as output segmentation |
| Field Reassignment | Resize, reorder, and reposition fields | Integration of data sources into unified reporting formats |
| File formatting | Create, sort, and convert over 20 formats | Capture, migrate, and process data from other platforms |
| Type conversion | Translate between > 120 data types | Example: Convert numerical values to currency |
| Segmentation | Sort, connect, and select to capture and group. | Customer data integration (CDI) and segmentation |
| Summary | Number of intermediate sentences, sum, average, minimum, maximum, and multiplication | Drill-down and roll-up for invoicing, ranking, etc. |
| Cross-calculation | In-record expressions (mathematics, triggers, derived functions) | Billing, Business Intelligence, Analytics, and Fraud Detection |
| Expressions | Perl-compatible (PCRE) | Pattern matching, find and replace, etc. |
| Substrings | In-String (INSTR), Format Masking, Length Functions, etc. | Granular formatting and post-processing features |
| Lookups | Replacement and Fuzzy Logic Values | Discrete value display and trend reporting / Predictive analytics |