Advanced Repository Modeling Concepts
In the “Creating a Repository” example in this chapter, we looked at creating a simple business model from a single data source that was organized into a star schema with simple, balanced, level-based hierarchies. This is the most straightforward type of data source to model against, and if possible you should work closely with the data warehousing team within your organization to ensure that the data source for your BI system is a single, conformed, dimensional model, as this makes your job easier and also maximizes the performance of your system.
Real life often is not as simple as this, though, and you may instead have more than one dimensional data source to work with (for example, a set of departmental ...
Get Oracle Business Intelligence 11g Developers Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
