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

• Enabling double columns

Introduction

Information access and presentation is the most visible component of the business intelligence and data warehouse project. It is important to understand the limitations of the software and the expectations of the consumers...