Database Reference
In-Depth Information
How it works...
The recipe provided you with the explanation of performance-related data available to you
in the Operations Manager Data Warehouse database. You are provided with steps and il-
lustrations as follows:
•
Performance dataset
: These are views that contain the information you need for
this category and the specific property types you must use.
•
Create a custom view
: The steps to create a custom filter view is provided to re-
duce the amount of data you base your report on. Creating a view organizes the
data by effectively saving the SQL query.
•
Security delegation
: You must assign the right permissions to the view you cre-
ated to allow access to report authors.
•
Excel Pivot tables
: The final part of the recipe provides steps on using Microsoft
Excel to retrieve the data using the custom view and present the desired report as a
PivotTable.
Once you have completed these steps, you have the option to share the excel report with
your report consumers.
