view: awal_sax_salesforce_opportunities {
  sql_table_name: AWAL_SAX.SALESFORCE.OPPORTUNITY ;;

  dimension: ID {
    view_label: "ID"
    label: "ID"
    type:  string
    sql: ${TABLE}.ID ;;
  }

  dimension: ACCOUNTID {
    view_label: "ID"
    label: "Account ID"
    type:  string
    sql: ${TABLE}.ACCOUNTID ;;
  }

  dimension: Name {
    view_label: "Artist"
    label: "Name"
    type:  string
    sql: ${TABLE}.Name ;;
  }
  dimension: Stage_Name {
    view_label: "Opportunity"
    label: "Stage Name"
    type:  string
    sql: ${TABLE}.STAGENAME ;;
  }
  measure: ADV_OFFER_C {
    view_label: "Advance"
    label: "Total Adv Offer"
    type:  sum                       #check this
    sql: ${TABLE}.ADV_OFFER__C ;;
  }

  measure: ADVANCE_AMOUNT__C {
    view_label: "Advance"
    label: "Advance Amount"
    type:  sum                       #check this
    sql: ${TABLE}.ADVANCE_AMOUNT__C ;;
  }
  dimension: ADVANCE_COMMENT__C {
    view_label: "Advance"
    label: "Advance Comment"
    description: "Advance Structure/ Payment Instructions"
    type:  string
    sql: ${TABLE}.ADVANCE_COMMENT__C ;;
  }
  dimension: ADVANCE_RANGE__C {
    view_label: "Advance"
    label: "Advance Range"
    description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.ADVANCE_RANGE__C ;;
  }
  dimension: ADVANCE_STRUCTURE__C {
    view_label: "Advance"
    label: "Advance Structure"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.ADVANCE_STRUCTURE__C ;;
  }
  measure: ADVANCE_ON_DELIVERY__C {
    view_label: "Advance"
    label: "Advance On Delivery"
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.ADVANCE_ON_DELIVERY__C ;;
  }
  dimension: ARTIST_ETHNICITY_RACE__C {
    view_label: "Artist"
    label: "Artist Ethnicity Race"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.ARTIST_ETHNICITY_RACE__C ;;
  }
  dimension: ARTIST_GENDER__C {
    view_label: "Artist"
    label: "Gender"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.ARTIST_GENDER__C ;;
  }
  dimension: ARTIST_CLIENT_LOCATION__C {
    view_label: "Artist"
    label: "Artist Location"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.ARTIST_CLIENT_LOCATION__C ;;
  }
  dimension: RECORDINGS_SERVICE_TYPE__C {
    view_label: "Artist"
    label: "Service Type"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.RECORDINGS_SERVICE_TYPE__C ;;
  }

  dimension: OPPORTUNITY_ID__C {
    view_label: "ID"
    label: "Opportunity ID"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.OPPORTUNITY_ID__C ;;
  }
  dimension: BA_PROCESS_STATUS__C {
    view_label: "Opportunity"
    label: "BA Process Status "
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.BA_PROCESS_STATUS__C ;;
  }
  dimension: CATALOG_SIZE__C {
    view_label: "Opportunity"
    label: "Catalog Size "
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.CATALOG_SIZE__C ;;
  }
  dimension: DEAL_CURRENCY__C {
    view_label: "Opportunity"
    label: "Deal Currency "
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.DEAL_CURRENCY__C ;;
  }
  dimension: DEAL_ID__C {
    view_label: "ID"
    label: "Deal ID "
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.DEAL_ID__C ;;
  }
  measure: EST_FIRST_YEAR_REV_NR__C {
    view_label: "Revenue"
    label: "EST First Year Revenue "
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.EST_FIRST_YEAR_REV_NR__C ;;
  }
  measure: EST_TERM_REV_BASE_CASE__C {
    view_label: "Revenue"
    label: "EST Term Revenue Base Case"
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.EST_TERM_REV_BASE_CASE__C ;;
  }
  measure: EST_TERM_REV_NR__C {
    view_label: "Revenue"
    label: "EST Term Revenue "
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.EST_TERM_REV_NR__C ;;
  }
  measure: ESTIMATED_REVENUE_BASE_CASE__C {
    view_label: "Revenue"
    label: "Estimated Revenue Base Case "
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.ESTIMATED_REVENUE_BASE_CASE__C ;;
  }
  measure: ESTIMATED_REVENUE_HIGH_CASE_USD__C {
    view_label: "Revenue"
    label: "Estimated Revenue High Case USD "
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.ESTIMATED_REVENUE_HIGH_CASE_USD__C ;;
  }
  measure: ESTIMATED_REVENUE_LOW_CASE_USD__C {
    view_label: "Revenue"
    label: "Estimated Revenue low Case USD  "
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.ESTIMATED_REVENUE_LOW_CASE_USD__C ;;
  }
  dimension: FINAL_BASE_CASE_IRR__C {
    view_label: "Revenue"
    label: "Final Base Case IRR"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.FINAL_BASE_CASE_IRR__C ;;
  }
  dimension: HEADLINE_RATE_DIGITAL__C {
    view_label: "Rates"
    label: "Headline rate digital"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.HEADLINE_RATE_DIGITAL__C ;;
  }
  dimension: HEADLINE_RATE_PHYSICAL__C {
    view_label: "Rates"
    label: "Headline rate Physical"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.HEADLINE_RATE_PHYSICAL__C ;;
  }
  measure: THREE_YEAR_NPS__C {
    view_label: "Revenue"
    label: "Three Year NPS"
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.THREE_YEAR_NPS__C ;;
  }
  measure: THREE_YEAR_REVENUE__C {
    view_label: "Revenue"
    label: "Three Year Revenue"
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.THREE_YEAR_REVENUE__C ;;
  }
  dimension: OPPORTUNITY_TYPE__C {
    view_label: "Opportunity"
    label: "Opportunity type"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.OPPORTUNITY_TYPE__C ;;
  }
  dimension: MARKETING_FUND_ADMINISTRATION__C {
    view_label: "Marketing"
    label: "Marketing Fund Administration"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.MARKETING_FUND_ADMINISTRATION__C ;;
  }
  dimension: MARKETING_FUND_CATEGORIES_OF_EXPENDITURE__C {
    view_label: "Marketing"
    label: "Marketing Fund Categories"
    description: "Marketing fund categories of Expenditure"
    type:  string
    sql: ${TABLE}.MARKETING_FUND_CATEGORIES_OF_EXPENDITURE__C ;;
  }
  dimension: MARKETING_FUND_PAYMENT_INSTRUCTIONS__C {
    view_label: "Marketing"
    label: "Maketing Fund Payment Instruction"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.MARKETING_FUND_PAYMENT_INSTRUCTIONS__C ;;
  }
  dimension: MARKETING_FUND_PAYMENT__C{
    view_label: "Marketing"
    label: "MARKETING FUND PAYMENT"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.MARKETING_FUND_PAYMENT__C;;
  }
  dimension: MARKETING_FUND__C{
    view_label: "Marketing"
    label: "Marketing Fund"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.MARKETING_FUND__C;;
  }
  measure: FINAL_MARKETING_FUND__C {
    view_label: "Marketing"
    label: "Total Marketing Fund"
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.FINAL_MARKETING_FUND__C ;;
  }
  dimension: OTHER_ADVANCES__C{
    view_label: "Advance"
    label: "Other Advances"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.OTHER_ADVANCES__C;;
  }
  dimension: OTHER_RECOUPABLE_COSTS_DETAILS__C{
    view_label: "Advance"
    label: "Other Recoupable Costs Details"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.OTHER_RECOUPABLE_COSTS_DETAILS__C;;
  }
  dimension: PRIMARY_EVALUATOR__C{
    view_label: "Opportunity"
    label: "Primary Evaluator"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.PRIMARY_EVALUATOR__C;;
  }
  dimension: PRIMARY_GENRE__C{
    view_label: "Artist"
    label: "Primary Genre"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.PRIMARY_GENRE__C;;
  }
  dimension: TERM_IN_YEARS__C{
    view_label: "Opportunity"
    label: "Term in Years"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.TERM_IN_YEARS__C;;
  }
  dimension: TERM_YRS__C{
    view_label: "Opportunity"
    label: "Term Years"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.TERM_YRS__C;;
  }
  dimension: DIGITAL_RATE__C{
    view_label: "Rates"
    label: "Digital Rate"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.DIGITAL_RATE__C;;
  }
  measure: LEGAL_FEES_CONTRIBUTION_BA__C{
    view_label: "Advance"
    label: "Legal Fees Contribution BA"
    #description: "Expected Advance Range"
    type:  sum
    sql: ${TABLE}.LEGAL_FEES_CONTRIBUTION_BA__C;;
  }
  dimension: AGREEMENT_TYPE__C{
    view_label: "Opportunity"
    label: "Agreement Type"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.AGREEMENT_TYPE__C;;
  }
  dimension: DEAL_BROKER__C{
    view_label: "Opportunity"
    label: "Deal Broker "
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.DEAL_BROKER__C;;
  }
  dimension: BA_PROCESS_STATUS_REPORTING__C{
    view_label: "Opportunity"
    label: "BA Process Status Reporting"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.BA_PROCESS_STATUS_REPORTING__C;;
  }
  dimension: EXTERNALID__C{
    view_label: "ID"
    label: "External ID"
    description: "AWAL SFO ID"
    type:  string
    sql: ${TABLE}.EXTERNALID__C;;
  }
  dimension: RELATED_OPPORTUNITY_IDS__C{
    view_label: "ID"
    label: "Related Opportunity IDs"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.RELATED_OPPORTUNITY_IDS__C;;
  }
  dimension: DEAL_LAWYER__C{
    view_label: "Opportunity"
    label: "Deal Lawyer"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.DEAL_LAWYER__C;;
  }
  dimension: PHYSICAL_Y_N__C{
    view_label: "Opportunity"
    label: "Physical (Y/N)"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.PHYSICAL_Y_N__C;;
  }
  dimension: OPTION_Y_N__C{
    view_label: "Opportunity"
    label: "Options (Y/N)"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.OPTION_Y_N__C;;
  }
  dimension: INCLUDES_OPTION_S__C{
    view_label: "Opportunity"
    label: "Includes options (Y/N)"
    #description: "Expected Advance Range"
    type:  string
    sql: ${TABLE}.INCLUDES_OPTION_S__C;;
  }
  dimension: KOBALT_HEADLINE_POST_RECOUPMENT_RATE_3__C{
    view_label: "Rates"
    label: "Post Recoupment Rate 3"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.KOBALT_HEADLINE_POST_RECOUPMENT_RATE_3__C;;
  }
  dimension: KOBALT_HEADLINE_POST_RECOUPMENT_RATE_T__C{
    view_label: "Rates"
    label: "Post Recoupment Rate T"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.KOBALT_HEADLINE_POST_RECOUPMENT_RATE_T__C;;
  }
  dimension: KOBALT_HEADLINE_POST_RECOUPMENT_RATE_H__C{
    view_label: "Rates"
    label: "Post Recoupment Rate H"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.KOBALT_HEADLINE_POST_RECOUPMENT_RATE_H__C;;
  }
  dimension: KOBALT_HEADLINE_PRE_RECOUPMENT_RATE_HO__C{
    view_label: "Rates"
    label: "Pre Recoupment Rate HO"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.KOBALT_HEADLINE_PRE_RECOUPMENT_RATE_HO__C;;
  }
  dimension: KOBALT_HEADLINE_PRE_RECOUPMENT_RATE_T2__C{
    view_label: "Rates"
    label: "PRe Recoupment Rate T2"
    #description: "Expected Advance Range"
    type:  number
    sql: ${TABLE}.KOBALT_HEADLINE_PRE_RECOUPMENT_RATE_T2__C;;
  }
  dimension: BA_AGENDA_TYPE__C{
    view_label: "Opportunity"
    label: "BA AGENDA TYPE"
    description: "BA Agenda Type Main or KMC"
    type:  string
    sql: ${TABLE}.BA_AGENDA_TYPE__C;;
  }
  dimension: DEAL_TYPE_MASTERS__C{
    view_label: "Opportunity"
    label: "Deal Type"
    description: "Deal Type Masters Artist, Label, Catalogue"
    type:  string
    sql: ${TABLE}.DEAL_TYPE_MASTERS__C;;
  }
  dimension: DEAL_TYPE_NR__C{
    view_label: "Opportunity"
    label: "Deal Type NR"
    description: "Deal Type Advance vs Admin"
    type:  string
    sql: ${TABLE}.DEAL_TYPE_NR__C;;
  }
  # dimension: Close_Date{
  #   view_label: "Date"
  #   label: "Close Date"
  #   description: "End Date"
  #   type:  string
  #   sql: ${TABLE}.CLOSEDATE ;;
  # }
  dimension_group: close_date {
    view_label: "Date"
    label: "Close Date"
    description: "Close Date"
    type: time
    sql: ${TABLE}.closedate ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: ACTUAL_CLOSE_DATE__C {
    view_label: "Date"
    label: "Actual Close Date"
    description: "Actual Close Date"
    type: time
    sql: ${TABLE}.ACTUAL_CLOSE_DATE__C ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: last_modified_date {
    view_label: "Date"
    label: "Last Modified Date"
    description: "Last Modified Date"
    type: time
    sql: ${TABLE}.LASTMODIFIEDDATE ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }


}