view: sony_internal_prod_sapca_profit_center {
  derived_table:{
    sql: select orchard_label_id, listagg(sap_profit_center_cd, ', ') as sap_profit_center_cd
          from sony_internal.prod.sapca_profit_center
          where sap_profit_center_cd like 'CA6%'
          group by 1;;
  }

  dimension: sap_profit_center_cd {
    type: string
    sql: ${TABLE}.SAP_PROFIT_CENTER_CD ;;
  }

  dimension: orchard_label_id {
    type: number
    sql: ${TABLE}.ORCHARD_LABEL_ID ;;
  }


  set: detail {
    fields: [
      sap_profit_center_cd,
      orchard_label_id
    ]
  }
}