data.ml
LKML Ecommerce mobile used

Sku

Sku model for ecommerce mobile used.

inferred

Blocks

sku.view.lkml · 83 lines
inferred 
view: sku {
  sql_table_name: SKU ;;

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

  dimension: bin_016 {
    sql: ${TABLE}.BIN_016 ;;
  }

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

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

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

  dimension: carrier {
    sql: ${TABLE}.CARRIER ;;
  }

  dimension: code {
    sql: ${TABLE}.CODE ;;
  }

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

  dimension: item_type {
    sql: ${TABLE}.ITEMTYPE ;;
  }

  dimension: make {
    sql: ${TABLE}.MAKE ;;
  }

  dimension: model {
    sql: ${TABLE}.MODEL ;;
  }

  dimension: model_004 {
    sql: ${TABLE}.MODEL_004 ;;
  }

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

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

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

  dimension: spiff {
    sql: ${TABLE}.SPIFF ;;
  }

  dimension: tier {
    sql: ${TABLE}.TIER ;;
  }

  measure: count {
    type: count
  }
}
sku.view.lookml · 47 lines
source-preserved 
- view: sku
  sql_table_name: SKU
  fields:
  - dimension: pfxrecnum
    type: int
    primary_key: true
    sql: ${TABLE}.PFXRECNUM
  - dimension: bin_016
    sql: ${TABLE}.BIN_016
  - dimension: buy_broken
    type: number
    sql: ${TABLE}.BUYBROKEN
  - dimension: buy_high
    type: number
    sql: ${TABLE}.BUYHIGH
  - dimension: buy_low
    type: number
    sql: ${TABLE}.BUYLOW
  - dimension: carrier
    sql: ${TABLE}.CARRIER
  - dimension: code
    sql: ${TABLE}.CODE
  - dimension: description
    sql: ${TABLE}.DESCRIPTION
  - dimension: item_type
    sql: ${TABLE}.ITEMTYPE
  - dimension: make
    sql: ${TABLE}.MAKE
  - dimension: model
    sql: ${TABLE}.MODEL
  - dimension: model_004
    sql: ${TABLE}.MODEL_004
  - dimension: retail
    type: number
    sql: ${TABLE}.RETAIL
  - dimension: sell_high
    type: number
    sql: ${TABLE}.SELLHIGH
  - dimension: sell_low
    type: number
    sql: ${TABLE}.SELLLOW
  - dimension: spiff
    sql: ${TABLE}.SPIFF
  - dimension: tier
    sql: ${TABLE}.TIER
  - measure: count
    type: count

Contents

  • sku.view.lkml
  • sku.view.lookml