Book Image

Microsoft System Center 2012 Service Manager Cookbook

Book Image

Microsoft System Center 2012 Service Manager Cookbook

Overview of this book

Microsoft System Center Service Manager (SCSM) offers enterprises a complete, integrated platform for automating and adapting IT Service Management best practices to your organization's requirements. "Microsoft System Center Service Manager Cookbook" provides you with real-world, immediately usable recipes which will show you how to configure and administer System Center Service Manager 2012 and understand how to solve particular problems and scenarios to take this tool further. In Microsoft System Center Service Manager Cookbook, you will get to grips with practical recipes which will show you how to configure and administer System Center Service Manager 2012. This cookbook features distinct recipes on the practical implementation of ITSM Frameworks and Processes, Microsoft System Center 2012 Service Manager Administration, how to configure Service Level Agreements (SLAs). It will also cover incident and problem management, the design of change and release management as well as implementing and editing security roles.
Table of Contents (20 chapters)
Microsoft System Center 2012 Service Manager Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Analyzing data with Microsoft Excel


Online Analytical Processing (OLAP) cubes are a new feature in SCSM 2012 that leverages the Service Manager Data Warehouse infrastructure to provide self-service Business Intelligence capabilities to the end user.

An OLAP Cube is a data structure that overcomes limitations of relational databases by providing rapid analysis of data. Cubes can display and sum up large amounts of data while also providing users access to the most granular of data. These cubes are stored in SQL Server Analysis Services databases. Self-service BI tools such as Excel and SQL Server Reporting Services can target these cubes and allow the user to analyze the data from multiple perspectives.

In this recipe, we are going to show you how you can use Microsoft Excel to allow your users to quickly and easily create simple reports by directly accessing OLAP cubes from Service Manager.

Getting ready

Before you can work with OLAP cubes, it is a requirement that you have already installed...