view: dt_genre_mappings {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_GENRE_MAPPINGS ;;
#  derived_table: {
#    sql: Select s.storename,
#og.genre,
#os.name,
#mg.dms_master_genre,
#msg.dms_master_subgenre
#from "ORCHARD_APP_REPORTING"."ART_RELATIONS"."GENRE" og
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."SUBGENRE" os on og.genre_id = os.genre_id
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."DMS_SUBGENRE_MAPPING" sgm on os.orchard_id = sgm.orchard_subgenre_id
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."DMS_MASTER_SUBGENRE" msg on msg.dms_master_subgenre_id = sgm.dms_master_subgenre_id
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."DMS_MASTER_GENRE" mg on mg.dms_master_genre_id = msg.dms_master_genre_id
#join "FACTS"."PROD"."DIM_STORE" s on mg.customer_master_master_id = s.storeid ;;
#   }

  dimension: store {
    label: "Store"
    type: string
    hidden: no
    sql: ${TABLE}.storename ;;
    view_label: "Genre-Mappings"
  }

  dimension: orchard_genre {
    label: "Orchard Genre"
    type: string
    hidden: no
    sql: ${TABLE}.genre ;;
    view_label: "Genre-Mappings"
  }

  dimension: orchard_sub_genre {
    label: "Orchard Sub-Genre"
    type: string
    hidden: no
    sql: ${TABLE}.name ;;
    view_label: "Genre-Mappings"
  }

  dimension: store_genre {
    label: "Store Genre"
    type: string
    hidden: no
    sql: ${TABLE}.dms_master_genre ;;
    view_label: "Genre-Mappings"
  }

  dimension: store_sub_genre {
    label: "Store Sub-Genre"
    type: string
    hidden: no
    sql: ${TABLE}.dms_master_subgenre ;;
    view_label: "Genre-Mappings"
  }

}