RittmanMead BI Forum 2011 – Masterclass (Part II)

After the lunch, which was excellent by the way, Mark continued the Masterclass. Next on is the OBIEE11g – Server & RPD New Features. There are new features in the RPD which you should try yourself (including me), before you really can understand what is happening. The guys over at RittmanMead are decompiling .jar-files to make anything more clear! I guess I will start with the Admin-tool. A few highlights;

  • Column Descriptors –> Use the description to show, while in the background you use an Id (indexed) to ‘fire’ a query (Oracle Discoverer functionality)
  • Lookups Tables & Functions –> Interesting functionality Venkat already blogged about
  • Hierarchies (Ragged & Skip Level) –> Only use Ragged and Skip Level when you really need it, because it will generate complex queries to identify and it will be giving problems with generating MDX for Essbase.
  • Parent Child Hierarchies –> PC Aggregation is only aggregating for the member by default. You should do some extra modeling to bring the closure table into the model.
  • Oracle OLAP Option –> The BI Server now can manage navitve Oracle OLAP. As Mark mentioned; “A cautious welcome”

Tony closes the Masterclass whit the OBIEE11g – SOA Integration. New in Oracle BI 11g is the Action Framework. The Action Framework makes it possible to integrate your Business Intelligence System with your business process. Either by navigating through an url or by integrating with Web Services. Calling Web Services opens a whole new world for me. Now you see a further integration of Oracle BI 11g and Oracle Fusion Middleware. On the one end this Action Framework gives us a lot of new possibilities. On the other end it gets more and more complex. You should get to know a few of the following and more:

  • SOA Concepts
  • JDeveloper
  • BPEL Workflows
  • Oracle SOA

This way you should be able to integrate with external applications by building and deploying web services and invoke them from Oracle BI EE.

Thanks to Mark and Tony, they did a great job with this Masterclass. Although it seems like an information overload, both guys have presented a lot of information in such a way we do not have to be bored in the coming months.

Author: Daan Bakboord

I am an Oracle Business Analytics Consultant with great interest in anything closely related to the Oracle Business Analytics (OBIEE, BICS, Big Data, Data Integration, Data Visualization) .

2 thoughts on “RittmanMead BI Forum 2011 – Masterclass (Part II)”

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s