Home > Cloud Cruiser 3 > Viewing financial data > Database views for reporting

Database views for reporting

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.

ReportSummary

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.
  • AccountingDateAccountingPeriod, 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 AccountingDate is January 4th, 2015 but the customer's accounting day is 15, their billing periods begin on the 15th day of the month and this date falls in the twelfth period of the previous year. AccountingYear is 2014, not 2015.

AccountingPeriod integer

The accounting period in which AccountingDate falls. This might not be the same as the number of the calendar month in which that date falls, depending upon the day of the month that the customer's accounting periods begin.

Example: If AccountingDate is March 10th but the customer's accounting day is 15, their billing periods begin on the 15th day of the month and the AccountingPeriod is 2, not 3.

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 AccountingDate. For allocated resources, this is the collected amount prorated by the ResourceChargeInterval. It can be higher or lower than the value of ResourceUnitsAllocated depending upon a few variables:

  • How many times the resource was collected during the usage period
  • The length of the ResourceChargeInterval
  • Proration settings used for the charge
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.

ReportAccountStruct0

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
Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP