Microsoft Azure Enterprise Agreement Bill-Based Data Dimensions

Data for Microsoft Azure is sourced from the Enterprise billing Cost Details API. The following source columns are the fields from that API response. For more information, see Microsoft’s documentation on Azure Billing API.

Table 1 • Microsoft Azure Enterprise Agreement Bill-Based Data Dimensions

Cloud Cost Optimization Dimension

Source Column

Notes

Bill Entity

PublisherType 

Use this dimension to identify marketplace spend and nonmarketplace spend.

Billing Account ID

BillingAccountId 

 

Cloud Vendor

N/A 

Always Microsoft Azure.

Cloud Vendor Account

SubscriptionId 

Unique identifier for the Azure subscription.

Cloud Vendor Account Name

SubscriptionName 

Name of the Azure subscription.

Commitment ID

ReservationId 

benefitId 

 

Commitment Name

ReservationName 

benefitName 

 

Datacenter

 

N/A for Azure.

Instance Type

AdditionalInfo.ServiceType 

 

Invoice ID

InvoiceId 

The unique document ID listed on the invoice PDF.

Manufacturer Name

PublisherName 

Publisher for Marketplace services.

Operating System

N/A

Note:The name is derived from details from the virtual machine and virtual machine license.

Name of the operating system, such as Windows, Linux, Red Hat Enterprise, etc.

Product Order Name

ProductOrderName 

Unique name for the product order.

Purchase Option

PricingModel 

Identifier that indicates how the meter is priced. (Values: On Demand, Reservation, and Spot).

Note:On demand Non-Discountable is not an option for Azure EA.

Region

MeterRegion 

Name of the datacenter location for services priced based on location.

Resource Group

ResourceGroup 

Name of the resource group the resource is in. Not all charges come from resources deployed to resource groups. Charges that don't have a resource group are shown as null or empty, Others, or Not applicable.

Resource ID

InstanceId 

Available in Cloud Cost Optimization for the last 31 days in daily granularity or last 3 months in monthly granularity.

Resource Type

MeterCategory 

SubCategory is excluded if it's the same as Category.

“Marketplace Charge-[PublisherName]” for marketplace charges.

“Reservation Order-[Description]” for Reserved Instance charges.

Service

ConsumedService 

Prepends “Microsoft.” if not already present.

Usage Type

MeterName 

The name of the meter. Purchases and Marketplace usage may be shown as blank or unassigned.

Usage Unit

UnitOfMeasure 

This dimension represents the units in which the “Usage Amount” metric is measured.