data.ml
LookML Ecommerce eyewear

Hto Items

Hto Items model for ecommerce eyewear.

source-preserved

Blocks

hto_items.view.lkml · 57 lines
inferred 
view: hto_items {
  sql_table_name: HTO_ITEMS ;;

  dimension: customer_id {
    type: int
    sql: ${TABLE}.ENTITY_ID ;;
  }

  dimension: option_1 {
    sql: ${TABLE}.f1 ;;
  }

  dimension: option_2 {
    sql: ${TABLE}.f2 ;;
  }

  dimension: option_3 {
    sql: ${TABLE}.f3 ;;
  }

  dimension: option_4 {
    sql: ${TABLE}.f4 ;;
  }

  dimension: option_5 {
    sql: ${TABLE}.f5 ;;
  }

  dimension: all_options {
    sql: CONCAT(${option_1},' | ',${option_2},' | ',${option_3},' | ',${option_4},' | ',${option_5}) ;;
  }

  dimension: magento_id {
    type: int
    hidden: yes
    sql: ${TABLE}.EXTERNAL_ID ;;
  }

  dimension: status {
    sql: ${TABLE}.STATUS ;;
  }

  dimension: transaction_id {
    type: int
    sql: ${TABLE}.TRANSACTION_ID ;;
  }

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

  measure: count {
    type: count
  }
}
hto_items.view.lookml · 36 lines
source-preserved 
- view: hto_items
  sql_table_name: HTO_ITEMS
  fields:
  - dimension: customer_id
    type: int
    sql: ${TABLE}.ENTITY_ID
  - dimension: option_1
    sql: ${TABLE}.f1
  - dimension: option_2
    sql: ${TABLE}.f2
  - dimension: option_3
    sql: ${TABLE}.f3
  - dimension: option_4
    sql: ${TABLE}.f4
  - dimension: option_5
    sql: ${TABLE}.f5
  - dimension: all_options
    sql: CONCAT(${option_1},' | ',${option_2},' | ',${option_3},' | ',${option_4},' | ',${option_5})
  - dimension: magento_id
    type: int
    hidden: true
    sql: ${TABLE}.EXTERNAL_ID
  - dimension: status
    sql: ${TABLE}.STATUS
  - dimension: transaction_id
    type: int
    sql: ${TABLE}.TRANSACTION_ID
  - dimension_group: transaction
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.TRANDATE
  - measure: count
    type: count

Contents

  • hto_items.view.lkml
  • hto_items.view.lookml