OLAP Solutions
Building Multidimensional Information Systems
2nd Edition
Published on 1. October 2002
688 pages
978-0-471-26625-9 (ISBN)
Description
OLAP enables users to access information from multidimensional datawarehouses almost instantly, to view information in any way theylike, and to cleanly specify and carry out sophisticatedcalculations. Although many commercial OLAP tools and products arenow available, OLAP is still a difficult and complex technology tomaster.
* Substantially updated with expanded coverage of implementationmethods for data storage, access, and calculation; also, newchapters added to combine OLAP with data warehouse, mining, anddecision support tools
* Teaches the best practices for building OLAP models thatimprove business and organizational decision-making, completelyindependent of commercial tools, using revised case studies
* Companion Web site provides updates on OLAP standards andtools, code examples, and links to valuable resources
More details
Other editions
Additional editions
Book
04/2002
2nd Edition
Wiley
Unfortunately, price unknown
Article exhausted; check different version
Person
ERIK THOMSEN (ethomsen@dsslab.com) is Chief Scientist at DSS Lab, Inc., where he consults on the design and implementation of OLAP-based decision support systems, teaches at corporations and universities, and conducts research in the field of unified information systems. He also writes the "Analytic Solutions" column for Intelligent Enterprise. He is a coauthor of Microsoft OLAP Solutions (Wiley).
Content
Preface.
Acknowledgments.
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.
Multidimensional Formulas.
Links.
Analytic Visualization.
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.
Multidimensional Guidelines.
Product Language Comparisons.
DSS Fusion.
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 andVariables.
Appendix F: Toward a Theoretically Grounded Model for OLAP and ItsConection to the Relational Model and Canonical Logic.
Appendix G: Codd's 18 Features.
Notes.
Bibliography.
Index.
