Microsoft Azure Modern Commerce Agreement (MCA) Bill-Based Data Dimensions

Data for Microsoft Azure MCA is sourced from the Consumption Usage Details API. The following source columns are the fields from that API response. For more information about the fields, see Azure Consumption Usage Details API.

Table 1 • Microsoft Azure MCA 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

Microsoft Azure CSP (Modern Commerce) or Microsoft Azure (Modern Commerce).

Cloud Vendor Account

SubscriptionId

 

Cloud Vendor Account Name

SubscriptionName 

 

Commitment ID

ReservationId 

BenefitId 

 

Commitment Name

ReservationName 

BenefitName 

 

Instance Type

additionalInfo.serviceType

 

Product Order Name

productOrderName

 

Region

resourceLocation

Falls back to meterRegion if the location can't be mapped. Values are normalized to a common format.

Resource Group

resouceGroup

 

Resource ID

instanceId

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

Resource Name

 

Available only in Monthly CSV Reports in Billing Centers.

Resource Type

meterCategory-meterSubCategory

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.

Always “Microsoft.Marketplace” for marketplace charges.

Always “Microsoft.Reservation” for Reserved Instance charges.

Service Family

serviceFamily

 

Usage Type

meterName

 

Usage Unit

unitOfMeasure

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