finance.yml

# PRELIMINARIES #

- connection: meta
- scoping: true           # for backward compatibility
- include: "dwh.mrr.view.lookml"
- include: "dwh.mrr_planned.view.lookml"
- include: "dwh.account.view.lookml"
- include: "dwh.account_facts.view.lookml"
- include: "dwh.opportunity.view.lookml"
- include: "dwh.opportunity_actualized.view.lookml"
- include: "dwh.revenue_schedule.view.lookml"
- include: "dwh.ar_aging.view.lookml"
- include: "dwh.user.view.lookml"
- include: "dwh.user_secure.view.lookml"
- include: "dwh.user_ext.view.lookml"
- include: "dwh.user_facts.view.lookml"
- include: "dwh.aws_instance.view.lookml"
- include: "dwh.fe_opportunity_facts.view.lookml"
- include: "dwh.analyst.view.lookml"
- include: "dwh.trial.view.lookml"
- include: "*finance.dashboard.lookml"  # include all dashboards in this project

- explore: opportunity
  joins:
    - join: account
      sql_on: ${account.id} = ${opportunity.account_id}
      relationship: many_to_one
      
    - join: trial
      sql_on: ${trial.opportunity_id} = ${opportunity.id}
      relationship: one_to_many
      
    - join: fe_opportunity_facts
      view_label: 'Opportunity'
      sql_on: ${trial.opportunity_id} = ${fe_opportunity_facts.opportunity_id}
      relationship: many_to_one
      fields: [export_set*]
      
    - join: opportunity_owner
      from: user_secure
      sql_on: ${opportunity_owner.id} = ${opportunity.owner_id}
      fields: [reps*]
      relationship: many_to_one
      
    - join: user_ext
      view_label: 'Opportunity Owner'
      
    - join: territory_opportunities
      view_label: 'Opportunity Owner'
      sql_on: ${opportunity_owner.territory} = ${territory_opportunities.opportunity_owner_territory}
      relationship: many_to_one

    - join: territory_meetings
      view_label: 'Opportunity Owner'
      sql_on: ${opportunity_owner.territory} = ${territory_meetings.account_representative_territory}
      relationship: many_to_one
      
    - join: territory_trials
      view_label: 'Opportunity Owner'
      sql_on: ${opportunity_owner.territory} = ${territory_trials.account_representative_territory}
      relationship: many_to_one      
      
    - join: team_opportunities
      view_label: 'Opportunity Owner'
      sql_on: ${opportunity_owner.sales_team} = ${team_opportunities.opportunity_owner_sales_team}
      relationship: many_to_one

    - join: team_meetings
      view_label: 'Opportunity Owner'
      sql_on: ${opportunity_owner.sales_team} = ${team_meetings.opportunity_owner_sales_team}
      relationship: many_to_one
      
    - join: team_trials
      view_label: 'Opportunity Owner'
      sql_on: ${opportunity_owner.sales_team} = ${team_trials.opportunity_owner_sales_team}
      relationship: many_to_one