# View: ca_physical_retail_view_with_release_grid

**View Name:** ca_physical_retail_view_with_release_grid
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Release_Grid, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Ca_Physical_Retail_View, Sony_Internal + 1 more`
**File Path:** `ca_physical_retail_view_with_release_grid.view.lkml`

## Overview

- **File Size:** 5829 bytes
- **Lines of Code:** 333
- **Dimensions:** 35
- **Measures:** 13
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- measure: count {
- type: count
- drill_fields: [detail*]

## Dimensions

| Name | Type |
|------|------|
| `compound_primary_key` | string |
| `retailer` | string |
| `retailer_code` | string |
| `artist` | string |
| `product_name` | string |
| `label_name` | string |
| `label_code` | string |
| `sub_label` | string |
| `product_code` | string |
| `upcean` | string |
| `release_date` | date |
| `product_type` | string |
| `format` | string |
| `units_per_set` | number |
| `display_configuration` | string |
| `product_status_code` | string |
| `product_status` | string |
| `cutout_date` | date |
| `returnability` | string |
| `exclusive` | string |
| `gras_prod_no` | string |
| `profit_code` | string |
| `article_no` | string |
| `fin_label_cd` | string |
| `fin_label_profit_center` | string |
| `profit_center` | string |
| `sap_company_cd` | string |
| `vendor_id` | number |
| `subacct_id` | number |
| `release_id` | number |
| `upc` | number |
| `grid` | string |
| `product_no` | string |
| `create_time` | string |
| `gras_status` | string |

## Measures

| Name | Type |
|------|------|
| `open_orders` | sum |
| `backorders` | sum |
| `first4_week_s` | sum |
| `5_day_s` | sum |
| `5_day_r` | sum |
| `last4_wk_s` | sum |
| `last4_wk_r` | sum |
| `mtds` | sum |
| `mtdr` | sum |
| `cytds` | sum |
| `cytdr` | sum |
| `cum_tds` | sum |
| `cum_tdr` | sum |

## Derived Table

```sql
sql: select *
      from sony_internal.prod.ca_physical_retail_view ca
       inner join orchard_app_reporting_v2.art_relations_prod_art_relations.release_grid rg
            on ca."GRAS_PROD_NO" = rg.product_no
 ;;
```