# View: dim_release

**View Name:** dim_release
**Table Source:** `facts.prod.DIM_RELEASE`
**File Path:** `dim_release.view.lkml`

## Overview

- **File Size:** 5907 bytes
- **Lines of Code:** 330
- **Dimensions:** 36
- **Measures:** 2
- **Dimension Groups:** 11
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `genre_id` | number |
| `vendor_catalog_number` | string |
| `imprint` | string |
| `sale_start_date` | string |
| `deletions` | string |
| `mkt_priority` | string |
| `manufacturer_upc` | string |
| `version` | string |
| `display_upc` | string |
| `vendor_release_identifier` | string |
| `product_type_id` | number |
| `imprintid` | number |
| `product_subtype_id` | number |
| `compilation` | string |
| `release_status` | string |
| `channel_id` | number |
| `itunes_previewable` | string |
| `new_release` | string |
| `sync_only` | string |
| `est` | string |
| `vod` | string |
| `digital_only` | string |
| `projectid` | number |
| `product_code` | string |
| `not_for_distribution` | string |
| `product_id` | number |
| `product_type` | string |
| `physical_product_type` | string |
| `physical_product_format` | string |
| `display_configuration` | string |
| `artist_id` | string |
| `catalog_id` | string |
| `label_id` | string |
| `upc` | string |
| `release_name` | string |
| `subaccount_id` | string |

## Measures

| Name | Type |
|------|------|
| `number_of_releases` | count_distinct |
| `plot_release_date` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `date_added` | time |
| `date_created` | time |
| `last_updated` | time |
| `original_digital_release` | time |
| `original_release_date` | time |
| `physical_release_date` | time |
| `preorder_date` | time |
| `release_date` | time |
| `sale_start_date` | time |
| `theatrical_release_date` | time |
| `vod_start_date` | time |