# View: KNR_Performer_Run_Exchange_Rates

**View Name:** KNR_Performer_Run_Exchange_Rates
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accounting, Prod_Royalty_Accounting_Royalty_Accounting.Exchange_Rate`
**File Path:** `views/KNR_Performer_Run_Exchange_Rates.view.lkml`

## Overview

- **File Size:** 1401 bytes
- **Lines of Code:** 61
- **Dimensions:** 10
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `EXCHANGE_RATE_ID` | string |
| `CREATED_BY` | string |
| `LAST_MODIFIED` | string |
| `FROM_CURRENCY_CODE` | string |
| `TO_CURRENCY_CODE` | string |
| `LAST_MODIFIED_BY` | string |
| `CREATED_AT` | string |
| `STATEMENT_PERIOD_ID` | number |
| `RATE` | number |
| `CONCAT_FROM_TO_CURRENCY` | string |

## Derived Table

```sql
sql:

        SELECT er.EXCHANGE_RATE_ID,
      er.CREATED_BY,
      er.LAST_MODIFIED,
     er.FROM_CURRENCY_CODE,
      er.TO_CURRENCY_CODE,
      er.LAST_MODIFIED_BY,
      er.CREATED_AT,
      er.STATEMENT_PERIOD_ID,
      er.RATE,
      concat(er.FROM_CURRENCY_CODE,er.TO_CURRENCY_CODE) CONCAT_FROM_TO_CURRENCY
      FROM ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.exchange_rate er
          ;;
```