view: int_dbt_prod_rm_db_accounting_revenue_over_time {
  sql_table_name: intelligence.dbt_prod_strategy.rm_db_accounting_revenue_over_time ;;

  dimension_group: activity_month {
    view_label: "Activity Date"
    label: "Activity Month"
    type: time
    sql: ${TABLE}.activity_month ;;
    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: label_id {
    type: number
    view_label: "Label"
    label: "Label Id"
    value_format: "0"
    sql: ${TABLE}.LABEL_ID ;;
  }

  dimension: label_name {
    type: string
    view_label: "Label"
    label: "Label Name"
    sql: ${TABLE}.LABEL_NAME ;;
  }

  dimension: store_name {
    type: string
    view_label: "Store"
    label: "Store Name"
    sql: ${TABLE}.STORE_NAME ;;
  }

  dimension: transaction_group {
    type: string
    view_label: "Transaction Type"
    label: "Transaction Group"
    sql: ${TABLE}.TRANSACTION_GROUP ;;
  }

  dimension: transaction_group_services_breakout {
    type: string
    view_label: "Transaction Type"
    label: "Transaction Type (Services Breakout)"
    sql: ${TABLE}.TRANSACTION_GROUP_SERVICES_BREAKOUT ;;
  }

  dimension: transaction_group_services_breakout_grouped {
    type: string
    view_label: "Transaction Type"
    label: "Transaction Type Grouped (Services Breakout)"
    sql:
      case
        when (${TABLE}.TRANSACTION_GROUP_SERVICES_BREAKOUT in ('Streaming', 'Digital') or ${TABLE}.TRANSACTION_GROUP = 'Downloads') then 'Digital'
        when ${TABLE}.TRANSACTION_GROUP = 'Streaming' and ${TABLE}.TRANSACTION_GROUP_SERVICES_BREAKOUT = 'Ad Sales' then 'Ad Sales'
        when ${TABLE}.TRANSACTION_GROUP = 'Publishing Royalties' then ${TABLE}.TRANSACTION_GROUP
        when ${TABLE}.TRANSACTION_GROUP = 'Other' and ${TABLE}.TRANSACTION_GROUP_SERVICES_BREAKOUT = 'Performance Rights' then 'Performance Rights'
        when ${TABLE}.TRANSACTION_GROUP = 'Physical' then 'Physical'
        when ${TABLE}.TRANSACTION_GROUP = 'Other' and ${TABLE}.TRANSACTION_GROUP_SERVICES_BREAKOUT = 'Sync' then 'Sync'
        when ${TABLE}.TRANSACTION_GROUP = 'D2C' then 'D2C'
        else 'Other'
      end;;
  }

  dimension: payout_currency_code {
    type: string
    view_label: "Payout Currency"
    label: "Payout Currency Code"
    sql: ${TABLE}.PAYOUT_CURRENCY_CODE ;;
  }

  measure: gross_revenue {
    type: sum
    view_label: "Accounting"
    label: "Gross Revenue"
    value_format: "#,##0.00"
    sql: ${TABLE}.GROSS_REVENUE ;;
  }

  dimension: relationship_manager_userid {
    type: string
    view_label: "Relationship Manager"
    label: "Relationship Manager Id"
    sql: ${TABLE}.relationship_manager_userid ;;
  }

}