What I have done is I have found that it is very handy having all our SCOM data in a data warehouse and then having it in a SSAS (SQL Server Analysis Services).
Within the zip file which can be located here below it has all the details for the following:
· SCOM Data Warehouse and OLAP Documentation.docx
o This has all the details required to get up and running.
· Restore the SQL Server Database
· Deploy your SSIS Project
· Deploy your SSAS Project
· Deploy your SSRS Reports
Zip File location: http://sdrv.ms/1dwycbX
So below is some examples of what can be achieved when the data is sitting inside SSAS.
SCOM report, to analyze and predict based on the past when disks will be running out of space.
· This utilizes the KPIs within SSAS
Using Excel we can get a trend to analyze what has been happening on a server.
· As I am sure you are aware there are a whole host of other additions that can be added to the Excel file to make it easier for people to use such as:
o Timeline – If Excel 2013
Using Excel we can also use the KPIs that have been created to look at our Goals, Status and trends
I have also created additional reports where based on the past average of CPU % Time Used, we then compared this to the current days average if it is greater than 150% then display the data. I have then put this into SSAS Tabular and used Power View in SharePoint in order for guys to quickly see the data.
I have tried to ensure that everything should work as expected.
If there are any issues or something that does not work, please contact me in the contact section below.
I do hope that this will be as useful for you as it has been and continues to be for me.