EPM Dashboard and Reporting

Reporting Vs Dashboards

" A report is a document containing informationorganized in a narrative, graphic, or tabular form,prepared on ad hoc, periodic, recurring, regular, oras required basis."

" A dashboard is a visual display of the mostimportant information needed to achieve one ormore objectives which fits entirely on a singlecomputer screen so it can be monitored at aglance."

Reporting Tools:

• Hyperion Financial Reporting Studio (HFR)
• Hyperion SmartView
• Oracle Business IntelligenceEnterprise Edition (OBIEE)
• Oracle Enterprise PerformanceReporting Cloud Service (EPRCS)
• CXO - Cockpit

Hyperion Financial ReportingStudio (HFR)

• Tool for designing and presenting analytic data graphically
• Object oriented graphical report layout using: Text Boxes, Grids, Images,and Charts
• Integrates with HFM, Hyperion Planning, and Essbase
• Objects can be used across multiple reports
• Report build performed on the Win32 client
• Report output available in HTML, PDF and XLS

Hyperion Smart View

Smart View allows users to view, import, manipulate, distribute and share datafrom various data sources using Microsoft Excel, Word, Outlook and PowerPoint.

• Tool for designing and presenting analytic data graphically
• Object oriented graphical report layout using: Text Boxes, Grids, Images,and Charts
• Integrates with HFM, Hyperion Planning, and Essbase
• Objects can be used across multiple reports
• Report build performed on the Win32 client
• Report output available in HTML, PDF and XLS

Typical uses include: Ad-hoc analysis Formatted reports based onformulas Data Form review/ submission Review HFR Reports Journal Entry submission	Data Integration with: HFM Essbase Hyperion Planning FCM HFR PBCS EPRCS

Smart View Ad Hoc:

Dynamic data analysis utilized toperform queries

• Drill into dimensions
• Utilize Excel formulas
• Can Pivot data betweenRows/Columns

Smart View Formula Reports

Best when used with HFM. May be used withEssbase/Planning but may have performance issues

• HS Function retrieves data from source
• Manual Data Entry

Smart View Data Forms

Best when used with HFM. May be used withEssbase/Planning but may have performance issues

• HS Function retrieves data from source
• Manual Data Entry

OBIEEE

Oracle Business Intelligence Enterprise Edition (OBIEE) is a package of reporting and analytics toolsthat provides a robust and scalable solution for providing insight into the reality of your business.

• Connects to nearly any source
• Queries relational databases, data cubes, flat files, big data sources and many other technologies
• Provides historical, real time, and predictive analytics capabilities
• Integrates with a wide variety of technologies including Oracle's CRM, E-Business Suite, andHyperion Platforms
• Oracle sells pre-packaged applications that contain out of the box integrations with Oracle productslike CRM, E Business Suite and Hyperion tools

OBIEE Dashboards

Flexible reporting with a wide variety of visualization options

OBIEE Reports Creation

Flexible reporting with a wide variety of visualization options

• Logical data model is stored in ametadata repository to limit theamount of technical details a userneeds to be successful and isorganized by subject area
• Available attributes listed on theleft, selected items appear on theright, as well as filter conditions
• Supports SQL calculations andcommands (Case Statements,statistical functions, etc)

Enterprise Performance Reporting Cloud Service (EPRCS)

• Distribution: Users simultaneously updating different sections / doclets of reports
• Task Management: Notification of upcoming deliverables / alerts
• Reporting: External, Internal and Statutory Financial Reporting Needs
• Complete: Authoring, collaboration, commentary and delivery, including versioning
• Workflow: Approve reports sections and overall monitoring of the process
• Secure: Role-based, auditable access on desktop and mobile devices
• Integrate data and Metadata from various Oracle and non-Oracle sources (EPM, BI,ERP, OBIEE, RDBMS, Microsoft - utilizing Smart-view): can build an application inERPCS to bring in dimension / data or go directly to the source depending onscope

Related Links

Case Studies