Database Reference
In-Depth Information
In this example, we will use Microsoft Excel to access the cube and create an ad hoc
PivotTable report to display Chargeback information.
Note
Make sure that Microsoft Excel is installed on the computer that runs the Service Manager
console.
Perform the following steps:
1. Start the Service Manager console as a user with administrative access to Service
Manager.
2. Under
Data Warehouse
, click on
Cubes
and select
Service Manager
Chargeback Cube
. Then, click on
Analyze Cube in Excel
in the
Tasks
pane.
3. Excel will now open, and a connection to the Chargeback cube is automatically
established. You will see an empty PivotTable.
4. In the
PivotTable Fields
area, in the
ServiceManagerInfraChrageback-
DateDim
group, select the
Fiscal Year Hierarchy
dimension.
5. In the
VirtualMachineDim
group, select
Cloud
and
Computer Name
.
6. In
Service Manager Infra Daily Chargeback
, select
Cloud Cost
,
VM Cost
,
and
VM Total Cost
.
7. Expand and collapse dimensions in the PivotTable as desired. Your PivotTable
should now look similar to the following screenshot: