data.ml
LKML Agriculture wine

Stock History

Stock History model for agriculture wine.

inferred

Blocks

stock_history.view.lkml · 114 lines
inferred 
view: stock_history {
  sql_table_name: stock_history_table ;;

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

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

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

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

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

  dimension: description {
    sql: ${TABLE}.desc_ ;;
  }

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

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

  dimension: item_code {
    sql: ${TABLE}.itemcode ;;
  }

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

  dimension: month {
    type: number
    sql: ${TABLE}.mth ;;
  }

  dimension: quantity {
    type: number
    sql: ${TABLE}.qty ;;
  }

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

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

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

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

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

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

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

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

  dimension: year {
    type: number
    sql: ${TABLE}.year_ ;;
  }

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

  measure: count {
    type: count
  }

  measure: credit_notes_count {
    type: count
    filters: [source: "SalCNt"]
  }
}
stock_history.view.lookml · 70 lines
source-preserved 
- view: stock_history
  sql_table_name: stock_history_table
  fields:
  - dimension: avecost
    type: number
    sql: ${TABLE}.avecost
  - dimension: batch
    type: number
    sql: ${TABLE}.batch
  - dimension: cost
    type: number
    sql: ${TABLE}.cost
  - dimension: creditor
    sql: ${TABLE}.creditor
  - dimension: currstoh
    type: number
    sql: ${TABLE}.currstoh
  - dimension: description
    sql: ${TABLE}.desc_
  - dimension: entry
    type: number
    sql: ${TABLE}.entry
  - dimension: haccpref
    sql: ${TABLE}.haccpref
  - dimension: item_code
    sql: ${TABLE}.itemcode
  - dimension: location
    sql: ${TABLE}.location
  - dimension: month
    type: number
    sql: ${TABLE}.mth
  - dimension: quantity
    type: number
    sql: ${TABLE}.qty
  - dimension: rec_id
    type: int
    sql: ${TABLE}.rec_id
  - dimension: recnbr
    type: number
    sql: ${TABLE}.recnbr
  - dimension: refno
    sql: ${TABLE}.refno
  - dimension: source
    sql: ${TABLE}.source
  - dimension: totcost
    type: number
    sql: ${TABLE}.totcost
  - dimension: type
    type: number
    sql: ${TABLE}.type
  - dimension: unit
    sql: ${TABLE}.unit
  - dimension: userid
    sql: ${TABLE}.userid
  - dimension: year
    type: number
    sql: ${TABLE}.year_
  - dimension_group: date
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.date_
  - measure: count
    type: count
  - measure: credit_notes_count
    type: count
    filters:
    - source: SalCNt

Contents

  • stock_history.view.lkml
  • stock_history.view.lookml