Answer»
- 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.
|
