Chapter 13. Optimizing the Access

The business intelligence and data warehouse solution culminates in the presentation of information to stakeholders. This component of the solution is most visible to stakeholders and represents all the work done within the project. It is the key to presenting information in an accurate, easy to use, and visually correct way which is customized to your audience. The following recipes touch on a few of these subjects:

  • Developing your standards and guidelines
  • Abstracting your tables using aliases
  • Developing level-based hierarchies
  • Creating multi-table hierarchies
  • Consolidating reports using the column selector
  • Enabling dynamic column headings
  • Enabling dynamic descriptions
  • Enabling multi-language for the shared captions ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology 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.