# View: bi.release_with_metadata_view

**View Name:** bi_release_with_metadata_view
**Table Source:** `prod.bi.release_with_metadata_view`
**File Path:** `bi.release_with_metadata_view.view.lkml`

## Overview

- **File Size:** 34737 bytes
- **Lines of Code:** 1234
- **Dimensions:** 60
- **Measures:** 25
- **Dimension Groups:** 8
- **Filters:** 0

## Comments & Notes

- Auto-generated via Rick's RScript on Tue Apr 05  1:39 AM Eastern
- # ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   START Manually Added   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
- #                           Put Any Manual Changes Here

## Dimensions

| Name | Type |
|------|------|
| `release_artist_UPC_concat` | string |
| `artist_name_release_name` | string |
| `imprint_id` | string |
| `sale_start_date_before_2016` | yesno |
| `film_tv_vs_music_by_product` | string |
| `sale_release_date_with_words` | string |
| `sale_release_date` | string |
| `music_vs_video_by_product` | string |
| `label_client_manager` | string |
| `label_id` | number |
| `label_is_dthree` | yesno |
| `label_is_ioda` | yesno |
| `label_is_o_and_o` | yesno |
| `label_is_red` | yesno |
| `label_name` | string |
| `label_owner` | string |
| `label_owner_id` | number |
| `label_priority` | number |
| `label_subaccount_id` | string |
| `label_subaccount_name` | string |
| `label_sc_group` | string |
| `upc` | number |
| `release_catalog_id` | number |
| `release_front_mid_or_cat_today` | string |
| `release_genre` | string |
| `genre_childrens_rock_classical_country_jazz_other` | string |
| `release_genre_group` | string |
| `release_genre_group_less` | string |
| `release_genre_subgenre` | string |
| `release_id` | number |
| `release_imprint` | string |
| `release_is_compilation` | yesno |
| `release_is_deleted` | yesno |
| `release_is_digital_only` | yesno |
| `release_is_itunes_previewable` | yesno |
| `release_marketing_priority` | string |
| `months_since_release_to_today` | number |
| `days_from_releasedate_to_today` | number |
| `release_name` | string |
| `release_name_short` | string |
| `release_new_release_type` | string |
| `release_number_of_tracks` | number |
| `release_oa_link` | string |
| `release_parent_name` | string |
| `release_parent_oa_link` | string |
| `release_parent_upc` | number |
| `release_product_type` | string |
| `release_product_videosubtype` | string |
| `release_subgenre` | string |
| `track_listing_link` | string |
| `release_version` | string |
| `release_video_channel` | string |
| `release_video_is_vod` | yesno |
| `artist_id` | number |
| `artist_name` | string |
| `artist_country` | string |
| `artist_country_code` | string |
| `label_continent` | string |
| `label_country` | string |
| `label_country_code` | string |

## Measures

| Name | Type |
|------|------|
| `number_of_rows` | count |
| `minimum_date_added` | date |
| `count_distinct_label_owners` | count_distinct |
| `count_distinct_label_subaccounts` | count_distinct |
| `count_distinct_labels` | count_distinct |
| `count_distinct_releases` | count_distinct |
| `count_distinct_releases_by_catalogids` | count_distinct |
| `release_number_of_tracks_sum` | sum |
| `count_distinct_artists` | count_distinct |
| `max_release_date` | string |
| `max_release_date_added` | string |
| `max_artist_date_created` | string |
| `max_release_sale_physical_date` | string |
| `max_release_sale_preorder_date` | string |
| `max_release_sale_start_date` | string |
| `max_release_theatrical_release_date` | string |
| `max_release_vod_start_date` | string |
| `min_release_date` | string |
| `min_release_date_added` | string |
| `min_artist_date_created` | string |
| `min_release_sale_physical_date` | string |
| `min_release_sale_preorder_date` | string |
| `min_release_sale_start_date` | string |
| `min_release_theatrical_release_date` | string |
| `min_release_vod_start_date` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `artist_date_created` | time |
| `release_date` | time |
| `release_date_added` | time |
| `release_sale_physical_date` | time |
| `release_sale_preorder_date` | time |
| `release_sale_start_date` | time |
| `release_theatrical_release_date` | time |
| `release_vod_start_date` | time |