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: