Database Reference
In-Depth Information
How it works...
The recipe provides steps in the
Getting ready
section on how to prepare the environment
for Chargeback data analysis (reporting). Once you complete the
Getting ready
steps, you
are provided with steps to create price sheets, and when you create the price sheets, you
perform the final steps on analyzing the data. The breakdown of the two parts follows:
•
Creating price sheets
: The steps in this section walk you through importing the
required management packs and creating sample pricing data
•
Analyzing Chargeback data
: The steps in this final part provide information on
using Microsoft Excel to access the cubes created by the Chargeback management
pack import. You must wait for the ETL process to complete before you can per-
form these steps.
We need to create at least one price sheet, publish it, and assign it to one or more clouds be-
fore the actual Chargeback data is available to be analyzed.
Service Manager transfers the Chargeback data to the Service Manager Data Warehouse
and processes an Analysis Service cube that you can access to analyze data.
Note
Depending on your environment, it can take several hours after the price sheet is created
until all data has been transferred to the data warehouse and the cube is processed.
