Contact us at +1.415.901.7500 or contact@itconvergence.com

Analyzing the Enhancements in Oracle BI Suite

Analyzing the Enhancements in Oracle BI Suite
Every industry veteran knows the old adage that an ERP system is only as strong as the reporting solution backing it up. And that remains true in 2013. As part of our Collaborate 13 outreach efforts, our bloggers have been busy scouring the sessions for the latest on Oracle Business Intelligence and Oracle E-Business Suite reporting.This morning, we’re happy to provide you with the latest on Oracle BI Suite.

Enhancements in Oracle BI Suite

Oracle BI Suite now provides several enhancements on under following categories:

1. User experience and Data visualization enhancements :

a) View recommendation feature allows suggestion/guidance on data and the intent of analysis.
b) Other visualization component added or enhanced are performance tiles on dashboard, Waterfall graph, map views, a sub type for 100% stacked chart, non-null data suppression feature to display this data, breadcrumbs for navigation, context based trellis view actions on links.
c) Freeze Headers. Used in tables, pivots, and Advanced Trellis views, keeps the headers positioned at the top of the view, even as a user scrolls down. This feature can be switched on or off for a particular view from the properties panel of the view. This feature is also available on Oracle BI Mobile HD  application by two finger swipe gesture.
d) Integrating the Oracle Endeca Information Discovery Server: OBI server allows for a full-text search with the option to filter the search results. Endeca can also use oath and JSON to import data from social media sites and running sentiment analysis. Endeca can be connected to BI server to pull data from Oracle Business Intelligence Server with the help of new driver.

2. BI Server enhancements :

a) Hadoop Integration : The new release of Oracle Business Intelligence supports accessing Hadoop via a Hive ODBC interface. This eliminates the need to write
complex and time consuming MapReduce programs; the Oracle BI Server can now directly issues commands to Hive to query and fetch data from Hadoop data sources.
b) Advanced and Predictive Analytics. OBI Dashboards and prompts can run Oracle R for Enterprise (ORE) scripts that perform complicated statistical analyses, and Oracle Data Mining algorithms and cluster analysis, and visualize the data set as interactive images embedded in Dashboards.
c) Model Checker: The Model Checker can check the metadata repository in online mode and flag any potential issues it identifies for remediation.
d) BLOB Data Display:  Support for BLOB allows for images to be displayed alongside data, maps, and graphs in reports.
e) Essbase Integration –Oracle BI and Essbase can be installed by a single installer and share a common Fusion Middleware security model with management using Oracle Enterprise Manager. Essbase can be used now as Aggregate Persistence target for data.
f) Export Dashboards & Dashboard Content: Users can export reports in native Microsoft Excel and PowerPoint formats.

3. Enterprise Reporting Data Sources Enhancements.

a BI Publisher can now connect to Oracle Endeca Information Discovery data store. Users can now define Endeca Query Language based queries to retrieve the data from the Oracle Endeca Server to use in BI Publisher reports.
b Users can leverage locally stored or shared XML or CSV files as data sources.
c Private ODBC or JDBC data source connections can also be created to be used in data sets.
d Users can also use MDX queries against OLAP data sources such as Essbase cubes that return multidimensional cell sets that contain the cube’s data. Furthermore, users have the flexibility of either manually entering the MDX query or using the MDX Query Builder to build the query.

4. Integration of Oracle BI with Oracle Hyperion Smart View for Office

a Using Smart View as the primary application for integrating with Office is now recommended.
b BI Presentation Catalog in Smart View. Smart View now fully supports BI dashboard page and report prompts with single sign on for security.
c BI View Creation in Smart View. Using the Smart View add-in, users can create views directly from Excel. Users can then choose to save this view either in Excel or as a view in their catalog.
d The Oracle BI data in Smart View is also accessible to other Smart View providers like Oracle Hyperion Planning, Oracle Hyperion Financial Management, and Oracle Hyperion Disclosure Management.

Stay Up to Date with the Latest Oracle Functional and Technical News from Collaborate 13

Remember to check our Collaborate 13 thread regularly as updates will be made throughout the show. This afternoon we’ll be publishing something on data compression in Oracle Databases so stay tuned.
Follow Collaborate 13 as it happens. Click here to access the full stream of this blog’s Collaborate 13 conversation.