Using OLAP Cubes for Advanced Analytics
Updated: November 1, 2013
Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager
In System Center 2012 – Service Manager, data that is present in the data warehouse can be consolidated from various sources. It is presented through Service Manager by using predefined and customized Microsoft Online Analytical Processing (OLAP) data cubes. In short, advanced analytics in Service Manager consist of publishing, viewing, and manipulating cube data, usually in either Microsoft Excel or Microsoft SharePoint. Excel is primarily used by itself to view and manipulate data. SharePoint is used primarily as a means of publishing and sharing cube data.
Service Manager includes a System Center–wide data warehouse. Therefore, data from Operations Manager, Configuration Manager, and Service Manager can be consolidated into the data warehouse, where you can easily use multiple data views to get any information that you might want. This is also an interface where you can put data into the same data warehouse from your own custom sources, such as SAP applications or a third-party human resources application. This consolidation creates a common data model and enables enriched analyses to help you build a data warehouse across your Information Technology (IT) organization that can serve all your business intelligence and reporting needs.
When your data is in a common model, you can manipulate information and have common definitions and a common taxonomy for your whole enterprise. You can do this by deploying OLAP data cubes and accessing the information from the cubes, using standard tools such as Excel and SharePoint. This makes it possible for your users to employ skills that they already know. You control the definition of your business logic in a centralized manner. For example, you can define key performance indicators, such as the incident time-to-resolution thresholds, and which values for the thresholds are green, yellow, or red. You can control these choices in a centralized manner and empower your users to easily use the data, yet have the common definition appear in their Excel reports or their SharePoint dashboards.
Advanced Analytic Topics
Understanding OLAP Cubes
Describes OLAP cube usage, structure, deployment, troubleshooting, and creation.
Analyzing Data with Excel 2010
Describes how to analyze date with Excel 2010.
How to View and Analyze an OLAP Data Cube with Excel
Describes how to view and analyze an OLAP data cube using Excel.
Creating and Using Excel Slicers
Describes how to create and use Excel slicers.
How to Refresh OLAP Data Cube Information
Describes how to refresh OLAP data cubes.
How to Manage the Analysis Libraries
Describes how to manage analysis libraries.
How to Use the Analysis Library
Describes how to use the analysis library.
Advanced Analytical Reports Available in System Center 2012 - Service Manager
Lists the OLAP data cubes present in Service Manager.
Creating and Deploying Dashboards
Explains how to create and deploy dashboards to display OLAP cube information in SharePoint 2010.
Other Resources for This Component
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.