80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries with Microsoft SQL Server 2008 R2 Analysis Services with this book and eBook
Enrich your BI solutions by implementing best practice MDX calculations
Master a wide range of time-related, context-aware, and business-related calculations
Enhance your solutions by combining MDX with utility dimensions
Become skilled in making reports concise
Learn how to optimize, dissect, and debug your MDX calculations
Maximize your learning with detailed explanations following each solution
Packed with practical, hands-on cookbook recipes, illustrating the techniques to enrich your Business Intelligence solutions
In Detail
Microsoft SQL Server is an enterprise database platform that contains a multitude of technologies, Analysis Services being one of them. SQL Server Analysis Services (SSAS) provides OLAP and data mining capabilities and allows users to analyze multidimensional data stored in cubes using the MDX query language.
Manage and maintain your organization’s master data effectively with Microsoft SQL Server 2008 R2 Master Data Services
Gain a comprehensive guide to Microsoft SQL Server R2 Master Data Services (MDS) with this book and eBook
Explains the background to the practice of Master Data Management and how it can help organizations
Introduces Master Data Services, and provides a step-by-step installation guide
Covers all features of Master Data Services, including hierarchy management, importing/exporting data, the MDS API, and business rules
Includes practical examples that guide the reader on how to use each feature of the product
In Detail
Microsoft SQL Server Master Data Services (MDS) enables organizations to manage and maintain business data used to make critical business decisions. MDS is a Master Data Management (MDM) application, which standardizes and streamlines the critical data entities of an organization, essentially centralizing your master data.
A focused, practical tutorial, this book will show you how to manage and maintain your organization’s master data and improve data quality with Microsoft SQL Server 2008 R2 Master Data Services. Using credible techniques and an end-to-end approach, this book will take you through the steps required to implement Master Data Management, enabling business users to standardize and streamline their business data.
Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system
Provides Advanced Administration techniques for SQL Server 2008 R2 as a book or eBook
Covers the essential Manageability, Programmability, and Security features
Emphasizes important High Availability features and implementation
Explains how to maintain and manage the SQL Server data platform effectively
In Detail
Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels – be they small, medium, or large. SQL Server delivers a rich set of integrated services and reporting features that enable you to do more with your data such as query, search, synchronize, report, and analyze. SQL Server 2008 R2 accelerates the capabilities to scale database operations and is a highly scalable data platform.
This practical cookbook will show you the advanced administration techniques for managing and administering a scalable and high-performance SQL Server 2008 R2 system. It contains over 85 practical, task-based, and immediately useable recipes covering a wide range of advanced administration techniques for administering a high-performance SQL Server 2008 R2 system and solving specific administration problems. It shows how the SQL Server 2008 R2 system can be taken further.
Entries
