# View: performer_quarterly_report

**View Name:** performer_quarterly_report
**Table Source:** `Derived from: Prod.Nr_Contributor, Prod.Stmt_Db_Sales_Nr, Prod.Vw_Abacus_Fact_Sales_Nr_V3, Prod_Royalty_Accounting_Royalty_Accounting.Account, Prod_Royalty_Accounting_Royalty_Accounting.Contract + 3 more`
**File Path:** `views/performer_quarterly_report.view.lkml`

## Overview

- **File Size:** 5243 bytes
- **Lines of Code:** 157
- **Dimensions:** 15
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- --- Primary Key ---
- --- Dimensions ---
- --- Measures ---

## Dimensions

| Name | Type |
|------|------|
| `txn_id` | string |
| `contributor_id` | string |
| `contributor_name` | string |
| `account_id` | string |
| `year` | string |
| `quarter` | string |
| `qperiod` | string |
| `statement_desc` | string |
| `territory` | string |
| `source` | string |
| `recordings_isrc` | string |
| `artist` | string |
| `recordings_title` | string |
| `version_title` | string |
| `currency` | string |

## Measures

| Name | Type |
|------|------|
| `total_distributed_amount` | sum |
| `count` | count |

## SQL Comments

- Primary Key field (Hidden in dimensions)
- Dimensions
- Quarter Logic
- QPeriod Logic
- Measures (Raw data to be summed by Looker)

## Derived Table

```sql
sql:
      SELECT
        -- Primary Key field (Hidden in dimensions)
        corx.txn_id as txn_id,

      -- Dimensions
      txn.contributor_id as contributor_id,
      nrbutor.name as contributor_name,
      corx.account_id as account_id,
      aspo.statement_year as year,

      -- Quarter Logic
      replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(aspo.statement_month, '1','Q1'),'2','Q1'),'3','Q1'),'4','Q2'),'5','Q2'),'6','Q2'),'7','Q3'),'8','Q3'),'9','Q3'),'10','Q4'),'11','Q4'),'12','Q4'),'QQ4','Q4'),'Q1Q1','Q4') as quarter,

      -- QPeriod Logic
      asp.statement_year||replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(aspo.statement_month, '1','Q1'),'2','Q1'),'3','Q1'),'4','Q2'),'5','Q2'),'6','Q2'),'7','Q3'),'8','Q3'),'9','Q3'),'10','Q4'),'11','Q4'),'12','Q4'),'QQ4','Q4'),'Q1Q1','Q4') as qperiod,

      aspo.statement_period_name as statement_desc,
      replace(cn.name,'USA','United States') as territory,
      cmm.customer_name as source,
      corx.sound_recording_id as recordings_isrc,
      sr.main_artist as artist,
      sr.recording_title as recordings_title,
      sr.version as version_title,

      -- Measures (Raw data to be summed by Looker)
      corx.gross_revenue_after_withholding_tax_payee_currency as amount,
      corx.ACCOUNT_PAYEE_CURRENCY as currency

      FROM royalty_accounting.prod.vw_abacus_fact_sales_nr_v3 as corx
      JOIN royalty_accounting.prod.stmt_db_sales_nr as txn ON corx.txn_id = txn.stmt_db_sales_nr_txn_id
      JOIN FACTS.prod.nr_contributor as nrbutor ON txn.contributor_id = nrbutor.id
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract as c ON corx.contract_id = c.contract_id
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_term_condition as ctc ON corx.contract_term_condition_id = ctc.contract_term_condition_id
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_term as ct ON ctc.contract_term_id = ct.contract_term_id
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.run_controller_contract rcc
      ON rcc.contract_id=c.contract_id
      AND rcc.run_controller_id=6
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.account as a ON corx.account_id = a.account_id
      JOIN facts.prod.dim_transactiontype as t ON corx.transaction_type = t.transactiontypeabbr
      LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master cmm ON cmm.customer_master_master_id=corx.store_id
      LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.country cn ON cn.id=corx.country_id
      LEFT JOIN facts.prod.performance_nr_sound_recording sr ON sr.id=txn.sound_recording_id
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.statement_period as asp ON corx.statement_period_id = asp.statement_period_id
      JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.statement_period as aspo ON corx.ORIGINAL_STATEMENT_PERIOD_ID = aspo.statement_period_id
      WHERE true
      ;;
```