# View: us_physical_retail_view_with_release_grid

**View Name:** us_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.Us_Physical_Retail_View, Sony_Internal + 1 more`
**File Path:** `us_physical_retail_view_with_release_grid.view.lkml`

## Overview

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

## Comments & Notes

- dimension: compound_primary_key {
- primary_key: yes
- hidden: yes

## Dimensions

| Name | Type |
|------|------|
| `row_id` | number |
| `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 |
| `inventory_category_cd` | 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
              row_number() OVER (ORDER BY release_id DESC) AS row_id,
              *
        from sony_internal.prod.us_physical_retail_view us
        inner join orchard_app_reporting_v2.art_relations_prod_art_relations.release_grid rg
        on us.gras_prod_no = rg.product_no
 ;;
```