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.
| 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 | ReservationIdBenefitId | |
| Commitment Name | ReservationNameBenefitName | |
| Instance Type | additionalInfos.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. |