Frame Catalog

view: frame_catalog {
  sql_table_name: FRAME_CATALOG ;;

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

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

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

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

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

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

  dimension: collection {
    sql: ${TABLE}.Collection ;;
  }

  dimension: collection_type {
    sql: ${TABLE}.Collection_Type ;;
  }

  dimension: color {
    sql: ${TABLE}.Color ;;
  }

  dimension: color_code {
    type: int
    sql: ${TABLE}.COLOR_CODE ;;
  }

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

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

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

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

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

  dimension: frame_face_material {
    sql: ${TABLE}.Frame_Face_Material ;;
  }

  dimension: frame_style_id {
    type: int
    hidden: yes
    sql: ${TABLE}.FRAME_STYLE_ID ;;
  }

  dimension: frame_style_name {
    sql: ${TABLE}.FRAME_STYLE_NAME ;;
  }

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

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

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

  dimension: hto_sku {
    sql: ${TABLE}.ITEM_SKU ;;
  }

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

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

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

  dimension: item_id {
    type: int
    sql: ${TABLE}.ITEM_ID ;;
  }

  dimension: item_sku {
    sql: ${TABLE}.ITEM_SKU ;;
  }

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

  dimension: optical_sun {
    sql: ${TABLE}.OpticalSun ;;
  }

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

  dimension: product_sku {
    sql: ${TABLE}.Product_SKU ;;
  }

  dimension: salesprice {
    sql: ${TABLE}.SALESPRICE ;;
  }

  dimension: shape {
    sql: ${TABLE}.Shape ;;
  }

  dimension: sku_with_kitpack {
    sql: ${TABLE}.SKU_WITH_KITPACK ;;
  }

  dimension: style_code {
    type: int
    sql: ${TABLE}.STYLE_CODE ;;
  }

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

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

  dimension: temple_material {
    sql: ${TABLE}.Temple_Material ;;
  }

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

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

  dimension: type_name {
    sql: ${TABLE}.TYPE_NAME ;;
  }

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

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

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

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

  measure: count {
    type: count
  }
}

- view: frame_catalog
  sql_table_name: FRAME_CATALOG
  fields:
  - dimension: a_left_of_lens_to_right
    type: number
    sql: ${TABLE}.A_left_of_lens_to_right
  - dimension: b_top_of_frame_to_bottom
    type: number
    sql: ${TABLE}.B_top_of_frame_to_bottom
  - dimension: b_top_of_lens_to_bottom
    type: number
    sql: ${TABLE}.B_top_of_lens_to_bottom
  - dimension: base_curve
    type: int
    sql: ${TABLE}.base_curve
  - dimension: bridge_height
    type: number
    sql: ${TABLE}.Bridge_Height
  - dimension: bridge_opening
    type: number
    sql: ${TABLE}.Bridge_Opening
  - dimension: collection
    sql: ${TABLE}.Collection
  - dimension: collection_type
    sql: ${TABLE}.Collection_Type
  - dimension: color
    sql: ${TABLE}.Color
  - dimension: color_code
    type: int
    sql: ${TABLE}.COLOR_CODE
  - dimension: description
    sql: ${TABLE}.description
  - dimension: end_piece_height
    type: number
    sql: ${TABLE}.End_Piece_Height
  - dimension: end_piece_width
    type: number
    sql: ${TABLE}.End_Piece_Width
  - dimension: female
    type: number
    sql: ${TABLE}.Female
  - dimension: frame_bottom_thickness
    type: number
    sql: ${TABLE}.Frame_bottom_thickness
  - dimension: frame_face_material
    sql: ${TABLE}.Frame_Face_Material
  - dimension: frame_style_id
    type: int
    hidden: true
    sql: ${TABLE}.FRAME_STYLE_ID
  - dimension: frame_style_name
    sql: ${TABLE}.FRAME_STYLE_NAME
  - dimension: frame_top_height
    type: number
    sql: ${TABLE}.Frame_top_height
  - dimension: headwidth_facefit
    type: number
    sql: ${TABLE}.Headwidth_Facefit
  - dimension: headwidth_screw_to_screw
    type: number
    sql: ${TABLE}.Headwidth_Screw_to_Screw
  - dimension: hto_sku
    sql: ${TABLE}.ITEM_SKU
  - dimension: image_url
    sql: ${TABLE}.image_url
  - dimension: is_crossover
    type: int
    sql: ${TABLE}.is_crossover
  - dimension: is_keyhole
    sql: ${TABLE}.is_keyhole
  - dimension: item_id
    type: int
    sql: ${TABLE}.ITEM_ID
  - dimension: item_sku
    sql: ${TABLE}.ITEM_SKU
  - dimension: male
    type: number
    sql: ${TABLE}.Male
  - dimension: optical_sun
    sql: ${TABLE}.OpticalSun
  - dimension: pantoscopic_tilt
    type: number
    sql: ${TABLE}.Pantoscopic_Tilt
  - dimension: product_sku
    sql: ${TABLE}.Product_SKU
  - dimension: salesprice
    sql: ${TABLE}.SALESPRICE
  - dimension: shape
    sql: ${TABLE}.Shape
  - dimension: sku_with_kitpack
    sql: ${TABLE}.SKU_WITH_KITPACK
  - dimension: style_code
    type: int
    sql: ${TABLE}.STYLE_CODE
  - dimension: temple_height_middle
    type: number
    sql: ${TABLE}.Temple_Height_middle
  - dimension: temple_length
    type: number
    sql: ${TABLE}.Temple_Length
  - dimension: temple_material
    sql: ${TABLE}.Temple_Material
  - dimension: temple_tip_to_tip
    type: number
    sql: ${TABLE}.Temple_Tip_to_Tip
  - dimension: temple_to_temple_inside
    type: number
    sql: ${TABLE}.Temple_to_temple_inside
  - dimension: type_name
    sql: ${TABLE}.TYPE_NAME
  - dimension: width
    sql: ${TABLE}.width
  - dimension: wraparound_angle
    type: number
    sql: ${TABLE}.Wraparound_Angle
  - dimension_group: date_in
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.date_in
  - dimension_group: date_out
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.date_out
  - measure: count
    type: count