# View: peer_generator

**View Name:** peer_generator
**Table Source:** `Derived from: Bi.Label_Yearly_Revenue, Bi.Second_Genre_Per_Label, Bi.Top_Genre_Per_Label`
**File Path:** `peer_generator.view.lkml`

## Overview

- **File Size:** 11493 bytes
- **Lines of Code:** 346
- **Dimensions:** 10
- **Measures:** 44
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `orchard_split_2013` | string |
| `orchard_split_2014` | string |
| `orchard_split_2015` | string |
| `orchard_split_2016` | string |
| `labelid` | string |
| `release_genre` | string |
| `second_release_genre` | string |
| `gross_revenue_per_genre` | string |
| `genre_rank` | string |
| `second_genre_rank` | string |

## Measures

| Name | Type |
|------|------|
| `2014_gross_revenue_growth_percentage` | sum |
| `2015_gross_revenue_growth_percentage` | sum |
| `2016_gross_revenue_growth_percentage` | sum |
| `2014_gross_download_revenue_growth_percentage` | sum |
| `2015_gross_download_revenue_growth_percentage` | sum |
| `2016_gross_download_revenue_growth_percentage` | sum |
| `2014_gross_streaming_revenue_growth_percentage` | sum |
| `2015_gross_streaming_revenue_growth_percentage` | sum |
| `2016_gross_streaming_revenue_growth_percentage` | sum |
| `2014_other_gross_revenue_growth_percentage` | sum |
| `2015_other_gross_revenue_growth_percentage` | sum |
| `2016_other_gross_revenue_growth_percentage` | sum |
| `gross_revenue_2013` | sum |
| `gross_download_revenue_2013` | sum |
| `gross_streaming_revenue_2013` | sum |
| `gross_revenue_2014` | sum |
| `gross_download_revenue_2014` | sum |
| `gross_streaming_revenue_2014` | sum |
| `gross_revenue_2015` | sum |
| `gross_download_revenue_2015` | sum |
| `gross_streaming_revenue_2015` | sum |
| `gross_revenue_2016` | sum |
| `gross_download_revenue_2016` | sum |
| `gross_streaming_revenue_2016` | sum |
| `net_revenue_2013` | sum |
| `net_download_revenue_2013` | sum |
| `net_streaming_revenue_2013` | sum |
| `net_revenue_2014` | sum |
| `net_download_revenue_2014` | sum |
| `net_streaming_revenue_2014` | sum |
| `net_revenue_2015` | sum |
| `net_download_revenue_2015` | sum |
| `net_streaming_revenue_2015` | sum |
| `net_revenue_2016` | sum |
| `net_download_revenue_2016` | sum |
| `net_streaming_revenue_2016` | sum |
| `other_gross_revenue_2013` | sum |
| `other_gross_revenue_2014` | sum |
| `other_gross_revenue_2015` | sum |
| `other_gross_revenue_2016` | sum |
| `other_net_revenue_2013` | sum |
| `other_net_revenue_2014` | sum |
| `other_net_revenue_2015` | sum |
| `other_net_revenue_2016` | sum |

## Derived Table

