# View: unified_publishing_master_royalties

**View Name:** unified_publishing_master_royalties
**Table Source:** `Derived from: Dbt_Prod.Publishing_Metadata, Intelligence.Dbt_Prod`
**File Path:** `views/unified_publishing_master_royalties.view.lkml`

## Overview

- **File Size:** 6006 bytes
- **Lines of Code:** 189
- **Dimensions:** 11
- **Measures:** 4
- **Dimension Groups:** 2
- **Filters:** 1

## Comments & Notes

- previous composers field for filtering
- parameter: apply_composer_filtering {
- type: string

## Dimensions

| Name | Type |
|------|------|
| `royalty_type` | string |
| `accounting_period_id` | number |
| `label_id` | number |
| `transaction_country` | string |
| `store_name` | string |
| `transaction_group` | string |
| `pub_song_id` | number |
| `song_title` | string |
| `composers` | string |
| `summed_splits` | number |
| `revenue_multiplier` | number |

## Measures

| Name | Type |
|------|------|
| `gross_revenue_USD` | sum |
| `adjusted_gross_revenue_USD` | sum |
| `net_revenue_USD` | sum |
| `net_revenue_preferred_currency` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |
| `first_delivered_date` | time |

## Filters

- `composers`

## SQL Comments

- Needed for Red Flag Report

## Derived Table

```sql
sql:
      with EARLIEST_DELIVERED_AT_DATE as (  -- Needed for Red Flag Report
        select
          pub_song_id,
          MIN(delivery_date) as first_delivered_date
        from intelligence.dbt_prod.publishing_metadata
        group by pub_song_id
      )

      select
        royalty_type,
        accounting_period_id,
        activity_date,
        esd.first_delivered_date,
        label_id,
        country_name,
        store_name,
        transaction_group,
        pub_song_id,
        song_title,
        composers,
        summed_splits,
        revenue_multiplier,
        {% if scale_publishing_revenue._parameter_value == "'Yes'" %
```