# Abacus Looker Documentation

Generated on: 2026-04-15 09:16:02

## Project Overview

This repository contains 17 Looker models and 67 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_Opportunities](models/Awal_Opportunities.model.md) | AWAL Opportunities | awal-looker | 1 | 4 |
| [Lauv_catalogue_report](models/Lauv_catalogue_report.model.md) | AWAL DOSC Lauv Catalogue Report | awal-looker | 1 | 1 |
| [applications_data](models/applications_data.model.md) | AWAL Community Support | awal-looker | 3 | 7 |
| [awal_historical_data_sets](models/awal_historical_data_sets.model.md) | AWAL Historical Model Sets | awal-looker | 35 | 1 |
| [awal_orchard_client_id](models/awal_orchard_client_id.model.md) | None | awal-looker | 1 | 1 |
| [awal_recordings_recoup_rev_fpadb](models/awal_recordings_recoup_rev_fpadb.model.md) | AWAL Historical Model Sets | awal-looker | 1 | 1 |
| [awal_salesforce](models/awal_salesforce.model.md) | AWAL Salesforce Opportunities | awal-looker | 1 | 1 |
| [awal_summary_streams_separation](models/awal_summary_streams_separation.model.md) | Analytics Models - Use Case Models | awal-looker | 2 | 12 |
| [awal_summary_streams_separation_mondayweek](models/awal_summary_streams_separation_mondayweek.model.md) | Analytics Models - Use Case Models | awal-looker | 2 | 12 |
| [awal_workstation_gcp_priorities](models/awal_workstation_gcp_priorities.model.md) | Release Priorities | awal-looker | 1 | 1 |
| [bi_riaa_certification](models/bi_riaa_certification.model.md) | AWAL DOSC BI | awal-looker | 1 | 1 |
| [bi_riaa_certification_summary](models/bi_riaa_certification_summary.model.md) | AWAL DOSC BI | awal-looker | 1 | 1 |
| [detailed_catalogue_report](models/detailed_catalogue_report.model.md) | AWAL DOSC Detailed Catalogue Report | awal-looker | 1 | 1 |
| [gda](models/gda.model.md) | AWAL BI | awal-looker | 1 | 1 |
| [statements](models/statements.model.md) | AWAL DOSC Client Admin | awal-looker | 1 | 1 |
| [streaming_data_details](models/streaming_data_details.model.md) | AWAL DOSC Financial Team | awal-looker | 1 | 1 |
| [upc_remap](models/upc_remap.model.md) | AWAL DOSC | awal-looker | 1 | 1 |


## Views Summary

Total views: 67

| View | Table Source | Dimensions | Measures |
|------|-------------|------------|----------|
| [awal_awal_finance_awal_royalties_dashboard](views/awal_awal_finance_awal_royalties_dashboard.md) | AWAL.AWAL_FINANCE.AWAL_ROYALTIES_DASHBOARD | 13 | 1 |
| [awal_awal_finance_rpd_nr_usage_extract](views/awal_awal_finance_rpd_nr_usage_extract.md) | AWAL.AWAL_FINANCE.RPD_NR_USAGE_EXTRACT | 21 | 7 |
| [awal_sax_salesforce_account](views/awal_sax_salesforce_account.md) | AWAL_SAX.SALESFORCE.ACCOUNT | 2 | 0 |
| [awal_workstation_gcp_priorities](views/awal_workstation_gcp_priorities.md) | Derived from: Art_Relations_Prod_Art_Relations.Art... | 16 | 0 |
| [facts_prod_gda_leads](views/facts_prod_gda_leads.md) | FACTS.PROD.GDA_LEADS | 1 | 0 |
| [int_awal_historical_datasets_temp_awal_itunes_downloads](views/int_awal_historical_datasets_temp_awal_itunes_downloads.md) | AWAL.AWAL_FINANCE.AWAL_ITUNES_DOWNLOADS | 15 | 1 |
| [int_awal_historical_datasets_temp_awal_streams_per_release_segments](views/int_awal_historical_datasets_temp_awal_streams_per_release_segments.md) | AWAL.AWAL_FINANCE.AWAL_STREAMS_PER_RELEASE_SEGMENT... | 14 | 2 |
| [int_awal_historical_datasets_temp_fpa_recoup_rev_awal](views/int_awal_historical_datasets_temp_fpa_recoup_rev_awal.md) | AWAL.AWAL_FINANCE.FPA_RECOUP_REV_AWAL | 4 | 13 |
| [int_awal_historical_datasets_temp_group_all_bu_recoupment](views/int_awal_historical_datasets_temp_group_all_bu_recoupment.md) | AWAL.AWAL_FINANCE.GROUP_ALL_BU_RECOUPMENT | 23 | 12 |
| [int_awal_historical_datasets_temp_rd_awal_usage_live](views/int_awal_historical_datasets_temp_rd_awal_usage_live.md) | AWAL.AWAL_FINANCE.RD_AWAL_USAGE_LIVE | 9 | 3 |
| [int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform](views/int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform.md) | AWAL.AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFOR... | 24 | 4 |
| [int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_dsp_revenue](views/int_awal_historical_datasets_temp_rpd_awal_usage_client_ex_platform_dsp_revenue.md) | AWAL.AWAL_FINANCE.RPD_AWAL_USAGE_CLIENT_EX_PLATFOR... | 12 | 2 |
| [int_awal_historical_datasets_temp_rpd_awal_usage_ip616280](views/int_awal_historical_datasets_temp_rpd_awal_usage_ip616280.md) | INTELLIGENCE.AWAL_HISTORICAL_DATASETS_TEMP.RPD_AWA... | 24 | 4 |
| [int_awal_historical_datasets_temp_total_stream_segment_yttest](views/int_awal_historical_datasets_temp_total_stream_segment_yttest.md) | AWAL.AWAL_FINANCE.AWAL_TOTAL_STREAMS_SEGMENTS_YTTE... | 10 | 1 |
| [int_dbt_prod_awal_agr_nr_model](views/int_dbt_prod_awal_agr_nr_model.md) | AWAL.AWAL_FINANCE.AWAL_GROUP_AGR_NR | 22 | 8 |
| [int_dbt_prod_awal_all_pos_model](views/int_dbt_prod_awal_all_pos_model.md) | AWAL.AWAL_FINANCE.AWAL_ALL_POS | 17 | 2 |
| [int_dbt_prod_awal_new_client_list_model](views/int_dbt_prod_awal_new_client_list_model.md) | AWAL.AWAL_FINANCE.AWAL_NEW_CLIENT_LIST | 8 | 0 |
| [int_dbt_prod_awal_paid_and_future_advances_model](views/int_dbt_prod_awal_paid_and_future_advances_model.md) | AWAL.AWAL_FINANCE.AWAL_PAID_AND_FUTURE_ADVANCES | 15 | 0 |
| [int_dbt_prod_awal_tier_groups](views/int_dbt_prod_awal_tier_groups.md) | INTELLIGENCE.DBT_PROD.AWAL_TIER_GROUPS | 16 | 0 |
| [test_view](views/test_view.md) | my_schema_name.tester | 0 | 0 |

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