Dimensions and labels
Overview
Cloud Analytics provides a variety of billing dimensions, including logical groupings of resources (e.g., accounts, projects) and resource-level metadata (e.g., labels, tags). They help you break down your cloud spend and build a granular view of your cost and usage data.
Date/Time
When creating a new report, the Year, Month, and Day dimensions are added by default. The Date/Time dimensions are related with the report setting Time Interval.
Standard dimensions
Attribution: Choose one or more existing attributions to attribute your cloud spend.
Cloud: Choose your cloud providers. Options: Amazon Web Services, Google Cloud, Microsoft Azure.
Country, Region, Zone: The cloud location where resources are deployed. See AWS Regions and Availability Zones and Google Cloud Locations — Regions & Zones.
The only valid dimension for Microsoft Azure is Region, which maps to the cost details field
MeterRegion
and is the name of the datacenter location for services priced based on location. See What are Azure regions and availability zones.Unit: This dimension corresponds to the basic metric Usage. It varies by service and generally refers to their unit of measure. For example, Core — hour; Ram — gibibyte hour; EC2 — vCPU-Hours.
Hierarchy groups
Billing Account: This is your billing account ID in the DoiT Platform.
Amazon Web Services: Your DoiT customer ID if you're on a Dedicated payer account, or your CloudHealth account ID and account name if you're on a Consolidated billing account.
Google Cloud: Your Google Cloud Billing account ID and account name. You can also find this information on the DoiT Console's Assets page or the Google Cloud console's Manage Billing Accounts page.
Microsoft Azure: The unique identifier for your Azure subscription. It maps to the cost details field
SubscriptionId
. You can also find the Subscription ID on the DoiT Console's Assets page.
Folder: Folders are nodes in the Google Cloud resource hierarchy. A folder can contain projects, other folders, or both.
When using the Folder dimension, make sure to include the folders that are parents of the target projects. For example, to view the costs of a folder and all its nested folders, you can use the regexp
/{ORG_ID}/{FOLDER_ID}/(/[0-9]*)+
as the filter; selecting/{ORG_ID}/{FOLDER_ID}/
will return only the direct cost of the top-level folder.Project/Account ID:
Amazon Web Services: Your 12-digit AWS account ID and the associated asset name. For example,
123412341234 (my-video-asset)
.Google Cloud: The project ID, a globally unique identifier for your Google Cloud project. All of the Flexsave projects attached to your Google Cloud Billing account are aggregated into one single item under the Project/Account ID
doitintl-fs
. See Flexsave projects/accounts for an example use case.Microsoft Azure: Name of the Azure resource group the resource is in. Azure Project/Account ID maps to the cost details field
ResourceGroup
.
Project/Account name:
Amazon Web Services, Microsoft Azure: The same as Project/Account ID.
Google Cloud: The human-readable project name.
All of the Flexsave projects attached to your Google Cloud Billing account and the Flexsave accounts added to your AWS organization are aggregated into one single item under the Project/Account name
Flexsave
. See Flexsave projects/accounts for an example use case.
Project/Account number: For Google Cloud, this is the automatically generated project number.
Resource metadata
Resource: An identifier of the resource that generated relevant usage. This dimension can be used to list individual virtual machines or Identify granular cost data by service.
Amazon Web Services: The ID of the resource that you provisioned. For an Amazon EC2 compute instance, this field contains the instance ID. See AWS Cost and Usage Reports Line item details: lineItem/ResourceId and Resource IDs for more information.
Google Cloud: Derived from the
resource.name
field in the detailed usage cost data export. It contains the name provided by the user. For a Compute Engine virtual machine (VM) instance, this field contains the instance name of the VM. For example,projects/{PROJECT_ID}/instances/{INSTANCE_NAME}
.Microsoft Azure: Unique identifier of the Azure Resource Manager resource. It maps to the cost details field
ResourceId
and is the fully qualified ID of the resource, including the resource name and resource type.
Service: The name or short description of the service that the usage is associated with. A service is the high-level type of cloud technology that can be broken down into SKUs. Azure Service maps to the cost details field
MeterCategory
, which is the name of the classification category for the meter. For example, Cloud services and Networking.Service ID: The identifier of the service that the usage is associated with. Azure Service ID maps to the cost details field
MeterId
.SKU: A description of the resource type used by the service. A SKU is the resource itself for which there's a given Price Per Unit. See AWS Cloud Services Pricing and prices for Google's cloud services. Azure SKU descriptions map to the cost details field
MeterSubCategory
.SKU ID: The identifier of the resource used by the service. See AWS Cost and Usage Reports Product details: product/sku and Google Cloud SKUs. Azure SKU IDs map to the cost details field
ProductId
.Marketplace: This dimension helps distinguish between services purchased from Marketplace and services provided by cloud providers. See Marketplace expenses for an example.
Global Resource (Google Cloud specific): A globally unique Google Cloud service identifier for the resource that generated relevant usage. This dimension is based on the
resource.global_name
field in the Google Cloud Billing detailed usage cost data export.For a Compute Engine virtual machine (VM) instance, this field contains the instance ID of the VM and is a unique numeric string assigned by Google Cloud. For example,
//compute.googleapis.com/projects/{PROJECT_ID}/zones/{ZONE}/instances/{INSTANCE_ID}
.Note that not all resources have an identifier. Resources without Global Resource identifiers are shown as
Global Resource N/A
in Cloud Analytics reports. See also Identify granular cost data by service.Operation:
Amazon Web Services: The specific AWS operation that generated relevant usage. For example, a value of
RunInstances
indicates the operation of an Amazon EC2 instance.Microsoft Azure: The name for the meter. It maps to the cost details field
MeterName
.
Credits and discounts
The dimensions below help you view and analyze your credits and discounts.
Cost Type: The type of charge represented by the line item. Cost types are defined by cloud providers and DoiT. Below are the most common cost types:
regular
: Costs for Google Cloud services. See Google Cloud Schema of the standard usage cost data:cost_type
. Note that credits that Google Cloud applied to your bill fall into this category.Usage
: Usage charged at AWS On-Demand Instance rates. See AWS Cost and Usage Reports Line item details:lineItem/LineItemType
.OnDemand
,Reservation
,Spot
: Identifier that indicates how the Azure meter is priced. See cost details field:PricingModel
.Credit
: DoiT promotional credits and any credits that AWS applied to your bill.Credit Adjustment
: Adjustments applied to DoiT promotional credits when your contract with DoiT includes discounts.Discounts are not applicable to costs covered by credits. When promotional credits are included in the report (cost type
Credit
), we add the correspondingCredit Adjustment
to negate the costs covered by credits. See also Google Cloud adjustments and Promotional credits in reports.Flexsave
,FlexsaveCoveredUsage
,FlexsaveNegation
,FlexsaveRecurringFee
: See DoiT Flexsave cost types for more information.
Credit: AWS credits, DoiT promotional credits, and Google Cloud's credits such as committed use discounts, sustained use discounts, or free-tier usage of a service (note that the Cost Type of Google Cloud credits is
regular
).Savings Type (AWS specific): This dimension is used together with the Savings metric. It allows you to view your savings accrued on AWS through your relationship with DoiT across various pricing programs. You can monitor the savings generated by DoiT Flexsave, Enterprise Discount Program (EDP), and Private Pricing Agreement (PPA).
Labels
Labels in DoiT Platform are key-value pairs that are used for identifying, organizing, and grouping resources to help track cloud spend. They can be user-defined or generated by cloud providers or DoiT.
When creating reports in DoiT Console, you will see label dimensions in different categories:
Labels: AWS cost allocation tags, Google Cloud labels, and Azure tags (no resource group tags) assigned to resources.
Project Labels (Google Cloud specific): Labels set on the Google Cloud project level.
System labels: Labels systematically generated by DoiT, AWS, Google Cloud, and Microsoft Azure.
System labels
System Labels are systematically generated by DoiT and cloud service providers (AWS, Google Cloud, and Microsoft Azure).
Most of the system labels generated by DoiT or Google Cloud are automatically replaced with a short name or alias once selected. AWS and Azure labels are not assigned any alias and stay the same whether selected or not.
By DoiT
cmp/commitment_type (alias:
CUD Type
): Commitment types. Examples: General purpose N1 commitments, Compute-optimized C2 commitments.cmp/compute_resource_name (alias:
GCE Resource
): Google Compute Engine resource names. Examples: CPU, memory, extended memory.cmp/eligible_for_commitment (alias:
CUD Eligible
): Workloads eligible for committed use discounts (CUDs).cmp/flexsave_eligibility: Flexsave eligibility of AWS workloads. See Flexsave coverage for its application in the preset report.
cmp/flexsave_project: The globally unique project IDs of the Flexsave projects attached to your Google Cloud Billing account.
cmp/machine_type (alias:
Machine Type
): Machine types. Examples: C2 Compute-optimized, E2 General-purpose.cmp/memory_to_core_ratio (alias:
GB/CPU
): The amount of memory (RAM) per CPU core.doitintl-cud-source: This label can be used to identify custom billing data generated by DoiT Flexsave. It can be combined with the SKU dimension for further breakdown. See Flexsave CUDs for an example.
pricebook/rule_name: The rule name defined in the price book. It helps identify the specific rule applied to a given resource and understand the context of the applied pricing structure. For example, choosing the rule name
EDP
allows you to analyze your AWS Enterprise Discount Program contract pricing. See AWS Enterprise Discount Program (EDP) analysis for its application.pricebook/rate_value: The applied discount rate to your AWS resources. For example, a 7% EDP will be displayed as
0.93
.
By Google Cloud
compute.googleapis.com/cores (alias:
Cores
): The number of vCPUs available to the virtual machine.compute.googleapis.com/memory (alias:
Memory
): The amount of memory (in GB) available to the virtual machine.compute.googleapis.com/machine_spec (alias:
Machine Spec
): The machine types for your VMs.compute.googleapis.com/is_unused_reservation (alias:
Unused Reservation
): Unused zonal reservations.
Google Cloud Docs: Available system labels
By AWS
This section highlights AWS system labels that are of particular interest when analyzing AWS cost and usage data.
aws/item_desc: The description of the line item. For example, the type of usage incurred during a specific time period.
You can use this label to check discounts or rates of your AWS support plans. See AWS support plan charges.
Columns in AWS Cost and Usage Reports (AWS CUR): Data dictionary
By Microsoft Azure
Azure system labels in the DoiT Console are mapped from the cost details field AdditionalInfo
.
They are service-specific metadata. For example, an image type for a virtual machine.
Attribution groups
Select an attribution group to distribute the data collected for a particular metric. Useful for cost allocation.
Google Kubernetes Engine and GKE labels
For GKE dimensions and labels, see Understand GKE costs.
Examples
Flexsave projects/accounts
This example shows how to combine the standard dimensions (Project/Account name and Project/Account ID) and the system label cmp/flexsave_project to organize your Flexsave projects/accounts in a Cloud Analytics report.
Virtual machines
This example shows how to list the individual VM instances using the standard dimension Resource.
- For Amazon Elastic Compute Cloud (EC2) service, resources that have resource IDs starting with
i-
are Amazon EC2 instances. - For Google Cloud Compute Engine service, the last part of each resource ID is the instance name of the VM.
To view GCE instance IDs, choose the dimension Global resource.
Granular cost analytics on Google Cloud Run and Cloud Functions
This example shows how to combine the standard dimensions Service, Resource and SKU to identify granular cost data from Google Cloud Run instances and Cloud Function instances.
AWS Enterprise Discount Program (EDP) analysis
This example shows how to investigate the AWS EDP pricing using a Cloud Analytics report.
The cost values are the amount the customer pays for the resources after the EDP was applied.
Marketplace expenses
This example shows how to use the Marketplace dimension to report on costs incurred from Marketplace purchases.
To drill down further, you can add a filter, e.g., Marketplace equals true
, and combine with other dimension .
AWS support plan charges
This example shows the costs of AWS support plans.
Starting June 2023, AWS support plans are charged on the last day of the invoice month.