Skip to main content

Dimensions and labels

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 the options when the data source is the audit log sink of the 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​

  • Attribution: Choose one or more existing attributions to attribute your cloud spend.

  • Provider: Choose your data providers. Options: Amazon Web Services, Google Cloud, Microsoft Azure, and Snowflake. If your data source includes DataHub data, this dimension also identifies the provider of the ingested data.

  • 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:

  • Project/Account name:

    • Amazon Web Services, Microsoft Azure: The same as Project/Account ID.

      All of 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.

    • Google Cloud: The human-readable project name.

  • 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 costs, credits, and discounts.

  • Cost Type: The type of charge. Cost types are defined by cloud providers and DoiT. Note that DoiT recalculates billing data from cloud providers to factor in DoiT discounts, custom pricing, Flexsave, and other items when applicable.

    Tip

    Unless stated otherwise, this section describes cost types as measured in the Cost metric.

    Cost types relevant to Amazon Web Services:

    • BundledDiscount: A usage-based discount of a service or feature based on the usage of another service or feature.

    • Credit: DoiT promotional credits and any credits that AWS applied to your bill.

    • DiscountedUsage: For the Cost metric, this item is always 0; for the Usage metric, it shows the usage of any instances covered by your own Reserved Instances (RI).

    • EDP: AWS Enterprise Discount Program (EDP).

    • Fee: EDP on upfront charges and exchange charges that you paid for RIs.

    • Flexsave: Savings generated by DoiT Flexsave AWS. Valid for consolidated resold accounts.

    • FlexsaveCoveredUsage: The on-demand cost of Compute and SageMaker covered by Flexsave. Flexsave covered usage items are offset by the corresponding Flexsave negation items. This and the following Flexsave items are valid for dedicated resold accounts.

    • FlexsaveNegation: The Compute savings and SageMaker savings generated by Flexsave.

    • FlexsaveRecurringFee: Recurring charges related to Flexsave Savings Plans. The Flexsave recurring fee is always 0 for the Cost metric.

    • FlexsaveRIFee: The monthly recurring fee for Reserved Instances (RI) attached to your organization by Flexsave. You incur this cost only when the RI utilization is above 50%.

    • FlexsaveRefund: The refund for RIs attached to your organization by Flexsave. You get a refund when the RI utilization is below 50%.

    • FlexsaveManagementFee: Administrative fees charged by DoiT for the Flexsave for RDS service.

    • FlexsaveUsage: The rate for DB instances covered by Flexsave. Due to an known issue, savings generated by Flexsave for RDS are currently attached to the cost type FlexsaveManagementFee when the metric is Savings.

    • RIFee: The monthly recurring charges for your own Partial Upfront RIs and No Upfront RIs. The RI fee is charged on the first day of each month.

    • RiVolumeDiscount: Amazon EC2 Standard Reserved Instance Volume Discounts applied to your bill.

    • PrivateRateDiscount: Private Pricing Agreement (PPA) discounts applied to your bill.

    • Refund: Negative charges applied to your bill.

    • SavingsPlanCoveredUsage: Any on-demand cost that is covered by your own Savings Plan. Savings Plan covered usage items are offset by the corresponding Savings Plan negation items.

    • SavingsPlanNegation: Any offset cost through your Savings Plan benefit that's associated with the corresponding Savings Plan covered usage item. See AWS Savings Plans line items.

    • SavingsPlanRecurringFee: Any recurring hourly charges that correspond with your No Upfront or Partial Upfront Savings Plans.

    • SavingsPlanUpfrontFee: Any one-time upfront fee from your purchase of All Upfront or Partial Upfront Savings Plans.

    • SppDiscount: AWS Solution Provider Program discount. This item is valid only if you do not purchase AWS from DoiT and you have AWS activate or migrate credits.

    • Tax: Taxes that DoiT applied to your bill based on your billing profile.

    • Usage: Usage charged at AWS On-Demand Instance rates.

    Cost types relevant to Google Cloud:

    Cost types relevant to Microsoft Azure: The cost types listed below correspond to the cost details field PricingModel.

  • Credit: AWS credits, DoiT promotional credits, and Google Cloud's credits such as Committed Usage Discount, sustained Usage Discount, or Free tier discount.

  • 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:

System labels​

System Labels are systematically generated by DoiT and data providers (AWS, Google Cloud, Microsoft Azure, and Snowflake).

Note

Most of the system labels generated by DoiT or Google Cloud are automatically replaced with a short name or alias once selected. Other 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/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.

  • 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 fields. Below is a non-exhaustive list of available Azure system labels:

  • azure/charge_type: Indicates whether the charge relates to Usage, a Purchase, or a Refund. See Azure usage, purchases, and refunds for an example report.

  • azure/ReservationId: Unique identifier for the purchased reservation instance.

  • azure/ServiceInfo: Service-specific metadata.

  • azure/product_order_name: Unique name for the product order.

  • azure/publisher_name: The name of the publisher.

  • azure/service_family: Service family that the service belongs to.

  • azure/subscription_name: Name of the Azure subscription.

  • Labels mapped from the AdditionalInfo field: Service-specific metadata. For example, an image type for a virtual machine.

By Snowflake​

See System labels by Snowflake.

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.

AWS Organization Tags​

You can use AWS Organization tags to track AWS resources across your AWS Organizations, regardless of the account they belong to.

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.

Suppose your environment has over 5,000 resources, regardless of their types (S3 buckets, EC2 instances, etc.). If you use the Resource dimension to filter results, you'll notice that only the first 5,000 resources (in alphabetical order) are available.

In such a case, you can use the Advanced option to add a regular expression to include the desired values. If you're looking for a specific value, you can also click + to add the exact value to the filters.

Add a new filter

See also​

Last updated on