view: int_dbt_prod_lmcp_upcoming_new_releases { sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_UPCOMING_NEW_RELEASES";; dimension: Label_manager{ label:"Label Manager" type: string sql:${TABLE}.Label_manager;; } dimension: Quarterback_label_manager{ label:"Quarterback Label Manager" type: string sql:${TABLE}.Quarterback_label_manager;; } dimension_group: Release_date{ label:"Release" type: time sql:${TABLE}.Release_date;; timeframes: [year, quarter, month, week, date, day_of_year, day_of_week, week_of_year, month_name, month_num, fiscal_month_num, fiscal_quarter, fiscal_quarter_of_year, fiscal_year] } dimension_group: Preorder_date{ label:"Preorder" type: time sql:${TABLE}.Preorder_date;; timeframes: [year, quarter, month, week, date, day_of_year, day_of_week, week_of_year, month_name, month_num, fiscal_month_num, fiscal_quarter, fiscal_quarter_of_year, fiscal_year] } dimension: Label_name{ label:"Label Name" type: string sql:${TABLE}.Label_name;; } dimension: Label_id{ label:"Label ID" type: number sql:${TABLE}.Label_id;; } dimension: Imprint_name{ label:"Imprint Name" type: string sql:${TABLE}.Imprint_name;; } dimension: Subaccount_id{ label:"Subaccount ID" type: number sql:${TABLE}.Subaccount_id;; } dimension: Artist_info_name{ label:"Artist Name" type: string sql:${TABLE}.Artist_info_name;; } dimension: Release_name{ label:"Release Name" type: string sql:${TABLE}.Release_name;; } dimension: Display_upc{ label:"Display UPC" type: string sql:${TABLE}.Display_upc;; } dimension: Format{ label:"Format" type: string sql:${TABLE}.Format;; } dimension: Mkt_priority_is_priority{ label:"Release Is Priority (Y/N)" type: string sql:${TABLE}.Mkt_priority_is_priority;; } dimension: Genre{ label:"Genre" type: string sql:${TABLE}.Genre;; } dimension: Subgenre{ label:"Subgenre" type: string sql:${TABLE}.Subgenre;; } dimension: Distribution_format_media_configuration{ label:"Release Configuration" type: string sql:${TABLE}.Distribution_format_media_configuration;; } dimension: Promo_player_code{ label:"Promo Player Code" type: string sql:${TABLE}.Promo_player_code;; } dimension: Promo_player_oa_link{ label:"Promo Player OA Link" type: string sql:${TABLE}.Promo_player_oa_link;; } dimension: Owner_name{ label:"Owner Name" type: string sql:${TABLE}.Owner_name;; } dimension: Priority_country_list{ label:"Priority Country List" type: string sql:${TABLE}.Priority_country_list;; } measure: Priority_country_list_list{ label:"Priority Country List" type: list list_field: Priority_country_list } }