Database Reference
In-Depth Information
How to do it...
In this example, we will create a report that shows the percentage of incidents meeting and
breaching the SLA by incident classification category. Perform the following steps:
1. Start Report Builder.
2. Under New Report , select Table or Matrix Wizard .
3. Select Create a dataset and click on Next .
4. Click on Browse… to browse to the DWASDataBase data source in SQL Server
Reporting Services. Click on Next .
5. If prompted for data source credentials, select Use the current Windows user and
click on OK .
6. The Design a query wizard starts. In the upper-left corner, change to Service
Manager WorkItems Cube .
7. Drag and drop the IncidentDim_IncidentClassification dimension in
the Drag levels or measures here to add to the query middle pane area.
8. Under Measure Group , expand Measures , expand IncidentDim , and drag Incid-
ents Meeting Meeting All SLOs Percentage and drop it in the middle pane area
next to IncidentDim_IncidentClassification .
9. Drag Incidents Breaching SLO Percentage and drop it in the middle pane area
next to Incidents Meeting Meeting All SLOs Percentage , as shown in the fol-
lowing screenshot:
Search WWH ::




Custom Search