view: int_awal_historical_datasets_temp_rd_awal_usage_live {
  sql_table_name: AWAL.AWAL_FINANCE.RD_AWAL_USAGE_LIVE ;;

  dimension: COMMERCIAL_MODEL_TYPE_DESCRIPTION {
    type: string
    sql: ${TABLE}.COMMERCIAL_MODEL_TYPE_DESCRIPTION ;;
  }


  dimension: INTERESTED_PARTY_SOURCE_NAME {
    type: string
    sql: ${TABLE}.INTERESTED_PARTY_SOURCE_NAME ;;
  }

  dimension: BATCH_RECEIVER_IP_ID {
    type: string
    sql: ${TABLE}.BATCH_RECEIVER_IP_ID ;;
  }


  dimension: BATCH_RECEIVER_IP_NAME {
    type: string
    sql: ${TABLE}.BATCH_RECEIVER_IP_NAME ;;
  }


  dimension: TERRITORY_GROUP_4 {
    type: string
    sql: ${TABLE}.TERRITORY_GROUP_4 ;;
  }


  dimension: TERRITORY_GROUP_2 {
    type: string
    sql: ${TABLE}.TERRITORY_GROUP_2 ;;
  }


  dimension: RIGHT_TYPE_DESCRIPTION {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_DESCRIPTION ;;
  }


  dimension: RIGHT_TYPE_REPORTING {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_REPORTING ;;
  }


  dimension: RIGHT_TYPE_GROUPS {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_GROUPS ;;
  }


  dimension_group: MAX_PAYMENT_MONTH {
   view_label: "ROYALTY_PERIOD"
    label: "MAX_PAYMENT_MONTH"
    type: time
    sql: ${TABLE}.MAX_PAYMENT_MONTH;;
  timeframes: [
    date,
    month,
    month_num,
    month_name,
    quarter,
    quarter_of_year,
    year,
    fiscal_month_num,
    fiscal_quarter,
    fiscal_quarter_of_year,
    fiscal_year
    ]
  }


  dimension_group: ROYALTY_PERIOD_START_MONTH {
    view_label: "ROYALTY_PERIOD"
    label: "ROYALTY_DATE_START"
    type: time
    sql: ${TABLE}.ROYALTY_PERIOD_START_MONTH ;;
  timeframes: [
    date,
    month,
    month_num,
    month_name,
    quarter,
    quarter_of_year,
    year,
    fiscal_month_num,
    fiscal_quarter,
    fiscal_quarter_of_year,
    fiscal_year
  ]
  }

  dimension_group: ROYALTY_PERIOD_END_MONTH {
    view_label: "ROYALTY_PERIOD"
    label: "ROYALTY_DATE_END"
    type: time
    sql: ${TABLE}.ROYALTY_PERIOD_END_MONTH ;;
  timeframes: [
    date,
    month,
    month_num,
    month_name,
    quarter,
    quarter_of_year,
    year,
    fiscal_month_num,
    fiscal_quarter,
    fiscal_quarter_of_year,
    fiscal_year
  ]
  }


  measure: ROYALTY_QUANTITY {
    view_label: "Measures"
    label: "QUANTITY"
    type: sum
    sql: ${TABLE}.ROYALTY_QUANTITY ;;
    value_format: "#,##0"
  }


  measure: ROYALTY_FIN_USD_SOURCE_AMOUNT {
    view_label: "Measures"
    label: "REVENUE"
    type: sum
    sql: ${TABLE}.ROYALTY_FIN_USD_SOURCE_AMOUNT ;;
    value_format:"$#,##0.00"
  }


  measure: ROYALTY_FIN_USD_RECEIVED_AMOUNT {
    view_label: "Measures"
    label: "RCVD REVENUE"
    type: sum
    sql: ${TABLE}.ROYALTY_FIN_USD_RECEIVED_AMOUNT ;;
    value_format:"$#,##0.00"
  }
}