O'Reilly logo

Microsoft System Center Reporting Cookbook by Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating reports using OLAP cubes

In the Using out-of-the-box Service Manager Reports and cubes recipe, we showed you how to use Microsoft Excel to access the OLAP cubes that are shipped with Service Manager.

Under certain circumstances, you might want to use these OLAP cubes to create reports hosted in SQL Server Reporting Services and make them available to your end users through the console or web browser.

In this recipe, we will use Report Builder to create and publish a report using the data stored in the Service Manager OLAP cubes.

Getting ready

Before we can start using SQL Server Reporting Services with Service Manager OLAP cubes, we need to create a data source that points to the OLAP cubes. The cubes are hosted in DWASDataBase on the instance ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required