As anyone who has clicked the link in the Reporting view in the Operations Manager Console to author reports via the Report Builder will know, the required models are not available within the tool to get you started.
Details on how to get the models loaded in 2007 SP1/R2 is detailed below.
I’ve detailed how to get this implemented with SCOM 2012 as there are some subtle differences.
Firstly, load up the Report Manager. Browse to http://<reportserver>/Reports
Click on the Details View
Click on Data Warehouse Main to open up the properties of this object.
Once in the Data Warehouse Main properties page, ensure the checkbox for ‘Hide in tile view’ is not selected. Once done, Apply the settings
Next, we need to import the Event and Performance Model files so they can be used by the report builder.
1. Click on Upload File.
2. Click on Browse. Locate the SCOM 2012 source files and from there, select the ReportModels\Other folder. In here you can find the 2 .SMDL model files required.
Select Event.smdl and open
Repeat from step 1, but select the Performance.smdl file.
OK, that done, just need to link the models to the Data Warehouse Main datasource.
So, from the Home screen, click on either the newly loaded Event or Performance items.
Select the Data Source link, click Browse
Select the Data Warehouse Main item, click on OK and Apply
Do the same for the other SMDL file. That’s it, all the configuration you need to do !
If you’re using SQL 2012, it looks like you will need to download Report Builder 3.
Click above to obtain it.
Some great info on creating reports can be found here…