data.ml
LKML Analytics marketing

Optimization Output Production

Optimization Output Production model for analytics marketing.

inferred

Blocks

optimization_output_production.view.lkml · 42 lines
inferred 
view: optimization_output_production {
  sql_table_name: public.optimization_output_production ;;

  dimension: optimization_run_id {
    type: int
    sql: ${TABLE}.optimization_run_id ;;
  }

  dimension: period_id {
    type: int
    sql: ${TABLE}.period_id ;;
  }

  dimension: product_id {
    type: int
    sql: ${TABLE}.product_id ;;
  }

  dimension: production_amount {
    type: number
    sql: ${TABLE}.production_amount ;;
  }

  dimension: production_cost {
    type: number
    sql: ${TABLE}.production_cost ;;
  }

  dimension: site_id {
    type: int
    sql: ${TABLE}.site_id ;;
  }

  dimension: site_type {
    sql: ${TABLE}.site_type ;;
  }

  measure: count {
    type: count
    drill_fields: [optimization_run.optimization_run_id, optimization_run.scenario_name]
  }
}
optimization_output_production.view.lookml · 28 lines
source-preserved 
- view: optimization_output_production
  sql_table_name: public.optimization_output_production
  fields:
  - dimension: optimization_run_id
    type: int
    sql: ${TABLE}.optimization_run_id
  - dimension: period_id
    type: int
    sql: ${TABLE}.period_id
  - dimension: product_id
    type: int
    sql: ${TABLE}.product_id
  - dimension: production_amount
    type: number
    sql: ${TABLE}.production_amount
  - dimension: production_cost
    type: number
    sql: ${TABLE}.production_cost
  - dimension: site_id
    type: int
    sql: ${TABLE}.site_id
  - dimension: site_type
    sql: ${TABLE}.site_type
  - measure: count
    type: count
    drill_fields:
    - optimization_run.optimization_run_id
    - optimization_run.scenario_name

Contents

  • optimization_output_production.view.lkml
  • optimization_output_production.view.lookml