# View: comp_set_release_requirements

**View Name:** comp_set_release_requirements
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Distribution_Format, Art_Relations_Prod_Art_Relations.Releases, Prod.Dim_Country, Prod.Dim_Genre, Prod.Dim_Release + 3 more`
**File Path:** `comp_set_release_requirements.view.lkml`

## Overview

- **File Size:** 1873 bytes
- **Lines of Code:** 60
- **Dimensions:** 1
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 7

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |

## Filters

- `genre`
- `country`
- `release_date`
- `context_type`
- `months_of_accounting`
- `track_count`
- `gross_usd`

## Derived Table

```sql
sql:
      SELECT fs.releaseid
      FROM royalty_accounting.prod.workstation_fact_sales_unified_dbt fs
        INNER JOIN facts.prod.dim_track dt ON fs.trackid = dt.trackid
        INNER JOIN facts.prod.dim_release dr ON fs.releaseid = dr.releaseid AND dt.upc = dr.releaseid
        INNER JOIN facts.prod.dim_genre dg ON fs.genreid = dg.genreid
        INNER JOIN facts.prod.dim_country dc ON fs.countryid = dc.countryid
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON dr.product_id = r.release_id
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format f ON r.distribution_format_id = f.distribution_format_id
      WHERE {%condition genre%
```