OLAP Solutions: Building Multidimensional Information Systems / Edition 2

OLAP Solutions: Building Multidimensional Information Systems / Edition 2

4.0 1
by Erik Thomsen
     
 

ISBN-10: 0471400300

ISBN-13: 9780471400301

Pub. Date: 04/18/2002

Publisher: Wiley

OLAP enables users to access information from multidimensional data warehouses almost instantly, to view information in any way they like, and to cleanly specify and carry out sophisticated calculations. Although many commercial OLAP tools and products are now available, OLAP is still a difficult and complex technology to master.

  • Substantially updated with

Overview

OLAP enables users to access information from multidimensional data warehouses almost instantly, to view information in any way they like, and to cleanly specify and carry out sophisticated calculations. Although many commercial OLAP tools and products are now available, OLAP is still a difficult and complex technology to master.

  • 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

Product Details

ISBN-13:
9780471400301
Publisher:
Wiley
Publication date:
04/18/2002
Edition description:
REV
Pages:
696
Product dimensions:
9.25(w) x 7.50(h) x 1.45(d)

Table of Contents

Prefacexix
Acknowledmentsxxiii
Part 1The Need for Multidimensional Technology1
Chapter 1The Functional Requirements of OLAP Systems3
The Different Meanings of OLAP5
Where OLAP Is Useful6
The Distinction between Transaction and Decision Support Processing8
The Functional Requirements for OLAP18
Summary24
Chapter 2The Limitations of Spreadsheets and SQL29
The Evolution of OLAP Functionality in Spreadsheets and SQL Databases30
Proving the Point: Some Examples32
Summary44
Chapter 3Thinking Clearly in N Dimensions47
Lower-Dimensional Data Sets47
Beyond Three Dimensions51
Multidimensional Type Structures (MTSs)55
Representing Hypercubes on a Computer Screen57
Analytical Views64
Summary66
Part 2Core Technology69
Chapter 4Introduction to the LC Model71
Disarray in the OLAP Space73
Attributes of an Ideal Model82
Overview of the Located Content Model85
Summary92
Chapter 5The Internal Structure of a Dimension93
Nonhierarchical Structuring95
Dimensional Hierarchies107
Referencing Syntax115
Leveled or Symmetric Hierarchies118
Leveled Dimensions with Nominally Ordered Instances119
Leveled Dimensions with Ordinally Ordered Instances122
Leveled Dimensions with Cardinally Ordered Instances: Time and Space123
Constant Scaling Factors125
Multiple Hierarchies per Type126
Pseudolevels129
Mixed Hierarchies133
Summary135
Chapter 6Hypercubes or Semantic Spaces137
Meaning and Sparsity138
Meaning and Comparability148
Summary163
Chapter 7Multidimensional Formulas165
Formulas in a Multidimensional Context166
Multidimensional Formulas177
Summary199
Chapter 8Links201
Types of Links203
Structure Tables and Links207
Data Tables and Content Links208
Preaggregation212
Summary213
Chapter 9Analytic Visualization215
What Is Data Visualization?216
The Semantics of Visualization219
Using Data Visualization for Decision Making233
Visualizing Multidimensional Business Data239
Examples of More Complex Data Visualization Metaphors242
Summary245
Chapter 10Physical Design of Applications247
Data Distribution249
Calculation Distributions264
Common Configurations267
Summary270
Part 3Applications271
Chapter 11Practical Steps for Designing and Implementing OLAP Models273
User Requirements275
Solution Design280
More Complex Aggregations and Analysis302
Summary306
Chapter 12Introduction to the Foodcakes Application Example307
Preface to the Second Edition307
Introduction to the Foodcakes International Application308
Chapter 13Purchasing and Currency Exchange313
Background Issues313
Purchases Cube315
Exchange Rate Cube329
Combined Purchasing and Exchange Rates337
Summary339
Chapter 14Materials Inventory Analysis341
The Inventory Throughput Cube342
Costing367
Summary374
Chapter 15FCI's Sales and Marketing375
Cube Dimensions376
Cube Input Variables377
Analyzing Sales386
Value States395
Summary402
Chapter 16FCI's Activity-Based Management403
Jane's Presentation404
The Approach405
Business Process and Asset Dimensions406
Calculating Total Cost of Goods Sold409
Calculating Total Costs413
Legal Issues: A Reader Exercise446
Summary449
Chapter 17A Computational Example451
Business Process Schemas455
Cube Views460
FCI Cost-Revenue Analysis Calculation Steps by Schema485
Part 4Further Issues499
Chapter 18Multidimensional Guidelines501
Outline502
Core Logical Features502
Noncore Logical511
Physical Features515
Chapter 19Product Language Comparisons519
Kickoff Example520
Sample Schemata521
Referencing Examples521
Treatment of Missing and Inapplicable Cells (Instances)530
Handling Calculation Precedence531
Basic Formulas532
Application Ranges in Joined Cubes536
Summary539
Chapter 20DSS Fusion541
Overview of a Unified Architecture542
Smaller, Multifunction Tasks553
A Single More Fully Integrated Example561
Summary567
Appendix AFormula Index569
Appendix BStandards in the OLAP Marketplace571
Appendix CLC Language Constructs577
Appendix DGlossary581
Appendix EThe Relationship between Dimensions and Variables589
Appendix FToward a Theoretically Grounded Model for OLAP and Its Connection to the Relational Model and Canonical Logic603
Appendix GCodd's 18 Features615
Notes621
Bibliography635
Index643

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

OLAP Solutions: Building Multidimensional Information Systems 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
A very interesting book to have a general overview of the Olap concepts. Absolutly to be read before to choose an Olap tool or to advice on this technic some customer.