views/revenue/revenue.view.lkml

# Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue.view.lkml

# bits from:
# https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/account_from_account_revenue.view.lkml
view: revenue {


  sql_table_name: `concord-test.stagingservice_gcc.gcc_revenue_partitioned_view`;;

  dimension: billing_account_id {
    view_label: "Account"
    group_label: "Identifiers"
    description: "Billing account ID"
    sql: ${TABLE}.billing_account_id ;;
  }

  dimension: sfdc_account_id {
    alias: [account_meta.sfdc_account_id]
    label: "SFDC Account ID"
    view_label: "Account"
    description: "Salesforce account of the opportunity"
    type: string
    sql: ${TABLE}.sfdc_account_id ;;
    link: {
      label: "Account in Vector"
      url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view"
    }
  }

  dimension: currency_code {
    view_label: "Revenue"
    description: "Three letter currency code (e.g. USD) for local billing amount."
    sql: ${TABLE}.currency_code ;;
  }

  dimension_group: invoice_month_start {
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    view_label: "Revenue"
    sql: ${TABLE}.invoice_month_start ;;
    datatype: date
    convert_tz: no
  }

  dimension: product_family_l1 {
    label: "Product Family (L1)"
    group_label: "Finance Product Hierarchy"
    view_label: "Product"
    description: "Examples: Google Workspace, GCP, Maps, PSO"
    sql: ${TABLE}.product_group ;;
    drill_fields: [product_group_l2]
  }
  dimension: product_group_l2 {
    label: "Product Group (L2)"
    group_label: "Finance Product Hierarchy"
    view_label: "Product"
    description: "Examples: Marketplace Services, Compute, Support, Databases, etc."
    sql: ${TABLE}.product_group_l2 ;;
    drill_fields: [logical_product_l3]
  }
  dimension: logical_product_l3 {
    label: "Logical Product (L3)"
    group_label: "Finance Product Hierarchy"
    view_label: "Product"
    description: "Examples: Persistent Disk, VM Image Storage, GCE"
    sql: ${TABLE}.logical_product_l3 ;;
  }

  dimension: usd_revenue_gross {
    # hidden: yes
    view_label: "Revenue"
    description: "Monetised value for resource consumption, before application of any credits, reported in USD($) using a monthly Ceilometer exchange rate. (Generally a positive number)"
    sql: ${TABLE}.usd_revenue_gross ;;
  }
  dimension: usd_revenue_gross_cn {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_gross_cn ;;
  }
}