File Library


Reporting Against Transactional Schemas with OBIEE 11g
Topic: Business Intelligence Files
Owner: Stewart Bryson
Date: 2012-09-07
Subtopic: Webinar

Stewart Bryson, Rittman Mead Consulting

A common hurdle for new OBIEE environments is the seeming lack of support for transactional schemas as physical sources. Data structures are presented to Analysis developers as dimensions and facts, so a common misunderstanding is that the physical model must be a star schema.

This presentation will examine common techniques for modeling transactional schemas as logical facts and logical dimensions in the OBIEE Business Model and Mapping Layer. Some of the common techniques that will be introduced include: presenting a physical table as both a logical fact and a logical dimension, controlling the BI Server's behavior using table aliases and logical table sources, and integrating multiple source systems entities into the same logical table.

Download the Presentation here


Download File   2012-09-06 Reporting Against Transactional Schemas with OBIEE 11g Stewart Bryson.wmv

Become a member of ODTUG to gain access to more than 2,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database