# Abacus Looker Documentation

Generated on: 2026-07-03 09:37:09

## Project Overview

This repository contains 53 Looker models and 147 views for the Abacus system.

## Quick Navigation

- [Models Documentation](models/model-inventory.md) - Complete list of all Looker models
- [Views Documentation](views/view-inventory.md) - Complete list of all Looker views  
- [Explores Catalog](explores/explore-catalog.md) - All available explores
- [Data Lineage](data-lineage/dependency-map.md) - View and model dependencies
- [Usage Reports](reports/usage-analysis.md) - Analysis and statistics

## Models Summary

| Model | Label | Connection | Explores | Views Used |
|-------|-------|------------|----------|------------|
| [AWAL_NR_Royalties](models/AWAL_NR_Royalties.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Abacus_Contract_Terms](models/Abacus_Contract_Terms.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Abacus_Contracts_Linked_To_Contributors](models/Abacus_Contracts_Linked_To_Contributors.model.md) | KNR Models | knr-looker | 1 | 1 |
| [All_Rights_Blocks](models/All_Rights_Blocks.model.md) | KNR Models | knr-looker | 1 | 1 |
| [All_Schedules](models/All_Schedules.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Content_Master_Exporter](models/Content_Master_Exporter.model.md) | KNR Models | knr-looker | 13 | 13 |
| [Current_Balance](models/Current_Balance.model.md) | KNR Models | knr-looker | 3 | 3 |
| [Delivery_App](models/Delivery_App.model.md) | KNR Models | knr-looker | 5 | 5 |
| [Discography_Export](models/Discography_Export.model.md) | KNR Models | knr-looker | 3 | 3 |
| [Finance_Reports](models/Finance_Reports.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Generated_Income_Summary](models/Generated_Income_Summary.model.md) | generated_income_summary | knr-looker | 2 | 2 |
| [Historic_Generated_Income_Report_Correct](models/Historic_Generated_Income_Report_Correct.model.md) | KNR Models | knr-looker | 3 | 3 |
| [Historic_Generated_Income_Summary](models/Historic_Generated_Income_Summary.model.md) | KNR Models | knr-looker | 7 | 7 |
| [KNR_Ownership_Run](models/KNR_Ownership_Run.model.md) | KNR Models | knr-looker | 7 | 7 |
| [KNR_Performer_Run](models/KNR_Performer_Run.model.md) | KNR Models | knr-looker | 10 | 10 |
| [KNR_VAT_Applied](models/KNR_VAT_Applied.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Label_Royalties](models/Label_Royalties.model.md) | KNR Models | knr-looker | 1 | 1 |
| [MXM_Reports](models/MXM_Reports.model.md) | KNR Models | knr-looker | 2 | 2 |
| [New_Income_Summary](models/New_Income_Summary.model.md) | KNR Models | knr-looker | 6 | 6 |
| [Ownership_OA](models/Ownership_OA.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Performer_Royalties](models/Performer_Royalties.model.md) | KNR Models | knr-looker | 2 | 2 |
| [Pre_Label_Prod_Applied_Adjustments](models/Pre_Label_Prod_Applied_Adjustments.model.md) | KNR Models | knr-looker | 1 | 1 |
| [Residency_and_Tax](models/Residency_and_Tax.model.md) | KNR Models | knr-looker | 2 | 2 |
| [Societies](models/Societies.model.md) | Societies | knr-looker | 3 | 3 |
| [Societies_registrations](models/Societies_registrations.model.md) | KNR Models | knr-looker | 2 | 2 |
| [VAT_Applied](models/VAT_Applied.model.md) | KNR Models | knr-looker | 1 | 1 |
| [_NEW_abacus_fact_sales_nr_salesforce](models/_NEW_abacus_fact_sales_nr_salesforce.model.md) | KNR Models | knr-looker | 1 | 4 |
| [_NEW_chartmetric+ownership_content](models/_NEW_chartmetric+ownership_content.model.md) | KNR Models | knr-looker | 1 | 16 |
| [_NEW_chartmetric+performer_content](models/_NEW_chartmetric+performer_content.model.md) | KNR Models | knr-looker | 1 | 11 |
| [_NEW_chartmetric_airplay](models/_NEW_chartmetric_airplay.model.md) | KNR Models | knr-looker | 1 | 3 |
| [_NEW_chartmetric_itunes](models/_NEW_chartmetric_itunes.model.md) | KNR Models | knr-looker | 1 | 3 |
| [_NEW_chartmetric_new_releases](models/_NEW_chartmetric_new_releases.model.md) | KNR Models | knr-looker | 1 | 13 |
| [_NEW_chartmetric_spotify](models/_NEW_chartmetric_spotify.model.md) | KNR Models | knr-looker | 1 | 4 |
| [_NEW_content_combined](models/_NEW_content_combined.model.md) | KNR Models | knr-looker | 6 | 6 |
| [_NEW_ownership_content](models/_NEW_ownership_content.model.md) | KNR Models | knr-looker | 1 | 13 |
| [_NEW_ownership_delivery](models/_NEW_ownership_delivery.model.md) | None | knr-looker | 1 | 3 |
| [_NEW_performer_content](models/_NEW_performer_content.model.md) | KNR Models | knr-looker | 1 | 9 |
| [_NEW_performer_content_salesforce](models/_NEW_performer_content_salesforce.model.md) | KNR Models | knr-looker | 1 | 10 |
| [_NEW_performer_delivery](models/_NEW_performer_delivery.model.md) | KNR Models | knr-looker | 1 | 14 |
| [_NEW_performer_delivery_queue](models/_NEW_performer_delivery_queue.model.md) | KNR Models | knr-looker | 1 | 1 |
| [_NEW_salesforce_performer](models/_NEW_salesforce_performer.model.md) | KNR Models | knr-looker | 1 | 2 |
| [_NEW_salesforce_society](models/_NEW_salesforce_society.model.md) | KNR Models | knr-looker | 1 | 3 |
| [_NEW_sax_model](models/_NEW_sax_model.model.md) | KNR Models | knr-looker | 17 | 17 |
| [_NEW_unified_income_summary_performer](models/_NEW_unified_income_summary_performer.model.md) | KNR Models | knr-looker | 1 | 1 |
| [chartmetric](models/chartmetric.model.md) | KNR Models | knr-looker | 3 | 3 |
| [chartmetric_marketshare](models/chartmetric_marketshare.model.md) | KNR Models | knr-looker | 1 | 3 |
| [client_overview_full](models/client_overview_full.model.md) | KNR Models | knr-looker | 2 | 2 |
| [labels_database](models/labels_database.model.md) | KNR Models | knr-looker | 1 | 1 |
| [nr_dupes](models/nr_dupes.model.md) | KNR Models | knr-looker | 1 | 1 |
| [nr_queries](models/nr_queries.model.md) | KNR Models | knr-looker | 2 | 2 |
| [performer_salesforce](models/performer_salesforce.model.md) | KNR Models | knr-looker | 3 | 3 |
| [statement_email_recipients](models/statement_email_recipients.model.md) | KNR Models | knr-looker | 1 | 1 |
| [test_rlr](models/test_rlr.model.md) | Test | knr-looker | 1 | 1 |


