# View: dt_riaa_certification

**View Name:** dt_riaa_certification
**Table Source:** `Derived from: Prod.Dim_Isrc, Prod.Dim_Release`
**File Path:** `dt_riaa_certification.view.lkml`

## Overview

- **File Size:** 6289 bytes
- **Lines of Code:** 203
- **Dimensions:** 11
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 2

## Dimensions

| Name | Type |
|------|------|
| `data_source` | string |
| `upc` | string |
| `release_name` | string |
| `release_date` | date |
| `isrcid` | string |
| `isrc` | string |
| `track_name` | string |
| `activity_period` | string |
| `store` | string |
| `transaction_type` | string |
| `labelid` | number |

## Measures

| Name | Type |
|------|------|
| `units` | sum |
| `certification_units` | sum |

## Filters

- `content_filter`
- `label_id`

## Derived Table

```sql
sql:
WITH content_filter AS (
    SELECT
        di.labelid,
        di.isrcid,
        di.isrc,
        di.isrcname,
        dr.releaseid,
        dr.releasename,
        dr.releasedate
    FROM facts.prod.dim_isrc di
        INNER JOIN facts.prod.dim_release dr ON di.upc = dr.releaseid
    {% if certification_type._parameter_value == "'releaseid'" %
```