Publisher's Synopsis
A Practical Guide to Microsoft OLAP Server introduces you to OLAP technology and leads you step-by-step through the process of deploying an OLAP server, focusing in particular on Microsofts OLAP Services. This book explains the basic concepts underlying OLAP, compares various OLAP products, and describes Microsofts OLAP Services architecture. In addition, it enumerates the development life cycle of an OLAP Services application from planning and design through installation and administration, discussing the goals and approaches for each phase and task.;Essential topics covered include: *OLTP versus OLAP *Dimensions, measures, and aggregations *Multipurpose query tools *Dedicated desktop OLAP *Microsoft OLAP Services management software *Analyzing OLAP project goals, tasks, resources, and scheduling *Data source analysis, including host platform accessibility and dimensionality *Designing hierarchies, aggregation, storage, and partitioning *Security *OLAP server installation, including hardware requirements *Designing and building an OLAP database *OLAP and Excel *OLAP and the Web *Administration, training, and technical support A Practical Guide to Microsoft OLAP Server also provides information on more advanced OLAP topics, including virtual cubes, merging database partitions and custom OLAP development. Real-world examples demonstrate concepts and methods throughout the book, and plenty of practical advice will help you avoid trouble spots and achieve a smooth and successful deployment.
