![]() |
Consumption Analytics Documentation |
This article describes the two database views you can use when analyzing Cloud Cruiser data either in Microsoft Excel or in Cloud Cruiser Analytics. They enable you to view charge data aggregated to any level of your customer hierarchy.
If you are using Cloud Cruiser Analytics, the columns in these database views are exposed as dimensions and measures, and additional calculated measures are also available. For information, see Dimensions and measures for Cloud Cruiser Analytics.
Each record in the ReportSummary
view represents the charge (either revenue or cost) for one resource to one customer account on one date. It provides high-level information about the charge and the resource definition. It does not provide contextual information, such as a VM name, about the instance of the resource that caused the charge.
Key columns to consider using in your analysis:
TotalAmount
: This is the amount charged.ResourceGroupTitle
and ResourceDescription
: Use these to slice by what you're charging for. The latter is the human-friendly name for a resource.AccountingDate
, AccountingPeriod
, and AccountingYear
: Use these to slice your data by time.ResourceUnits
and ResourceUnitDescription
: Use these to show how much of a resource was used.ResourceGroupOrder
and ResourceOrder
: Use these to display resources in the same order they appear in standard reports.ResourceRateType
: Use this to differentiate revenue from cost.
Name | Data type | Description |
---|---|---|
AccountUID | integer | The unique ID for the customer account to which the charge applies. This corresponds to an account ID that would appear in reports and CC Records. The AccountUID allows the database to work with a single value rather than the multiple values at different levels of your account structure that make up an account ID. |
AccountingDate | date/time | The date for which the usage is charged. Only the date is relevant, as the time in every record is 23:59:59.000. This date does not necessarily match the date in the UsageStart or UsageEnd columns. |
AccountingYear | integer | The accounting year in which AccountingDate falls. This might not be the same as the calendar year in which that date falls, depending upon the day of the month that the customer's accounting periods begin. Example: If |
AccountingPeriod | integer | The accounting period in which Example: If |
UsageStart | date/time | The date and time when this usage started |
UsageEnd | date/time | The date and time when this usage started |
ResourceRate | float | The variable rate for the resource |
ResourceUnits | decimal | The total amount of the resource for
|
ResourceUnitsAllocated | decimal | The raw value collected for the resource, averaged if collected more than once during the usage period |
FixedAmount | decimal | The amount of fixed charges |
VariableAmount | decimal | The amount of variable charges. This represents ResourceRate multiplied by ResourceUnits . |
TotalAmount | decimal | The total charges applied to the usage in the record. This represents FixedAmount plus VariableAmount . |
LoadGroupUID | integer | The unique ID of the load group in which this record was loaded into the Cloud Cruiser database |
ResourceDetailID | integer | The unique ID of the record in the ReportDetail view that contains more detail about the usage charged in this record |
ResourceGroupTitle | string | The name of the resource group of which the resource is a member |
ResourceHeader | string | The name defined for the resource. Sometimes this is also referred to as the resource's ID. |
ResourceComments | string | The comments defined for the resource |
ResourceActiveStatus | string | The Active option defined for the resource. An Active resource can be used for charging, an Inactive one cannot. |
ResourceHiddenStatus | string | The Hidden option defined for the resource. A Visible resource appears in standard reports, a Hidden one does not. |
ResourceAllocationType | string | The Allocated option defined for the resource. An Allocated resource is charged for access to the resource over a given time interval, a Non-allocated resource is charged for accumulated consumption of the resource. |
ResourceDescription | string | The description defined for the resource, which is displayed in reports in place of its name |
ResourceUnitDescription | string | The units displayed in reports for the resource. For example, GB or tickets . |
ResourceChargeInterval | string | The interval to which the rate for the resource applies. This value is Daily for non-allocated resources. |
CurrencyCode | string | Not used in this release. The value is always usd . |
CurrencyComments | string | Comments defined for the resource revision in effect on AccountingDate . This is the Comments field in the Rate area of the Billing > Services window, different from the Comments field at the level of the resource. |
RevisionEffectiveDate | date/time | The starting date of the resource revision in effect on AccountingDate |
RevisionTerminationDate | date/time | The ending date of the resource revision in effect on AccountingDate |
ResourceDetailType | string | The rate type for the resource: Standard (shown as Basic in the Cloud Cruiser Portal), Tier , or State |
ResourceDetailDescription | string | The tier or state value for the resource. Null for a Standard resource. |
ResourceRateType | string | The effect on you of the charge for the resource. A Price resource is revenue charged to your customer, a Cost resource represents a cost of goods sold. |
RatePlan | string | The name of the rate plan that supplied the pricing used to calculate the total charge. Rate plans define ResourceDetailType , ResourceChargeInterval , FixedAmount , VariableRate , and CurrencyComments . |
UserFlag1 | string | The User Data 1 string defined for the resource in the Billing > Services window. This flag is intended for any custom categorization you need for reporting beyond the other properties you set for a resource, and its value does not affect Cloud Cruiser operation. |
UserFlag2 | string | The User Data 2 string defined for the resource. See the description for UserFlag1 . |
ResourceGroupOrder | integer | The number assigned to the resource group for sorting in the Billing > Services window and in reports. Groups are sorted by this number in ascending order. |
ResourceOrder | integer | The number assigned to the resource for sorting in the Billing > Services window and in reports. Within their group, resources are sorted by this number in ascending order. |
Each record in the ReportAccountStruct0
view represents a customer account for whom charges exist in the database. Some of these customer accounts might not have a record in the Billing > Customers window of the Cloud Cruiser Portal, and some of the accounts there might not have a record in this view.
Though similar database views exist for each account structure view you create, named ReportAccountStruct<viewNumber>
, HPE recommends you use ReportAccountStruct0
for analyzing Cloud Cruiser data in Microsoft Excel and Cloud Cruiser Analytics. This view gives you access to every level of the account structure. You can always choose not to expose some data in these analysis tools.
Name | Data type | Description |
---|---|---|
StructureName | string | The name of the account structure view. In the ReportAccountStruct0 database view this will always be default . |
Level1 | string | The portion of the account ID at the first level of your account structure. If the account represented by the record is at the top of this hierarchy, then this is its complete account ID. |
Level1Desc | string | The description defined for the Level1 account ID |
Level<num> | string | The portion of the account ID from the first level through level <num> . These columns are populated up to the last level of your account structure, with any levels below the customer account represented by the record being padded with spaces to the appropriate length. So as <num> rises the last column where visible characters are appended to the account ID is the level of the customer account represented in the record. |
Level<num>Desc | string | The description defined for the Level<num> account ID. These columns too are populated up to the last level of your account structure. Any levels below the customer account represented by the record show the description from the customer's level. |
AccountUID | string | The unique ID for the customer account represented by the record, used also in the ReportSummary view and other database tables and views |
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP