# Commented for deprecating fact_analytics # view: facts_prod_fact_analytics_for_master_calendar { # sql_table_name: facts.prod.fact_analytics ;; # dimension: dayid { # type: number # sql: ${TABLE}.dayid ;; # hidden: no # primary_key: yes # } # dimension: feedid { # view_label: "Data Source" # label: "Feed ID" # type: number # sql: ${TABLE}.feedid ;; # value_format: "0" # } # dimension: labelid { # view_label: "Data Source" # label: "Label ID" # type: number # sql: ${TABLE}.labelid ;; # value_format: "0" # } # dimension: licensorid { # view_label: "Data Source" # label: "Licensor ID" # type: number # sql: ${TABLE}.licensorid ;; # value_format: "0" # } # measure: units { # view_label: "Units" # type: number # sql: COALESCE(SUM(${TABLE}.units), 0) ;; # } # }