By Rob Reynolds on Apr 30, 2014
Integrating HTML5 Maps
Leveraging ADF Visualizations
Join us on Tuesday, September 10 at 1pm EST / 10am PST to learn about the latest innovations in business analytics and how to modernize your current BI environment.
Find out how to:
This is a very exciting and cool new product that I have been beta testing for a few months now. The Mobile BI Application Designer lets business users easily create interactive, mobile BI apps that work on any mobile device. This new feature of OBIEE requires an upgrade to 220.127.116.11 and then 3 additional patches. Full docs of the installation process are on the OTN link above.
Join us for an interactive webcast on using Spacial Analysis with Oracle BI. Oracle experts will show how to perform predictive analytics, network analytics and spatial analysis – combined together, in real-world scenarios.
This webinar is appropriate for anyone involved in the design and management of analytic applications and solutions where spatial analysis can add insight and value to business processes.
Date: Thursday, November 29th, 2012, 2PM EST/11am PST
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:
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 http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
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.
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!
As of last night, Oracle Business Intelligence Foundation Suite 18.104.22.168.2 BP1 is now generally available via support.oracle.com.
The new Oracle BI Mobile HD client is compatible only with this new server release, and is available at http://itunes.apple.com/gb/app/oracle-business-intelligence/id534035015.
Although there are significant features in this release, it is delivered as a bundled patch set exclusively from support.oracle.com. Install BI Foundation Suite 22.214.171.124.0 first, then follow the instructions in knowledge article “How To Apply The OBIEE 126.96.36.199.2 Roll-Up Patches [ID 1459232.1]”.
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.
Drilling into various Sales Rep values shows the organization reporting hierarchy.
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.