Microsoft OLAP Solutions
Wiley (Publisher)
Published on 18. August 1999
Book
Mixed media product
XVIII, 510 pages
978-0-471-33258-9 (ISBN)
Article exhausted; check for reprint
Description
This 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. This is a guide to installing, using, and managing the new Microsoft OLAP server. After a quick overview of the core concepts of OLAP and the OLAP server, the author details the basics, including: how to install the server; how to use the server to access and update data; how to specify calculations; how to optimise and secure the server; and how to integrate the server with other Microsoft data warehouse tools.
The result is an in-depth guide to operating the server.
The result is an in-depth guide to operating the server.
More details
Language
English
Place of publication
New York
United States
Publishing group
John Wiley and Sons Ltd
Target group
College/higher education
Professional and scholarly
Illustrations
1 CD-ROM
Dimensions
Height: 23.4 cm
Width: 19.1 cm
Weight
934 gr
ISBN-13
978-0-471-33258-9 (9780471332589)
Schweitzer Classification
Other editions
New editions

Book
08/2001
1st Edition
Wiley
€42.90
Article is exhausted, reprint undefined
Content
OLAP 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.