- Substantially updated with expanded coverage of implementation methods for data storage, access, and calculation; also, new chapters added to combine OLAP with data warehouse, mining, and decision support tools
- Teaches the best practices for building OLAP models that improve business and organizational decision–making, completely independent of commercial tools, using revised case studies
- Companion Web site provides updates on OLAP standards and tools, code examples, and links to valuable resources
PART ONE: THE NEED FOR MULTIDIMENSIONAL TECHNOLOGY.
The Functional Requirements of OLAP Systems.
The Limitations of Spreadsheets and SQL.
Thinking Clearly in N Dimensions.
PART TWO: CORE TECHNOLOGY.
Introducton to the LC Model.
The Internal Structure of a Dimension.
Hypercubes or Semantic Spaces.
Physical Design of Applications.
PART THREE: APPLICATIONS.
Practical Steps for Designing and Implementing OLAP Models.
Introduction to the Foodcakes Application Example.
Purchasing and Currency Exchange.
Materials Inventory Analysis.
FCI′s Sales and Marketing.
FCI′s Activity–Based Manegement.
A Computational Example.
PART FOUR: FURTHER ISSUES.
Product Language Comparisons.
Appendix A: Formula Index.
Appendix B: Standards in the OLAP Marketplace.
Appendix C: LC Language Constructs.
Appendix D: Glossary.
Appendix E: The Relationship Between Dimensions and Variables.
Appendix F: Toward a Theoretically Grounded Model for OLAP and Its Conection to the Relational Model and Canonical Logic.
Appendix G: Codd′s 18 Features.