# View: dt_product_territory_split

**View Name:** dt_product_territory_split
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_PRODUCT_TERRITORY_SPLIT`
**File Path:** `dt_product_territory_split.view.lkml`

## Overview

- **File Size:** 1204 bytes
- **Lines of Code:** 48
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- select ts.product_territory_split_id, ts.vendor_id, ts.product_id, ts.country_id, c.name as country, ROUND(1-ts.split_rate,2) as product_split_rate
- from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_TERRITORY_SPLIT ts

## Dimensions

| Name | Type |
|------|------|
| `product_territory_split_id` | number |
| `vendor_id` | number |
| `product_id` | number |
| `country_id` | number |
| `country` | string |
| `product_split_rate` | number |

## Derived Table

```sql
#   sql:
  #   select ts.product_territory_split_id, ts.vendor_id, ts.product_id, ts.country_id, c.name as country, ROUND(1-ts.split_rate,2) as product_split_rate
  #   from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_TERRITORY_SPLIT ts
  #   left join orchard_app_reporting_v2.art_relations_prod_art_relations.country c on c.id = ts.country_id;;
  #
```