Posted by: michaelverzijl | 03/10/2011

Review Session Day 1: Oracle Open World

Today was the first real Oracle OpenWorld today. After flying to San Francisco and biking the GolgenGate bridge it’s time for some real action!
Overal this was a very nice day with lot’s of new info and not good for my todo list…


Session 1: IOUG: Fast Complex BI Analysis with Oracle OLAP
Presented by Dan Vlamis

In this session Dan introduced the usage of Oracle OLAP:
Oracle OLAP can be used as a summary based management solution. In this solution it can replace multiple materialized views by one cube.
An Oracle OLAP cube is generated by Analytics Workspace Manager (AWM). Furthermore multiple levels are stored inside a cube.

Oracle OLAP doesn’t use the aggregate functions provided inside an Oracle database, but used it’s own aggregate functions.
The functions can be faster than the aggregate functions.

One of the tools is Simba that enables fast and secure analysis of Oracle OLAP data in Microsoft Excel.

In a lifecycle of a report you can see the following pattern:
• Prototype in report (single usage of metric)
• Move the metric for reusability to a middle tier solution (RPD)
• Move the metric for performance to Oracle Database (OLAP)


Session 2: IOUG: Oracle Business Intelligence Enterprise Edition 11g Architecture and Internals
Presented by Mark Rittman

Mark introduced the audience to the architecture of OBIEE 11g and compared the solution with the 10g architecture.
By comparing these 2 architectures you can see the difference 11g provides in the tooling. The functionality is still the same but it’s integrated in Oracle FMW.

Furthermore Mark mentioned a detail on the “upcoming release” of OBIEE (not yet planned). This is the support of IBM Websphere to replace Oracle FMW.
By adding this support more customers can be attracted to OBIEE.

One thing that should not be forgotten is that if you cluster OBIEE, you need a separate license for Weblogic.


Session 3: Oracle Business Intelligence 11g Action Framework: Basic to Advanced Integration
Presented by Christian Screen (artofbi.com)

Christian talked about the Action framework provided inside OBIEE 11g. In this session he talked about extensions for OBIEE write in JDeveloper.
Furthermore you can have 2 kind of actions:
• Named: unique for report
• Inline: object in webcat and can be reused in several reports

One nice feature was the Metadata Search Tool. This is a custom extension to OBIEE where you can search your dimensions/facts for certain columns.
A nice tool to further look into (making a note to myself)


Session 4: Upgrading Your Oracle Business Intelligence Enterprise Edition Software?
Presented by Kevin McGinley

Kevin didn’t discuss the upgrade procedure, but focused on the added value that can be provided by using OBIEE 11g vs OBIEE 10g.
He had some nice demo’s prepared to show the audience the differences between 10g and 11g:
• Better charts
o Scrolling and zooming on charts
• Dashboard
o Prompt / checkbox prompts / pivot tables
• BI Publisher
o Fully integrated with OBIEE
• Geographical
o Mapviewer integration (showing data on maps)
• Tablet
o Full version of OBIEE on the iPad.


Session 5: Oracle Business Intelligence Deployment and Change Management Best Practices
Presented by Mark Rittman

Mark provided a good presentation about the steps you need to think about when implementing new projects in your BI environment
You need to think about the following subjects:
• Oracle BI Repository (RPD file)
• Oracle BI Presentation catalogue
• System Configuration Settings
• UI Customizations
• Security artifacts
• Associated database schemas, ETL packages

Furthermore the latest release of OBIEE (11.1.1.5) can support up to 5 users for online editing the RPD.
If you get the error about Transaction Update failure you need to apply a patch to OBIEE (Patch 9884975)

Merging repository
It’s a 3 way merge where you need the following RPD’s:
• Modified – Production
• Current – Development
• Original – The one that was used to build the Modified/Current version

It’s important that, before you merge the RPD, you equalise the RPD. In this phase the internal ID’s are updated.

Furthermore you can patch de RPD and catalogue with a patch file:
• Make XML file
• Apply XML file to production environment

This can be scripted so that this can be done automatically:
• Comparerpd -> generate patch file
• Patchrpd -> apply patch to RPD

An important subject that’s missing in the current OBIEE release is Version Control.
Mark suggested a method of using Subversion as your Version Control.

Multi-User Development
• Has been improved a lot in latest release
• You can work offline with RPD to test
o Make sure you have a user plus license to work in a Sandbox mode

See for the complete presentation:
http://www.rittmanmead.com/files/oow2011_rittman_chgmgmt.pdf


Session 6: Oracle Business Intelligence Metadata Development: Advanced Solutions and Concepts
Presented by Jeff McQuigg

In the session Jeff provided a number of solutions for common errors:
• Putting attributes in a fact table
o Model the fact as a fact and the attributes as a separate dimension
• Dimensions and facts work together
o It’s important to look at the grain of the fact/dimensions
• Non-comfirmed dimensions:
o Create a fake join between a fact and dimension if the are not linked
 Be aware of the cartisian join affect
o Add a level based metric
• Canonical Time
o Make one time dimension and link to this dimension multiple times trough aliases from the fact
• LTS selection
o Certain number of rules apply (note to myself)
o In 11g Priority group is added


Session 7: Why Data Vault?
Presented by Kent Graziano

Kent provided a solution by filling in the Foundation Layer in Oracle architecture for Data vault (data modelling technique)
Data vault is a technique where you create Hubs, Links and satellites.

With this technique you can:
• Be more flexible
• Be scalable
• Be productive

In generating the logic the business key is the most important and you provide your logic on this key.
On rapidace.com you can see a tool to transfer a Star model to a Data Vault model.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

Categories

%d bloggers like this: