Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
About this product
Product Identifiers
PublisherWiley & Sons, Incorporated, John
ISBN-100471332585
ISBN-139780471332589
eBay Product ID (ePID)1004996
Product Key Features
Number of Pages528 Pages
Publication NameMicrosoft Olap Solutions
LanguageEnglish
SubjectDatabases / General, Enterprise Applications / General, Information Technology
Publication Year1999
TypeTextbook
AuthorErik Thomsen, George Spofford, Dick Chase
Subject AreaComputers
FormatTrade Paperback
Dimensions
Item Height1.2 in
Item Weight32.6 Oz
Item Length9.5 in
Item Width7.4 in
Additional Product Features
Intended AudienceTrade
LCCN99-026922
Dewey Edition21
IllustratedYes
Dewey Decimal006.3
Table Of ContentOLAP Structures and OLAP Services Microsoft OLAP Services Architecture. Database Design Basics. The Basics of Building a Database with the OLAP Manager. Introduction to MDX. Context and Data in MDX Evaluation. MDX Function and Operator Reference. MDX Dimensional Reference Functions. MDX Application Topics. Maintaining Applications. Optimization. Advanced Cube and Database Design. Security. Extending OLAP Services through External Functions. Tutorial 1: Health Care Benefits Analysis. Tutorial 2: Grocery Store Frequent Shopper Program. Appendices. Index.
SynopsisThis is a guide to Microsoft's OLAP tool - which brings data mining to the masses. OLAP stands for On-Line Analytical Processing - a core technology behind most data mining tools. It allows users to create, change, and access information from multidimensional data warehouses almost instantaneously. The technique of viewing data in multiple dimensions helps users discover unexpected relationships - for example, that people who buy a particular brand of soap and tissue paper are more likely to buy a brand of cleanser. Recent events have seen OLAP explode, as Microsoft entered the market with a two-phase assault, introducing SQL Server 7 for data warehousing and the OLAP Server for data mining using SQL Server 7 and other popular databases., A valuable guide to setting up and taking full advantage of the new Microsoft OLAP server. A core technology behind most data mining tools, OLAP stands for "On-Line Analytical Processing. " It enables users to create, change, and access information from "multidimensional" data warehouses almost instantaneously., "The authors merge their deep experience in OLAP to produce a roadmap to success with Microsoft SQL Server OLAP Services." -Bill Baker, Microsoft Corporation Microsoft(r) OLAP Solutions OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Microsoft has unleashed the power of OLAP in one of its most popular products, SQL Server 7, now distributed with its OLAP Services component. This guide to mastering Microsoft OLAP Services begins with a practical introduction to OLAP server concepts and architecture. It then progresses by logical, skill-building steps through a range of crucial topics in maintenance, database optimization, and advanced database design. The authors include in-depth case studies illustrating how to build OLAP applications, as well as instructions on how to construct working OLAP applications, including a healthcare benefits analysis application and a grocery store frequent shopper analysis application. Topics covered in detail include: * The storage and operational architecture of Microsoft OLAP server * Using the MDX language with Microsoft OLAP server * Using Microsoft OLAP server to access and update data * Specifying calculations * Optimizing server performance * Securing the server On the CD-ROM you'll find: * All the sample applications and databases described in the book * Additional software for working with Microsoft OLAP server Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/