# View: dt_us_physical_view_with_release_grid

**View Name:** dt_us_physical_retail_view_with_release_grid
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_US_PHYSICAL_RETAIL_VIEW_WITH_RELEASE_GRID`
**File Path:** `dt_us_physical_view_with_release_grid.view.lkml`

## Overview

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

## Comments & Notes

- derived_table: {
- sql: select
- row_number() OVER (ORDER BY release_id DESC) AS row_id,

## 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
# ;;
#
```