views/revenue/revenue.view.lkml

# Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue.view.lkml
include: "account_from_account_revenue.view.lkml"
include: "comparisons_from_revenue.view.lkml"
include: "revenue_from_revenue.view.lkml"
# include: "revenue_dailies.view.lkml"
include: "revenue_from_project_usage_daily.view.lkml"
include: "to_date_fields.view.lkml"
include: "rolling_window.view.lkml"
include: "/views/region.view.lkml"


view: revenue {

  extends: [account_from_revenue, comparisons_from_revenue, revenue_from_revenue, to_date_fields, rolling_window, region, revenue_from_project_usage_daily]

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

########## DIMENSIONS ############

  dimension: access_key_hierarchy {
    description: "Pipe-separated string containing the usernames of individuals assigned to the associated Vector account and everyone in their reporting hierarchy"
    sql: ${TABLE}.access_key_hierarchy ;;
  }

  dimension: access_tag_list {
    description: "Pipe-seperated string containing access information such as Segment, Region, etc"
    hidden: yes
    type: string
    sql: ${TABLE}.access_tag_list ;;
  }

  dimension: nal_id {
    sql: ${TABLE}.nal_id ;;
  }

  ##### PARAMETERS #####

  parameter: revenue_granularity {
    view_label: "Pre- or Post-Split"
    description: "Allows the user to toggle between split revenue and non-split revenue. Default value is Split"
    allowed_value: {
      value: "Split"
    }
    allowed_value: {
      value: "Non-Split"
    }
    default_value: "Non-Split"
  }
}