DATAWAREHOUSE CONCEPTS: Hyperion

Showing posts with label Hyperion. Show all posts

Wednesday, 22 August 2012

Hyperion Web Analysis

Is a module of Oracle Business Intelligence Suite Enterprise Edition Plus
Is a context driven, thin client reporting and analysis tool
Is a “report centric” query and reporting tool
Delivers out-of-the-box presentation and reporting for Oracle [Essbase] and other multi-dimensional sources.
Delivers powerful, intuitive, Web-based interactive analytics to all corners of the enterprise.
Highly graphical and easy-to-use interactive interface
Enables users to view their data in a way that makes sense to them.
Enables the graphical interaction, presentation and reporting of multi-dimensional (OLAP) data.
Transforms data from heterogeneous sources into meaningful queries, dashboards and reports by connecting to Oracle BI Server or direct connection to underlying databases as needed.

Hyperion SQR (Structured Query Reporter )Production Reporting

Provides cross functional reporting from a variety of relational databases and data sources.
SQR (Hyperion SQR Production Reporting, Part of OBIEE) is a programming language designed for generating reports from database management systems
Oracle Hyperion SQR Production Reporting (SQR Production Reporting) software is a module of Oracle Business Intelligence Suite Enterprise Edition Plus
Generates high volume, presentation-quality and pixel-perfect reports with unparalleled performance regardless of the spanning multiple enterprise data sources including SAP R/3 and SAP Business Information Warehouse

Hyperion Interactive Reporting

Is a module of Oracle Business Intelligence Suite Enterprise Edition Plus
Pulls data together from operational or analytic sources to create charts, privots, and reports and can access the Oracle BI Server semantic layer.
That provides executives, business users, and analysts with intuitive user-directed relational query capabilities. From interactive dashboards in a readily available context, to complex data modeling for fully ad hoc access to source data
Can pull together data from disparate sources to produce easy to use charts, pivot tables, highly formatted reports, and more.

Hyperion Financial Reporting

a reporting solution for multidimensional data (OLAP)
supports a variety of sources including Oracle's Hyperion performance management applications (EPM) and Oracle Essbase.
provides conditional suppression and automatic calculations that can be used to focus and filter reports.
A graphical, object-based interface enables the rapid creation of reports that combine grids of data and text, charts, graphs, and images.
Generates highly formatted, GAAP(Generally Accepted Accounting Principals) compliant, book quality financial and management reports
Supports the emerging XBRL(eXtensible Business Reporting Language) standard.

The components of OBIEE include