view: facts_prod_publishing_publisher {
  sql_table_name: facts.prod.publishing_publisher ;;

  dimension: id {
    label: "Publisher ID"
    type: string
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  dimension: name {
    type: string
    sql: ${TABLE}.name ;;
    label: "Publisher Name"
  }

  dimension: pro {
    type: string
    sql: ${TABLE}.pro ;;
    label: "Publisher Affiliation"
  }

  dimension: ipi {
    label: "Publisher IPI"
    type: number
    sql: ${TABLE}.ipi ;;
    value_format: "0"
  }
}