The new Oracle Business Intelligence Enterprise Edition (OBIEE) sample application (V305) is now available as of June 12, 2013. The new sample application does a good job at displaying all the latest and greatest features of OBIEE 11.1.1.7.0. As with the prior release, the sample application is now deployed only on Oracle Virtual Box (OVB) – and there is no longer an option to deploy directly on your machine (well, not without a lot of manual effort!). Having said that, this blog post summarizes the highlights of what is available for the OVB deployment of the OBIEE Sample App.
Application Versions
- OEL 5.9 64bit
- OBIEE 11.1.1.7 Enterprise install
- Oracle Database 11.2.0.3, AWM 11.2.0.3.0,
- APEX 4.2 & APEX Listener 2.0
- ORE 1.3 & R-2.15.1
- ENDECA 3.0, EID Studio
- EPM 11.1.2.2 plug and play companion
- Utils : Start Scripts, Map Builder 11ps5 ,
- SQLDev 3.2.20
Deployment and Scalability
- A 64-bit enterprise install (finally!)
- Auto IP recognition
New Display Features
- Interactions
- Breadcrumbs
- Smart View Integration
- All new standard Views (Performance Tiles, Waterfall Charts)
- New print and dashboard layout options (“freeze panes” for dashboards)
- Map lines, map targets, non-BI layers…and more
- Blob images content integration
- Mobile-optimized pages
BI + Essbase Integration
- Provides the ability to spin off Essbase cubes from a dashboard
- Direct calc script/MaxL running and creation using Action Framework
- Direct contextual write-back to an Essbase cube from OBIEE using Action Framework
- Essbase as a target for the Aggregate Persistence wizard
- Dynamic selection of Essbase aliases in the RPD
OBIEE Custom Function Interactions
- JS additions to Userscripts.js
– AF Launch of Contextual LSQL or ODBC procedure (clear cache, write back, etc.)
– Popup contextual drilling from any report
– Fully source OBIEE from any web service
– Leverage UTL_HTTP database, within/outside same Origin Policy - Actions leveraging OBIEE Go URLs
– Running BI contextual searches from any report (what to search, where to search, etc.) - Other custom dashboard JSs
– Incrementally update/edit presentation variables
– Collapse or expand all dashboard sections on a page - Custom Java program utilities
– Concurrency simulation (monitor system while large volume of users/sessions/reports are multithreaded on it)
– Physical SQL Generator (generate all your physical SQL without hitting your databases)
BI + Db Advanced Analytics
- OBIEE end users can seamlessly leverage database capabilities
- Frequent Itemset (native market basket analysis capability)
- ‘Model’ clause calculations to project future values
- Source OBIEE from any web service using Db UTL WS capability
- OBIEE interacts with Spatial NDM (Network Data Model) via WLS servlet
- OBIEE explores huge data with Db Descriptive Analytics, including configuring report-to-DB interaction for interactive and performant analysis on Bns of rows (granular source)
BI + Oracle R Enterprise (ORE) Integration
- OBIEE CEIM consumes ORE result sets as a data source
- OBIEE natively exposes ORE formats such as tabular, png, BLOB and XML
- Author ORE scripts directly from the OBIEE dashboard with no RPD interaction
- Dashboard end user transparently consumes ORE analysis and visuals
- ORE runs analysis on OBIEE Common Enterprise Information Model (CEIM) via JDBC
BI + Endeca Integration
- Integrates Endeca + Dashboard, with OBIEE interacting/drilling directly into Endeca
- Endeca directly sources OBIEE WebCat and RPD
- Includes Endeca 6M Rows+ Airline demo application
- OBIEE sends EQL results via JS connection to Endeca WS
BI + EPM/FR Integration
- Installs default EPM
– Includes Essbase Server, EAS, EIS, APS, Studio, FR, EPM Workspace
– Starts automatically with OBIEE startup, with minimal system overhead - Financial Reporting Studio enabled to:
– Run against OBIEE Essbase installation
– Webcat-stored FR reports example, with an embedded dashboard - Standalone EPM “tar” available as plug and play into SampleApp V305
– Includes Foundation Services, full Workspace, Oracle Planning, FR, APS and Essbase
– Can easily be expanded to more EPM web applications
BI 11.1.1.7 Large Dataset-Enabled
1. Medium-sized schema BISAMPLE_EXA
- Generic 5M rows fact, ~800MB
- Dense dimensionality: 10k Cust x 200 Prods x 200 Empl x 20 Offices x 3 Yrs
- OOB comes with:
– ORCL Granular Schema,
– ORCL Aggregate Schema (and scripts)
– Essbase Aggregate Cube (and scripts)
– Enhanced Turnkey Data Inflator Scripts to massively grow the data
2. Medium-sized schema BI_AIRLINES
- “Real life” 6.3M fact rows, 5.5GB
- Dimensionality: 7k Flight# x 5k Air Routes x 20 Carriers x 1 Yr
- OOB comes with:
– ORCL Granular Schema
– ORCL Agg Schema (and scripts)
– TT Agg Schema (and scripts)
– ESSB Agg Cube (and scripts) - Can be swapped with actual Exalytics Airline demo dataset (130MRows, 15 GB)
Author: John McGale, Performance Architects