# View: int_dbt_prod_accounting_last_12_months_activity_date

**View Name:** int_dbt_prod_accounting_last_12_months_activity_date
**Table Source:** `INTELLIGENCE.DBT_PROD.ACCOUNTING_LAST_12_MONTHS_ACTIVITY_DATE`
**File Path:** `int_dbt_prod_accounting_last_12_months_activity_date.view.lkml`

## Overview

- **File Size:** 3597 bytes
- **Lines of Code:** 181
- **Dimensions:** 20
- **Measures:** 4
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `max_activity_year` | number |
| `max_activity_month` | number |
| `country_name` | string |
| `continent` | string |
| `transaction_group` | string |
| `premium_vs_free` | string |
| `product_type` | string |
| `artist_id` | number |
| `artist_name` | string |
| `label_id` | number |
| `label_name` | string |
| `label_country` | string |
| `is_local_revenue_label` | yesno |
| `context` | string |
| `genre` | string |
| `owner` | string |
| `store_name` | string |
| `store_id` | number |
| `transaction_type_id` | number |
| `transaction_type_description` | string |

## Measures

| Name | Type |
|------|------|
| `net_rev_usd` | sum |
| `gross_rev_usd` | sum |
| `orchard_profit` | sum |
| `units` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity` | time |