Service Manager 2012 data warehouse provides users a model-based approach to build OLAP cubes.
Cubes help us to analyze the Measures (like IncidentAssginedtoUser Count) defined on facts and dimensions (Incident Counts) on a multidimensional axis . Each cube contains a collection of measure groups and corresponding cube dimensions (like Incident, Time, Priority).
The OLAP infrastructure provided with SCSM 2012 performs the following actions on import of a cube MP
1) Deploys the cube defined in the Management Pack to SSAS server provided during the
SCSM 2012 data warehouse setup
2) Creates a Process job for the cube- Process.CubeID and it runs on the default schedule
The SCSM console provides customers a view of the cubes available and an option to open the cube in Excel for analysis
System Center data warehouse setup performs the following steps so that the cube can be deployed as soon as an MP is imported:
1) Creates the Analysis server database
2) Creates the DataSources for the data marts
A Data Source View is created up on the deployment of the first cube MP. System Center deploys cubes out of the box so the DSV is available by default.
System Center Cube Model :
System Center Cube is defined as collection of following MP elements:
1) Measure groups which points to the facts to be included
2) Substitutions to be performed on the fact
3) MDX resources
4) Drill Through Actions
7) Custom Measures
8)Many to Many Relationships
Here is the XSD you may use to understand the cube schema:
All the elements other than MeasureGroups are optional and can be added as per the Business analysis requirement.
When a user defines a cube using the above schema and Imports MP, the SM 2012 data warehouse deploys the cube using AMO and creates the required infra to maintain it.
For example lets create a cube based on “ComputerHostsOperatingSystemFact”. Here is the dimensional view of the fact in the warehouse:
The cube can be defined using the following elements in the MP.