data.ml
LKML Analytics marketing

Optimization Output Period

Optimization Output Period model for analytics marketing.

inferred

Blocks

optimization_output_period.view.lkml · 45 lines
inferred 
view: optimization_output_period {
  sql_table_name: public.optimization_output_period ;;

  dimension: sid {
    type: int
    primary_key: yes
    sql: ${TABLE}.sid ;;
  }

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

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

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

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

  dimension_group: period_end {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.period_end ;;
  }

  dimension_group: period_start {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.period_start ;;
  }

  measure: count {
    type: count
    drill_fields: [period_name, optimization_run.optimization_run_id, optimization_run.scenario_name]
  }
}
optimization_output_period.view.lookml · 40 lines
source-preserved 
- view: optimization_output_period
  sql_table_name: public.optimization_output_period
  fields:
  - dimension: sid
    type: int
    primary_key: true
    sql: ${TABLE}.sid
  - dimension: optimization_run_id
    type: int
    sql: ${TABLE}.optimization_run_id
  - dimension: period_id
    type: int
    sql: ${TABLE}.period_id
  - dimension: period_index
    type: int
    sql: ${TABLE}.period_index
  - dimension: period_name
    sql: ${TABLE}.period_name
  - dimension_group: period_end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.period_end
  - dimension_group: period_start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.period_start
  - measure: count
    type: count
    drill_fields:
    - period_name
    - optimization_run.optimization_run_id
    - optimization_run.scenario_name

Contents

  • optimization_output_period.view.lkml
  • optimization_output_period.view.lookml