3.1 Cost and Usage

Columns: 65

The Cost and Usage dataset is the primary dataset for FOCUS cost and usage data.

The specification for the Cost and Usage dataset defines a group of columns that provide qualitative values (such as dates, resource, and service provider information) categorized as "dimensions" and quantitative values (numeric values) categorized as "metrics" that can be used for performing various FinOps capabilities. Metrics are commonly used for aggregations (sum, multiplication, averaging etc.) and statistical operations within the dataset. Dimensions are commonly used to categorize, filter, and reveal details in your data when combined with metrics. The columns are presented in alphabetical order.

Columns

Column	Column Type	Feature Level	Allows Nulls	Data Type
Allocated Method Details	Dimension	Recommended	True	JSON
Allocated Method ID	Dimension	Conditional	True	String
Allocated Resource ID	Dimension	Conditional	True	String
Allocated Resource Name	Dimension	Conditional	True	String
Allocated Tags	Dimension	Conditional	True	JSON
Availability Zone	Dimension	Recommended	True	String
Billed Cost	Metric	Mandatory	False	Decimal
Billing Account ID	Dimension	Mandatory	False	String
Billing Account Name	Dimension	Mandatory	True	String
Billing Account Type	Dimension	Conditional	False	String
Billing Currency	Dimension	Mandatory	False	String
Billing Period End	Dimension	Mandatory	False	Date/Time
Billing Period Start	Dimension	Mandatory	False	Date/Time
Capacity Reservation ID	Dimension	Conditional	True	String
Capacity Reservation Status	Dimension	Conditional	True	String
Charge Category	Dimension	Mandatory	False	String
Charge Class	Dimension	Mandatory	True	String
Charge Description	Dimension	Mandatory	True	String
Charge Frequency	Dimension	Recommended	False	String
Charge Period End	Dimension	Mandatory	False	Date/Time
Charge Period Start	Dimension	Mandatory	False	Date/Time
Commitment Discount Category	Dimension	Conditional	True	String
Commitment Discount ID	Dimension	Conditional	True	String
Commitment Discount Name	Dimension	Conditional	True	String
Commitment Discount Quantity	Metric	Conditional	True	Decimal
Commitment Discount Status	Dimension	Conditional	True	String
Commitment Discount Type	Dimension	Conditional	True	String
Commitment Discount Unit	Dimension	Conditional	True	String
Consumed Quantity	Metric	Conditional	True	Decimal
Consumed Unit	Dimension	Conditional	True	String
Contract Applied	Dimension / Metric	Conditional	True	JSON
Contracted Cost	Metric	Mandatory	False	Decimal
Contracted Unit Price	Metric	Conditional	True	Decimal
Effective Cost	Metric	Mandatory	False	Decimal
Host Provider Name	Dimension	Mandatory	False	String
Invoice ID	Dimension	Recommended	True	String
Invoice Issuer Name	Dimension	Mandatory	False	String
List Cost	Metric	Mandatory	False	Decimal
List Unit Price	Metric	Conditional	True	Decimal
Pricing Category	Dimension	Conditional	True	String
Pricing Currency	Dimension	Conditional	True	String
Pricing Currency Contracted Unit Price	Metric	Conditional	True	Decimal
Pricing Currency Effective Cost	Metric	Conditional	True	Decimal
Pricing Currency List Unit Price	Metric	Conditional	True	Decimal
Pricing Quantity	Metric	Mandatory	True	Decimal
Pricing Unit	Dimension	Mandatory	True	String
Provider - DEPRECATED	Dimension	Mandatory	False	String
Publisher - DEPRECATED	Dimension	Mandatory	False	String
Region ID	Dimension	Conditional	True	String
Region Name	Dimension	Conditional	True	String
Resource ID	Dimension	Conditional	True	String
Resource Name	Dimension	Conditional	True	String
Resource Type	Dimension	Conditional	True	String
Service Category	Dimension	Mandatory	False	String
Service Name	Dimension	Mandatory	False	String
Service Provider Name	Dimension	Mandatory	False	String
Service Subcategory	Dimension	Recommended	False	String
SKU ID	Dimension	Conditional	True	String
SKU Meter	Dimension	Conditional	True	String
SKU Price Details	Dimension	Conditional	True	JSON
SKU Price ID	Dimension	Conditional	True	String
Sub Account ID	Dimension	Conditional	True	String
Sub Account Name	Dimension	Conditional	True	String
Sub Account Type	Dimension	Conditional	True	String
Tags	Dimension	Conditional	True	JSON

Relationships

The Cost and Usage dataset can be joined to the Contract Commitment dataset through the use of the Contract Commitment ID.

In the Cost and Usage dataset, Contract Commitment ID is a property within a JSON object array provided in Contract Applied column.
In the Contract Commitment dataset, Contract Commitment ID is a column.

Dataset A	Dataset A Column	Dataset B	Dataset B Column
Cost and Usage	Contract Applied	Contract Commitment	Contract Commitment ID

Requirements

CostAndUsage adheres to the following requirements:

CostAndUsage MUST be present.
CostAndUsage MUST conform to ColumnHandling requirements.
CostAndUsage MUST conform to NullHandling requirements.
CostAndUsage MUST conform to DiscountHandling requirements.
CostAndUsage MUST conform to InvoiceHandling requirements.
CostAndUsage MUST conform to DataGeneratorCalculatedSplitCostAllocationHandling requirements.

Dataset ID

CostAndUsage

Display Name

Cost and Usage

Description

Describes the cost and usage incurred through using or purchasing a service provider's resources or services.

Introduced (version)

0.5

Columns in this Dataset

Column	Type	Level	Data Type
Allocated Method ID	Dimension	Conditional	String
Allocated Method Details	Dimension	Recommended	JSON
Allocated Resource ID	Dimension	Conditional	String
Allocated Resource Name	Dimension	Conditional	String
Allocated Tags	Dimension	Conditional	JSON
Availability Zone	Dimension	Recommended	String
Billed Cost	Metric	Mandatory	Decimal
Billing Account ID	Dimension	Mandatory	String
Billing Account Name	Dimension	Mandatory	String
Billing Account Type	Dimension	Conditional	String
Billing Currency	Dimension	Mandatory	String
Billing Period End	Dimension	Mandatory	Date/Time
Billing Period Start	Dimension	Mandatory	Date/Time
Capacity Reservation ID	Dimension	Conditional	String
Capacity Reservation Status	Dimension	Conditional	String
Charge Category	Dimension	Mandatory	String
Charge Class	Dimension	Mandatory	String
Charge Description	Dimension	Mandatory	String
Charge Frequency	Dimension	Recommended	String
Charge Period End	Dimension	Mandatory	Date/Time
Charge Period Start	Dimension	Mandatory	Date/Time
Commitment Discount Category	Dimension	Conditional	String
Commitment Discount ID	Dimension	Conditional	String
Commitment Discount Name	Dimension	Conditional	String
Commitment Discount Quantity	Metric	Conditional	Decimal
Commitment Discount Status	Dimension	Conditional	String
Commitment Discount Type	Dimension	Conditional	String
Commitment Discount Unit	Dimension	Conditional	String
Consumed Quantity	Metric	Conditional	Decimal
Consumed Unit	Dimension	Conditional	String
Contract Applied	Dimension and Metric	Conditional	JSON
Contracted Cost	Metric	Mandatory	Decimal
Contracted Unit Price	Metric	Conditional	Decimal
Effective Cost	Metric	Mandatory	Decimal
Host Provider Name	Dimension	Mandatory	String
Invoice ID	Dimension	Recommended	String
Invoice Issuer Name	Dimension	Mandatory	String
List Cost	Metric	Mandatory	Decimal
List Unit Price	Metric	Conditional	Decimal
Pricing Category	Dimension	Conditional	String
Pricing Currency	Dimension	Conditional	String
Pricing Currency Contracted Unit Price	Metric	Conditional	Decimal
Pricing Currency Effective Cost	Metric	Conditional	Decimal
Pricing Currency List Unit Price	Metric	Conditional	Decimal
Pricing Quantity	Metric	Mandatory	Decimal
Pricing Unit	Dimension	Mandatory	String
Provider - DEPRECATED	Dimension	Mandatory	String
Publisher - DEPRECATED	Dimension	Mandatory	String
Region ID	Dimension	Conditional	String
Region Name	Dimension	Conditional	String
Resource ID	Dimension	Conditional	String
Resource Name	Dimension	Conditional	String
Resource Type	Dimension	Conditional	String
Service Provider Name	Dimension	Mandatory	String
Service Category	Dimension	Mandatory	String
Service Name	Dimension	Mandatory	String
Service Subcategory	Dimension	Recommended	String
SKU ID	Dimension	Conditional	String
SKU Meter	Dimension	Conditional	String
SKU Price Details	Dimension	Conditional	JSON
SKU Price ID	Dimension	Conditional	String
Sub Account ID	Dimension	Conditional	String
Sub Account Name	Dimension	Conditional	String
Sub Account Type	Dimension	Conditional	String
Tags	Dimension	Conditional	JSON