OBIEE Hybrid OLAP Reporting using MS Analysis Services & Oracle
One of our clients called me in today to run an OBIEE workshop. They have a number of Microsoft Analysis Services cubes that they’d like to report on using OBIEE, and if possible they’d like to combine this summary-level data with some more detailed data in an Oracle Database. I thought it was quite an interesting question and so I’ve put together a generic solution based around the Global Sample Schema.