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.
Become a member of ODTUG to gain access to more than 12,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