Skip to main content

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.

Note

See Metrics and dimensions for specific options when the data source is BigQuery Lens.

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

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:

  • 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}.

    • For Cloud Storage, the first full day of granular cost data is February 13, 2024. See GCS Cost by Bucket for an example of viewing granular Cloud Storage bucket-level cost data.

    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:

  • 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).

See also

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.

    See also
  • 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).

Note

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.

See also

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.

See also

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.

Kubernetes dimensions and labels

DoiT Cloud Analytics supports Kubernetes cost analysis for containerized workloads running on AWS and Google Cloud:

Attribution groups

Select an attribution group to distribute the data collected for a particular metric. Useful for cost allocation.

Data ingestion limits

To ensure optimum performance, the DoiT Console limits the maximum number of values it can store and load on a user's browser to 5,000 per dimension/label. Values beyond the limit are not visible when editing reports.

To incorporate these values into a report, you can construct a regular expression to filter results and include the desired values.

Examples

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.

Cloud Analytics report for Cloud Run and Cloud Functions

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.

Cloud Analytics report for Cloud Run and Cloud Functions

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.

Cloud Analytics report for AWS Enterprise Discount Program

See also

Marketplace expenses

This example shows how to use the Marketplace dimension to report on costs incurred from Marketplace purchases.

Marketplace expenses

To drill down further, you can add a filter, e.g., Marketplace equals true, and combine with other dimension .

Marketplace expenses by services

AWS support plan charges

This example shows the costs of AWS support plans.

AWS support plan charges

Note

Starting June 2023, AWS support plans are charged on the last day of the invoice month.

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.

Cloud Analytics report for Cloud Run and Cloud Functions