view: analytics_effective_units_stage_for_joining {
  sql_table_name: prod.effective_units.analytics_effective_units_stage_for_joining ;;

  dimension_group: activity_month544 {
    type: time
    timeframes: [date, week, month, month_num, year]
    convert_tz: no
    sql: ${TABLE}.ACTIVITY_MONTH544 ;;
    hidden: yes
  }

  dimension: country_id {
    type: number
    sql: ${TABLE}.COUNTRYID ;;
    hidden: yes
  }

  dimension: store_id {
    type: number
    sql: ${TABLE}.STOREID ;;
    hidden: yes
  }

  dimension: transac_type_abbr {
    type: string
    sql: ${TABLE}.TRANSAC_TYPE_ABBR ;;
    hidden: yes
  }

  dimension: mult_factor {
    view_label: "Sales"
    label: "Mult Factor"
    description: ""
    sql: ${TABLE}.mult_factor ;;
    hidden: yes
    type: number
    value_format: "####"
  }
}