Database Reference
In-Depth Information
5. Click on the
Run Report
option from the taskbar to generate and view the report
in the console.
6. You can export reports to various file formats. Click on the
disk
icon and choose
the desired format to export the reports.
Using out-of-the-box Service Manager OLAP cubes
Perform the following steps:
1. Navigate to the
Data Warehouse
section of the Service Manager console.
2. Click on
Cubes
. You will see the list of all OLAP cubes available in Service
Manager.
3. Click on
Service Manager WorkItems Cube
and then click on the
Analyze
Cube in Excel
option from the taskbar. This will start Microsoft Excel and con-
nect to the OLAP cube automatically.
Tip
Manually connecting to the OLAP cubes
If you do not have the Service Manager console installed on the computer, you
can manually configure the connection to the OLAP cubes. Start Microsoft Excel.
On the
Data
ribbon, click on
From Other Sources
and choose
From Analysis
Services
. Type the name of the computer that hosts SQL Server Analysis Ser-
vices, click on
Next
, and choose the desired cube from the list of available cubes
in
DWASDataBase
. Click on
Finish
and then on
OK
.
4. Make the following configuration in
PivotTable Field List pane
:
1. Select
IncidentDim
under
Show fields related to
.
2. Drag the
IncidentDimCount
element from the
IncidentDim
entry and
drop it under
Values
.
3. Scroll down to the
IncidentDim_IncidentImpact
entry in the
Show
fields related to
list.
4. Expand
More Fields
and drag the
IncidentImpactValue
element and
drop it under
Column Labels
.
5. Scroll down to the
IncidentDim_IncidentStatus
entry in the
Show
fields related to
list.
6. Expand
More Fields
, drag the
IncidentStatusValue
element, and drop it
under
Row Labels
, as shown in the following screenshot: