#   - dimension: release_name_short
#     view_label: Release
#     label: Name Short
#     description: ''
#     case_sensitive: FALSE
#     suggestable: FALSE
#     sql: REGEXP_REPLACE(${TABLE}.release_name, '.*', '.', 18)
#     type: string

#   - dimension: usa_or_row
#     view_label: Territory
#     label: USA or ROW
#     description: 'Is the Country USA or ROW'
#     sql_case: 
#       'USA': ${TABLE}.countryid = 1
#       else: 'ex-USA'
#     type: string
# 
# 



# 
#   - dimension: is_active_for_itunes
#     view_label: Territory
#     label: is Active for iTunes
#     description: 'These values were manually computed on Oct 2015 and may be less than accruate'
#     sql_case:
#       'Yes': ${country_code} in ('GB', 'CA', 'AU', 'RU', 'US', 'DE', 'BR', 'FR', 'MX', 'JP', 'IT', 'CH', 'TR', 'ES', 'NL', 'BE', 'ZA', 'IE', 'IN', 'DK', 'AT', 'NZ', 'CL', 'NO', 'CO', 'SE', 'PT', 'TH', 'ID', 'CZ', 'TW', 'SG', 'AR', 'PL', 'HK', 'PH', 'PE', 'LU', 'FI', 'MY', 'SK', 'GR', 'SA', 'EC', 'CR', 'HU', 'UA', 'NG', 'AE', 'DO', 'PA', 'EE', 'GT', 'KZ', 'LV', 'PY', 'SV', 'MT', 'BG', 'VE', 'NI', 'HN', 'SI', 'KE', 'CY', 'EG', 'LT', 'AZ', 'VN', 'MZ', 'TT', 'IL', 'NA', 'LK', 'LB', 'BY', 'MO', 'QA', 'BN', 'BO', 'BW', 'JO', 'KY', 'MD', 'AM', 'MU', 'GH', 'BM', 'ZW', 'OM', 'BS', 'RO', 'MN', 'BH', 'UZ', 'PG', 'BB', 'UG', 'VG', 'KH', 'TM', 'BZ', 'FJ', 'KG', 'KN', 'BF', 'TJ', 'CV', 'AG', 'LA', 'GD', 'AI', 'SZ', 'NE', 'GM', 'DM', 'NP')
#       else: 'No'
#       
#   - dimension: is_active_for_spotify
#     view_label: Territory
#     label: is Active for Spotify
#     description: 'These values were manually computed on Oct 2015 and may be less than accruate'
#     sql_case:
#       'Yes': ${country_code} in ('GB', 'CA', 'AU', 'RU', 'US', 'DE', 'BR', 'FR', 'MX', 'IT', 'CH', 'TR', 'ES', 'NL', 'BE', 'ZA', 'IE', 'IN', 'DK', 'AT', 'NZ', 'CL', 'NO', 'CO', 'SE', 'PT', 'TH', 'ID', 'CZ', 'TW', 'SG', 'AR', 'PL', 'HK', 'PH', 'PE', 'LU', 'FI', 'MY', 'SK', 'GR', 'EC', 'CR', 'HU', 'AE', 'DO', 'PA', 'EE', 'GT', 'LV', 'PY', 'SV', 'MT', 'BG', 'NI', 'HN', 'SI', 'CY', 'EG', 'LT', 'IL', 'QA', 'BO', 'KY', 'BM', 'OM', 'RO', 'VG', 'IM', 'CN', 'ZM', 'HR', 'GP', 'PK', 'NC', 'MC', 'KR', 'UY', 'LI', 'GF', 'GY', 'IS', 'GI', 'PR', 'VI', 'AD', 'AW')
#       else: 'No'
#       
#   - dimension: is_active_for_amazon
#     view_label: Territory
#     label: is Active for Amazon
#     description: 'These values were manually computed on Oct 2015 and may be less than accruate'
#     sql_case:
#       'Yes': ${country_code} in ('US','DE','GB','JP','FR','AT','IT','CH','ES')
#       else: 'No'
#       
#       
#   - dimension: is_active_for_google_play
#     view_label: Territory
#     label: is Active for Google Play
#     description: 'These values were manually computed on Oct 2015 and may be less than accruate'
#     sql_case:
#       'Yes': ${country_code} in ('US','GB','AU','CA','BR','DE','ES','FR','MX','RU','CH','IT','CZ','NZ','NL','BE','IE','CO','AT','SE','NO','CL','PL','FI','DK','PE','PT','UA','EC','RO','CR','HU','SK','LU','GR','DO','VE','PA','GT','PY','BY','UY','LV','HR','SI','BG','SV','IS','BO','HN','LT','EE','NI','CY','MT','BA','MK','AR','LI')
#       else: 'No'
#       

#   - dimension: itunes_spotify_other
#     view_label: Store
#     label: isiTunes Spotify or Other
#     description: ''
#     sql_case:
#      'iTunes': ${TABLE}.storeid = 1
#      'Spotify': ${TABLE}.storeid = 286
#      else: 'All Others'
#     type: string
# 
# #   - dimension: top_music_stores2
# #     view_label: Store
# #     label: Top Music Stores (Does this work)
# #     description: ''
# #     sql_case:
# #     &&&&
# #         CASE 
# #           WHEN  ${TABLE}.storeid in (1, 286, 187, 496, 348, 453, 569) THEN ${TABLE}.store_name
# #           ELSE  'All Other Stores'
# #         END
# #     type: string
# 
#   - dimension: top_music_stores
#     view_label: Store
#     label: Top Music Stores
#     description: ''
#     sql: |
#         CASE 
#           WHEN  ${TABLE}.storeid in (1, 286, 187, 496, 348, 453, 569) THEN ${TABLE}.store_name
#           ELSE  'All Other Stores'
#         END
#     type: string
# 
#   - dimension: top_video_stores
#     view_label: Store
#     label: Top Video Stores
#     description: ''
#     sql: |
#         CASE 
#           WHEN  ${TABLE}.storeid in (1, 376, 450, 446, 646, 463, 487, 392, 489, 555, 554, 617) THEN ${TABLE}.store_name
#           ELSE  'All Other Stores'
#         END
#     type: string