Pixel Perfect Reporting
- Highly formatted reports containing interactive charts, images, sub-reports, expressions, and more.
- Reports from any data source including JDBC, XML, CSV, Hibernate, POJO.
- Reports published in PDF, XML, HTML, CSV, DOC, ODT.
Ad Hoc Reporting
- Web-based, drag-and-drop report designer.
- Crosstabs, tables, and chart-based reports.
- Semantic layer against relational or non-relational data sources.
Advanced analytic functions
- Ability to analyze data across multiple attributes and time periods.
- Multidimensional Expression Language (MDX) support lets users run complex analytic queries.
- Addition of calculations at runtime or within the relational OLAP model.
Interactive user interface
- Intuitive web-based interface lets users drill down, drill across, drill up, filter, pivot, sort, and chart.
- Ability to use MS Excel as a front-end client to your OLAP environment.
- Granular security access down to the cell and column level.
Performance and scalability
- Sophisticated caching of data and dimensions reduces query latency.
- Relational database storage architecture.
- Aggregate-aware architecture simplifies setup and improves user response times.
Graphical design environment
- Business-oriented models for early design collaboration.
- Drag-and-drop process designer.
- Activity monitoring console tracks job execution and performance.
Connectors
- Native connectivity to ERP and CRM applications such as Salesforce.com, SAP, and SugarCRM.
- Support for mainframe, transactional, and analytic databases.
- Connectivity to Hive for Hadoop environments.
ELT support
- ELT connector support for Oracle, DB2, Postgres, IBM/Netezza, EMC/Greenplum, Teradata, and SAP/Sybase IQ.
- Merge, filter and rollback functions.
- ELT template jobs for re-use.