| include: "/views/vector/customers.view.lkml" |
| include: "/views/nal.view.lkml" |
| # include: "/views/revenue/account_sort.view.lkml" |
| # include: "/views/account_stats.view.lkml" |
| # include: "/views/apac_account_metadata.view.lkml" |
| explore: vector_customers { |
| view_label: "Account" |
| description: "Contains data on vector customers sourced from Vector, Anaplan and MDM" |
| join: nal { |
| view_label: "Account" |
| sql_on: ${vector_customers.nal_id} = ${nal.nal_id} ;; |
| type: left_outer |
| relationship: many_to_one |
| } |
| # join: account_sort { |
| # type: left_outer |
| # sql: ${vector_customers.reporting_id} = ${account_sort.reporting_id} ;; |
| # relationship: many_to_one |
| # } |
| # join: account_stats { |
| # view_label: "Account" |
| # sql_on: ${account_stats.reporting_id} = ${vector_customers.reporting_id} ;; |
| # relationship: many_to_one |
| # fields: [account_stats.rainbow_fields*] |
| # } |
| # join: apac_account_metadata { |
| # view_label: "Account" |
| # sql_on: ${apac_account_metadata.reporting_id} = ${vector_customers.reporting_id} ;; |
| # type: left_outer |
| # relationship: many_to_one |
| # } |
| } |