Wednesday Aug 08, 2012

Webcast: Analytics at the Speed of Thought

Event Date: Thursday, August 23, 2012
Event Time: 10 a.m. PT/1 p.m. ET

Join this Webcast and learn how you can manage your business smarter and faster with the Oracle Exalytics In-Memory Machine – an industry first. In this briefing, you’ll hear how organizations like yours are embracing Oracle Exalytics to plan, monitor and make decisions at unprecedented speed.

You’ll gain valuable information and practical tips on how to:

  • Support exponentially growing data volumes and user populations
  • Run business intelligence and analytic applications faster than ever before
  • Enable business users to interact with data, visualize it, and discover new insights
  • Forecast and plan more frequently, and at greater levels of detail
  • Enable mobile intelligence across your organization

Balaji Yelamanchili – Senior Vice President of Analytics and Performance Management, Oracle
Paul Rodwick – Vice President, Product Management, Oracle Business Intelligence, Oracle

 Click here to register.

Friday Jul 27, 2012

New OBIEE Sample App Available (

A new version of the OBIEE Sample Application is now available on the Oracle Technology Network. The Sample Application (SampleApp) for Oracle Business Intelligence Suite Enterprise Edition Plus (EE) is a comprehensive collection of examples designed to demonstrate Oracle BI capabilities and design best practices.

As with the previous version, this release is available as a Virtual Box image, providing a turnkey environment for testing and exploring OBIEE. 

Key new features of the sample app include:

  1. Exalytics Features - Exalytics configurations, aggregate navigation, Summary Advisor, & advanced visualizations are enabled in this stand-alone VM environment.  This allows you to test and evaluate the advanced features available in Exalytics.
  2. Lifecycle & Administration Examples - Enhanced examples for Webcat monitoring and maintenance, enhance user testing, query analysis & database monitoring examples.
  3. New Content & Visualization Examples - New visualization examples, a new BIP example application, and a new example dataset and application for analyzing US Flight Delay information.

You can see the scale of the changes and new content in following graphic shows the Index of the new Sample app, with all the new content highlighted in Red.  A full list of changes is available on the OTN site link below.

You can download the new sample app from

The SampleApp contents and its code are distributed free for demonstrative purposes only. It is neither maintained nor supported by Oracle as a licensed product.

Thursday Jul 19, 2012

Custom Styles & Skins for OBIEE 11g

This is a topic that has been coming up more and more in conversations with customers.  Mainly, customers looking to define a lightweight style for mobile specific dashboards.  There is a detailed whitepaper that was released a while back with specifics on the modification and customization of your OBIEE 11g deployment.

Another excellent resource is this Oracle by Example tutorial - Creating and Deploying Custom Styles, Skin, and Messages in Oracle BI EE 11g

Both resources should get you going, but if you need additional assistance, Oracle Consulting is always ready to assist!

Saturday Jun 30, 2012

OBIEE Released!

As of last night,  Oracle Business Intelligence Foundation Suite BP1 is now generally available via

What’s New?

  • Oracle BI Mobile HD.  New iPad client and accompanying server support.
  • Quick Access User Experience: The Oracle BI Mobile app has been completely redesigned to make it easier for users to quickly access information they most often need. Live thumbnails enable faster discoverability of content, while a re-designed search interface searches across offline and online content.
  • Greater Interactivity: Touch and gestures are the primary way of interacting with content on tablets like the Apple iPad. The new release of the Oracle BI Mobile app makes it easier than ever before to use touch and multi-gestural interactions to work with BI content. With this release, users can take advantage of new gestures to interact with business intelligence information, including using the one-finger swipe, two-finger pinch, tap-and-hold, and tap-and-drag gestures.
  • Offline Access: In this version, Oracle BI Mobile enables always-available analytics to users.  Content can be saved for offline viewing and consumption and refreshed when back online.  A fine-grained security privilege allows administrators to grant or revoke the ability to save offline content for specific users or roles or groups.

The new Oracle BI Mobile HD client is compatible only with this new server release, and is available at

Although there are significant features in this release, it is delivered as a bundled patch set exclusively from  Install BI Foundation Suite first, then follow the instructions in knowledge article “How To Apply The OBIEE Roll-Up Patches [ID 1459232.1]”.

Thursday May 17, 2012

Webcast: Building Next Gen Big Data Architecture

Here's a great upcoming webcast we are sponsoring with InformationWeek on building next gen Big Data architectures on Thursday, May 24th. 

How to Build a Next-Generation Big Data Architecture

Date: Thursday, May 24, 2012
9:00 AM PT / 12:00 PM ET
60 minutes

You may have heard enough about big data to know what it is, but what does a big data solution architecture really look like? In this webcast we will take a closer look at a real big data use case and examine the architecture, data sources and various software components required to actually implement the solution. We'll show you what your infrastructure needs to look like to acquire, organize and analyze big data, so that you can make business decisions that maximize the value of big data.

Be sure to pre-register for this free event here.

Friday Jan 13, 2012

Big Data Appliance Now Available

Earlier this week the Oracle Big Data Appliance and Oracle Big Data Connectors were made generally available.  This means you customers can start placing orders for these great new products.  We also announced a new a partnership with Cloudera.

Head over to the Oracle Data Warehouse blog for more details. 

Press Release: Oracle Announces Availability of Oracle Big Data Appliance

Press Release: Oracle Selects Cloudera for Apache Hadoop Integration Into Oracle Big Data Appliance

Wednesday Sep 21, 2011

Oracle EPM & BI Consulting at OOW 2011

Oracle OpenWorld 2011 is almost here.  Here's a quick update on how you can interact with Oracle Consulting's BI & EPM experts while at the conference. 

This year, the Oracle Consulting Solution Center moves to Moscone West, Lobby Level 3.  You can stop by and to schedule one-on-one's with Oracle Consultants and Architects to discuss any variety of topics. Please stop by and schedule an appointment if you would like to discuss specific BI or EPM topic with me or one of our other EPM/BI architects.

Consulting Center Hours
Mon, 9/20, 9:45 am - 5:30 pm
Tues, 9/21, 9:45 am - 5:30 pm
Wed, 9/22, 9:00 am - 4:00 pm

In addition to presenting at 3 sessions, we will also be hosting a Demopod demonstrating our Migration Factory tools for helping move customers from legacy or competitors technology to Oracle technology.  Specific BI topics featured at this pod will be Teradata to Exadatamigrations as well as BI migrations from legacy Oracle/Hyperion tools and SAP BusinessObjects to OBIEE.  The Migration Factory DemoPod will be located in

I will be presenting in 1 session this year and we have several of our top architects presenting as week.  Here are our sessions:

Title:  Infrastructure Considerations of a Large Oracle Hyperion Financial Management...

Schedule: Tuesday, 03:30 PM, St. Francis - Elizabethan CD  (OCS Presenter - Karen Munoz)

Abstract: Johnson Controls is a global diversified technology and industrial leader focused on optimizing energy. A former Hyperion Enterprise customer, it embarked on an aggressive project to move its 2,500 Hyperion Enterprise users in 60 countries to Oracle Hyperion Financial Management over the course of one year. The presentation highlights lessons learned on one of the world's largest Oracle Hyperion Financial Management implementation projects as well as practical perspectives on hardware and infrastructure sizing, high availability, performance tuning, and monitoring and maintaining a high-performing team.


Title: Enterprise Analytics with Oracle BI Apps and Oracle Business Intelligence Enterprise Edition

Schedule:   Wednesday, 10:15 AM, InterContinental - Telegraph Hill- (OCS Presenter - Rob Reynolds)

Abstract: Oracle's prebuilt, cross-functional business intelligence (BI) applications provide the optimal decision platform for enterprisewide analytics required to help business make better, more informed decisions. In this session, learn how to use Oracle Business Intelligence Applications and the power of Oracle Business Intelligence Enterprise Edition 11g to visualize and drive operational as well as strategic decisions across your business. See how Oracle's lifecycle services portfolio can help you leverage your existing IT investments to accelerate the delivery of business analytics and deliver smarter, more agile decision capabilities.


Title: Budgeting & Report with Oracle Hyperion Planning and Oracle Essbase in a SAP Environment

Schedule: Wednesday, 05:00 PM, St. Francis - Elizabethan CD (OCS Presenter - Buland Chowdhury)

Abstract: See how Astra Zeneca uses Oracle Hyperion Planning and Oracle Essbase to budget and report in a complex environment that aligns three operating units yet provides flexibility for business rules to differ. This multiapplication design accommodates sales to gross margin, extensive dimensionality for expenses, labor planning, currencies, capital, balance sheet, and more. It also provides a consolidated and robust reporting tool with many years of data and interfaces with a customized SAP system, among others. Hear tips for managing multiple stakeholders with different businesses and executives within one platform. The presentation includes business resolutions and benefits, project timeline, architecture, customer testimonials, and more.

Tuesday Jun 28, 2011

Coming to a City Near You: Oracle Business Analytics Summits

Oracle invites you to join us for an information-packed event where you’ll learn about the latest trends, best practices, and innovations in business intelligence, analytic applications, and data warehousing.[Read More]

Monday Jul 05, 2010

OBIEE 11g New Feature - Hierarchy Columns

Although OBIEE 11g won't be launched for a few days, I'm going to start giving you a sneak peak at some of the features of the upcoming release. I've enlisted the help of some of our top OBIEE consultants who have been working with the product and Oracle Development for a while now.

Sharing his thoughts on the new Hierarchy Columns in this post is guest blogger Doug Ross. Doug is one of our top OBIEE consultants and is a 15 year Oracle veteran.

OBIEE 11g Hierarchy Columns

by Doug Ross

OBIEE 11gR introduces the concept of a “hierarchical column” which allows for encapsulating the presentation of a dimension hierarchy in an Answers analysis report within a single column. The advantage of the hierarchical column is that it offers a better user experience in navigating within a hierarchy.  

In prior releases of OBIEE, navigating through a dimension hierarchy was limited to drilling down from one level to the next which added new columns to the output. For example:




Clicking on the Type of column header results in adding a new column, "Brand", to the results.

This drilling behavior is still available within OBIEE but OBIEE 11g provides a more powerful method for interacting with the hierarchy by offering the ability to expand and collapse individual levels within the same report column using the plus (+) and minus (-) icons adjacent to the displayed member values.



This screenshot shows how the user selects a hierarchical column in OBIEE 11g Answers. Notice the new icon for the hierarchy column type.



Here are some sample screenshots of the hierarchy column in various states of expansion. Notice how all the drilling occurs within the same column.




There are two basic types of hierarchical columns: level-based and value-based. As with OBIEE 10g, the hierarchies are configured in the Business Model and Mapping layer of the OBIEE repository (RPD) using the Administration tool. The hierarchies can then be exposed within Subject Areas in the Presentation Layer.

A level-based hierarchy follows the general style where a dimension column serves as the parent to a different child level column. The product hierarchy in the examples shown above would be an example of a level-based hierarchy.

A value-based hierarchy uses the same dimension column for all levels but relies on other structures in the data model to identify the parent-child relationship. A good example of a value-based hierarchy would be within the employee dimension where the manager to staff relationship exists.

In the screenshot below, the Sales Rep Hierarchy is added to an analysis. The same Sales Rep column is used for all levels of the hierarchy and there are other data elements that define which Sales Rep reports to another Sales Rep.

Picture 7.jpg

Drilling into various Sales Rep values shows the organization reporting hierarchy.


Picture 8.jpg


As you can see, the new hierarchy column feature of OBIEE 11g provides a very powerful way to increase the usefulness of drilling within an Answers analysis view.


Focusing on implementing successful Analytics solutions and the world of Oracle BI & EPM.

Rob Reynolds leads Oracle's Business Analytics Consulting organization in North America.

Our charter is to help customers successfully leverage their investment in Oracle software for maximum returns. We assist customers in developing BI & EPM strategies, implementation roadmaps , architectural services and full-life cycle implementations of Oracle BI, EPM & Analytics products.

Follow on Twitter - @RobReynolds

Learn more about Oracle Consulting.


« July 2016