```sql
sql: select
      label_yearly_revenue.labelid,
      label_yearly_revenue.GROSS_REVENUE_2013,
      label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2013,
      label_yearly_revenue.GROSS_STREAMING_REVENUE_2013+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2013 as GROSS_STREAMING_REVENUE_2013,
      label_yearly_revenue.GROSS_REVENUE_2014,
      label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2014,
      label_yearly_revenue.GROSS_STREAMING_REVENUE_2014+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2014 as GROSS_STREAMING_REVENUE_2014,
      label_yearly_revenue.GROSS_REVENUE_2015,
      label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2015,
      label_yearly_revenue.GROSS_STREAMING_REVENUE_2015+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2015 as GROSS_STREAMING_REVENUE_2015,
      label_yearly_revenue.GROSS_REVENUE_2016,
      label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2016,
      label_yearly_revenue.GROSS_STREAMING_REVENUE_2016+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2016 as GROSS_STREAMING_REVENUE_2016,
      label_yearly_revenue.NET_REVENUE_2013,
      label_yearly_revenue.NET_DOWNLOAD_REVENUE_2013,
      label_yearly_revenue.NET_STREAMING_REVENUE_2013+label_yearly_revenue.NET_YOUTUBE_REVENUE_2013 as NET_STREAMING_REVENUE_2013,
      label_yearly_revenue.NET_REVENUE_2014,
      label_yearly_revenue.NET_DOWNLOAD_REVENUE_2014,
      label_yearly_revenue.NET_STREAMING_REVENUE_2014+label_yearly_revenue.NET_YOUTUBE_REVENUE_2014 as NET_STREAMING_REVENUE_2014,
      label_yearly_revenue.NET_REVENUE_2015,
      label_yearly_revenue.NET_DOWNLOAD_REVENUE_2015,
      label_yearly_revenue.NET_STREAMING_REVENUE_2015+label_yearly_revenue.NET_YOUTUBE_REVENUE_2015 as NET_STREAMING_REVENUE_2015,
      label_yearly_revenue.NET_REVENUE_2016,
      label_yearly_revenue.NET_DOWNLOAD_REVENUE_2016,
      label_yearly_revenue.NET_STREAMING_REVENUE_2016+label_yearly_revenue.NET_YOUTUBE_REVENUE_2016 as NET_STREAMING_REVENUE_2016,
      label_yearly_revenue.OTHER_GROSS_REVENUE_2013,
      label_yearly_revenue.OTHER_GROSS_REVENUE_2014,
      label_yearly_revenue.OTHER_GROSS_REVENUE_2015,
      label_yearly_revenue.OTHER_GROSS_REVENUE_2016,
      label_yearly_revenue.OTHER_NET_REVENUE_2013,
      label_yearly_revenue.OTHER_NET_REVENUE_2014,
      label_yearly_revenue.OTHER_NET_REVENUE_2015,
      label_yearly_revenue.OTHER_NET_REVENUE_2016,
      label_yearly_revenue.ORCHARD_SPLIT_2013,
      label_yearly_revenue.ORCHARD_SPLIT_2014,
      label_yearly_revenue.ORCHARD_SPLIT_2015,
      label_yearly_revenue.ORCHARD_SPLIT_2016,
      (label_yearly_revenue.GROSS_REVENUE_2014/nullif(label_yearly_revenue.GROSS_REVENUE_2013,0))-1 as GROSS_REVENUE_growth_percentage_2014,
      (label_yearly_revenue.GROSS_REVENUE_2015/nullif(label_yearly_revenue.GROSS_REVENUE_2014,0))-1 as GROSS_REVENUE_growth_percentage_2015,
      (label_yearly_revenue.GROSS_REVENUE_2016/nullif(label_yearly_revenue.GROSS_REVENUE_2015,0))-1 as GROSS_REVENUE_growth_percentage_2016,
      (label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2014/nullif(label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2013,0))-1 as GROSS_DOWNLOAD_REVENUE_growth_percentage_2014,
      (label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2015/nullif(label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2014,0))-1 as GROSS_DOWNLOAD_REVENUE_growth_percentage_2015,
      (label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2016/nullif(label_yearly_revenue.GROSS_DOWNLOAD_REVENUE_2015,0))-1 as GROSS_DOWNLOAD_REVENUE_growth_percentage_2016,
      ((label_yearly_revenue.GROSS_STREAMING_REVENUE_2014+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2014)/nullif((label_yearly_revenue.GROSS_STREAMING_REVENUE_2013+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2013),0))-1 as GROSS_STREAMING_REVENUE_growth_percentage_2014,
      ((label_yearly_revenue.GROSS_STREAMING_REVENUE_2015+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2015)/nullif((label_yearly_revenue.GROSS_STREAMING_REVENUE_2014+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2014),0))-1 as GROSS_STREAMING_REVENUE_growth_percentage_2015,
      ((label_yearly_revenue.GROSS_STREAMING_REVENUE_2016+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2016)/nullif((label_yearly_revenue.GROSS_STREAMING_REVENUE_2015+label_yearly_revenue.GROSS_YOUTUBE_REVENUE_2015),0))-1 as GROSS_STREAMING_REVENUE_growth_percentage_2016,
      (label_yearly_revenue.OTHER_GROSS_REVENUE_2014/nullif(label_yearly_revenue.OTHER_GROSS_REVENUE_2013,0))-1 as OTHER_GROSS_REVENUE_growth_percentage_2014,
      (label_yearly_revenue.OTHER_GROSS_REVENUE_2015/nullif(label_yearly_revenue.OTHER_GROSS_REVENUE_2014,0))-1 as OTHER_GROSS_REVENUE_growth_percentage_2015,
      (label_yearly_revenue.OTHER_GROSS_REVENUE_2016/nullif(label_yearly_revenue.OTHER_GROSS_REVENUE_2015,0))-1 as OTHER_GROSS_REVENUE_growth_percentage_2016,
      top_genre_per_label.RELEASE_GENRE,
      top_genre_per_label.GROSS_REVENUE_PER_GENRE,
      second_genre_per_label.RELEASE_GENRE as SECOND_RELEASE_GENRE,
      second_genre_per_label.GENRE_RANK as second_genre_rank
      from prod.bi.label_yearly_revenue
      left join prod.bi.top_genre_per_label on label_yearly_revenue.labelid=top_genre_per_label.labelid
      left join prod.bi.second_genre_per_label on label_yearly_revenue.labelid=second_genre_per_label.labelid
       ;;
```