data.ml
LookML Ecommerce mobile used

Store

Store model for ecommerce mobile used.

source-preserved

Blocks

store.view.lkml · 69 lines
inferred 
view: store {
  sql_table_name: STORES ;;

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

  dimension: address {
    sql: ${TABLE}.ADDRESS ;;
  }

  dimension: areacode {
    sql: ${TABLE}.AREACODE ;;
  }

  dimension: city {
    sql: ${TABLE}.CITY ;;
  }

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

  dimension: district_code {
    sql: ${TABLE}.DISTRICTCODE ;;
  }

  dimension: manager {
    sql: ${TABLE}.MANAGER ;;
  }

  dimension: phone_number {
    sql: ${TABLE}.PHONENUMBER ;;
  }

  dimension: postal {
    sql: ${TABLE}.POSTAL ;;
  }

  dimension: region_code {
    sql: ${TABLE}.REGIONCODE ;;
  }

  dimension: state {
    sql: ${TABLE}.STATE ;;
  }

  dimension: store_code {
    sql: ${TABLE}.STORECODE ;;
  }

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

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

  measure: count {
    type: count
  }
}
store.view.lookml · 47 lines
source-preserved 
- view: store
  sql_table_name: STORES
  fields:
  - dimension: pfxrecnum
    type: int
    primary_key: true
    sql: ${TABLE}.PFXRECNUM
  - dimension: address
    sql: ${TABLE}.ADDRESS
  - dimension: areacode
    sql: ${TABLE}.AREACODE
  - dimension: city
    sql: ${TABLE}.CITY
  - dimension: description
    sql: ${TABLE}.DESCRIPTION
  - dimension: district_code
    sql: ${TABLE}.DISTRICTCODE
  - dimension: manager
    sql: ${TABLE}.MANAGER
  - dimension: phone_number
    sql: ${TABLE}.PHONENUMBER
  - dimension: postal
    sql: ${TABLE}.POSTAL
  - dimension: region_code
    sql: ${TABLE}.REGIONCODE
  - dimension: state
    sql: ${TABLE}.STATE
  - dimension: store_code
    sql: ${TABLE}.STORECODE
  - dimension_group: close
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CLOSEDATE
  - dimension_group: open
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OPENDATE
  - measure: count
    type: count

Contents

  • store.view.lkml
  • store.view.lookml