## Views Summary

Total views: 147

| View | Table Source | Dimensions | Measures |
|------|-------------|------------|----------|
| [ChartMetric_Label_Content_Match](views/ChartMetric_Label_Content_Match.md) | Derived from: Art_Relations_Prod_Art_Relations.Cou... | 1 | 1 |
| [KNR_Ownership_Run_CheckSums](views/KNR_Ownership_Run_CheckSums.md) | Derived from: Prod.Stmt_Db_Sales_Distro_Staging, R... | 2 | 2 |
| [KNR_Performer_Run_Delivered_Contributors](views/KNR_Performer_Run_Delivered_Contributors.md) | Derived from: Art_Relations_Prod_Art_Relations.Cou... | 4 | 2 |
| [KNR_Performer_Run_Reported_Contributor_Names](views/KNR_Performer_Run_Reported_Contributor_Names.md) | Derived from: Prod.Accounting_Run_Results_Nr_Stagi... | 4 | 0 |
| [New_Income_Summary_Label_Test](views/New_Income_Summary_Label_Test.md) | Derived from: Art_Relations_Prod_Art_Relations.Tra... | 40 | 3 |
| [New_Income_Summary_Labels](views/New_Income_Summary_Labels.md) | Derived from: Art_Relations_Prod_Art_Relations.Tra... | 45 | 0 |
| [abacus_contracts_linked_to_contributors](views/abacus_contracts_linked_to_contributors.md) | Derived from: Prod.Nr_Contribution_Type, Prod.Perf... | 22 | 0 |
| [chartmetric_airplay](views/chartmetric_airplay.md) | Derived from: Chartmetric.Raw_Data, Raw_Data.Acr_C... | 31 | 4 |
| [chartmetric_itunes](views/chartmetric_itunes.md) | Derived from: Chartmetric.Raw_Data, Raw_Data.Itune... | 29 | 3 |
| [content_nr_ownership_carveout](views/content_nr_ownership_carveout.md) | FACTS.PROD.NR_SOUND_RECORDING_HAS_CARVEOUT_RULE_OW... | 10 | 1 |
| [content_nr_ownership_product_has_primary_artist_nr_participant](views/content_nr_ownership_product_has_primary_artist_nr_participant.md) | FACTS.PROD.NR_OWNERSHIP_PRODUCT_HAS_PRIMARY_ARTIST... | 6 | 1 |
| [content_nr_ownership_sound_recording](views/content_nr_ownership_sound_recording.md) | FACTS.PROD.OWNERSHIP_NR_SOUND_RECORDING | 19 | 1 |
| [generated_income_summary_sum_function](views/generated_income_summary_sum_function.md) | Derived Table (Custom SQL) | 1 | 0 |
| [int_dbt_prod_knr_statement_emails](views/int_dbt_prod_knr_statement_emails.md) | knr_account_payment_email_list | 6 | 0 |
| [mxm_query](views/mxm_query.md) | Derived Table (Custom SQL) | 16 | 0 |
| [nr_sound_recording_has_primary_artist_nr_participant](views/nr_sound_recording_has_primary_artist_nr_participant.md) | FACTS.PROD.NR_SOUND_RECORDING_HAS_PRIMARY_ARTIST_N... | 8 | 1 |
| [ownership_delivery_order_contents](views/ownership_delivery_order_contents.md) | ORCHARD_APP_REPORTING_V2.PROD_NR_OWNERSHIP_DELIVER... | 4 | 1 |
| [ownership_oa_delivery_history](views/ownership_oa_delivery_history.md) | INTELLIGENCE.KNR.OWNERSHIP_DELIVERY_HISTORY_AGGREG... | 11 | 1 |
| [performance_delivery_queue](views/performance_delivery_queue.md) | ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIV... | 5 | 1 |
| [vat_applied](views/vat_applied.md) | Derived from: Prod_Royalty_Accounting_Royalty_Acco... | 19 | 0 |

*Showing first 20 views. See [complete views inventory](views/view-inventory.md) for all 147 views.*