![]() |
Consumption Analytics Documentation |
The procedure in Connecting Excel joins data about usage charges to data about customer accounts based on the full account structure. This enables you to aggregate charge data at any level in the hierarchy. For example, if you want to analyze total charges by day aggregated to the highest level in the structure, you can perform the following procedure.
To view total charges by day rolled up to the top level of your account structure
ReportAccountStruct0
view that holds the description for customers at the top level of your account structure and drag it to the ROWS box below.<
levelName > ID
field and a <
levelName > Desc
field. The former holds the part of a customer’s account ID at that level and the latter holds the corresponding description. For example, if the top level of your account structure is “Service Provider,” drag the Service Provider Desc field to the ROWS box. This will give you one row per customer at the top level of your hierarchy, with the description displayed. You could instead display the partial account ID by dragging Service Provider ID . ReportSummary
view and drag it to the COLUMNS box.Your worksheet now shows all charge data in the system for every top-level customer (in this example, service provider) broken down by each accounting day loaded. You can further break down this charge data by adding other fields, such as Resource Group Title, Resource Description, and even lower levels of the account structure, to the ROWS and COLUMNS boxes. See the documentation for the PivotTable feature of your version of Microsoft Excel for information about its capabilities and how to use them.
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP