FOCUS 1.0 with Amazon columns (preview) conformance gaps
Note
FOCUS 1.0 with Amazon columns is in preview and can make mistakes. Please verify your cost data with Amazon Cost and Usage Reports (CUR) or CUR 2.0.
The following table provides all of the conformance gaps that might exist in an export of the FOCUS 1.0 with Amazon columns (preview) table. A particular conformance gap will not apply to your export if you're not receiving cost and usage data for the related scenario. For example, if your export doesn't have any line items that are corrections of a previous bill, then the conformance gap for ChargeClass column will not apply.
At this time, you will need to identify whether or not each individual conformance gap is relevant for your cost and usage analysis.
Conformance gap type | Affected column | FOCUS 1.0 requirement | Conformance gap description |
---|---|---|---|
Missing data | ChargeClass | ChargeClass is a required column to indicate whether a particular line item is a correction for a past billing period. | No line items will be identifiable as corrections in this column at this time. |
ContractedUnitPrice | ContractedUnitPrice must not be null for Usage and Purchase ChargeCategory line items that are not corrections. | ContractedUnitPrice might be null for certain product offerings. | |
InvoiceIssuerName | InvoiceIssuerName must not be null. | InvoiceIssuerName might be null for certain charges. | |
ListUnitPrice | ListUnitPrice must not be null for Usage and Purchase ChargeCategory line items that are not corrections. | ListUnitPrice might be null for certain product offerings. | |
PricingUnit | PricingUnit must not be null for Usage and Purchase ChargeCategory line items that are not corrections. | PricingUnit might be null for certain product offerings. | |
ProviderName | ProviderName must not be null. | ProviderName might be null for certain charges. | |
ResourceName | ResourceName is a required column for displaying a name that a user assigned to a given resource. | This column will only have EC2 Instance and EBS volume resource names assigned by customers. No other resource names will appear in this column. Any resource names that are assigned as tags will appear in the tags column. | |
SkuPriceId | SkuPriceId must not be null for Usage and Purchase ChargeCategory line items that are not corrections. | SkuPriceId might be null for certain line items when it should not be. | |
SkuId | SkuId must not be null for Usage and Purchase ChargeCategory line items that are not corrections. | SkuId might be null for certain product offerings. | |
Incorrect data | BilledCost | The sum of BilledCost must match the invoice. | There may be situations when the sum of BilledCost might not match the invoice. |
BilledCost EffectiveCost |
BilledCost and EffectiveCost are columns that require discounts to be included in their values for easy validation of discounts. |
For customers not on discount automation, these columns will not contain the correct costs for usage line items. However, the discounts will appear as separate line items, so the summed total of costs will still be accurate. |
|
ConsumedQuantity | ConsumedQuantity is a required column for showing the amount of usage you actually used. |
ConsumedQuantity will contain the amount of usage you were charged for. This means that ConsumedQuantity could be incorrect in situations where a minimum charge quantity applied for a particular service. For example, there is a 10MB minimum for an Athena query and a 10 minute minimum Glue crawler run. For these services, ConsumedQuantity will show the value that includes the minimum charged quantity. |
|
ContractedCost | ContractedCost must equal
ContractedUnitPrice x PricingQuantity for charges that
are not corrections. |
ContractedCost might not be consistent with ListUnitPrice and PricingQuantity for certain charges, such as credits. | |
ContractedCost | ContractedCost must reflect any agreed pricing with a provider. | For any Usage line items covered by Savings Plans or Reserved Instances, ContractedCost will be equal to ListCost even if discounts apply. | |
ContractedUnitPrice | ContractedUnitPrice must reflect any agreed pricing with a provider. | For any Usage line items covered by Savings Plans or Reserved Instances, ContractedUnitPrice will be equal to ListUnitPrice even if discounts apply. | |
ListCost | ListCost must equal
ListUnitPrice x PricingQuantity for charges that are
not corrections. |
ListCost might not be consistent with ListUnitPrice and PricingQuantity for certain charges, such as credits. | |
PricingCategory | PricingCategory must be "Dynamic" for all Spot charges. | PricingCategory might be incorrect for certain EC2 Spot line items. | |
ListCost | ListCost must equal BilledCost for ChargeCategory of Credit. | ListCost might not equal BilledCost for ChargeCategory of Credit. | |
Tags |
Tags is a required column for displaying tags applicable to a given line item. This column requires that a provider (i) adds a prefix to the keys of provider-created tags only, and (ii) does not modify tag names. |
There are two gaps: (i) User-created tag keys will have a prefix to indicate that it is a user-created tag. (ii) Provider and user tag key names are normalized to have no capitalization, no spaces, and no special characters other than "_". When normalization causes tag key conflicts, only one tag value is kept. |