data.ml
LookML Delivery marketplace

Product Listing

Product Listing model for delivery marketplace.

source-preserved

Blocks

product_listing.view.lkml · 78 lines
inferred 
view: product_listing {
  sql_table_name: ProductListing ;;

  dimension: product_listing_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.ProductListingId ;;
  }

  dimension: cost {
    sql: ${TABLE}.Cost ;;
  }

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

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

  dimension: price {
    sql: ${TABLE}.Price ;;
  }

  dimension: pricing_method_id {
    type: yesno
    sql: ${TABLE}.PricingMethodId ;;
  }

  dimension: product_id {
    type: int
    sql: ${TABLE}.ProductId ;;
  }

  dimension: product_listing_condition_id {
    type: int
    sql: ${TABLE}.ProductListingConditionId ;;
  }

  dimension: product_listing_status_id {
    type: int
    sql: ${TABLE}.ProductListingStatusId ;;
  }

  dimension: sell_type_id {
    type: int
    sql: ${TABLE}.SellTypeId ;;
  }

  dimension: seller_id {
    type: int
    sql: ${TABLE}.SellerId ;;
  }

  dimension: seller_listing_id {
    sql: ${TABLE}.SellerListingId ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [product_listing_id, product.ext_product_id, product.product_name, product.product_sub_name, order_item.count]
  }
}
product_listing.view.lookml · 61 lines
source-preserved 
- view: product_listing
  sql_table_name: ProductListing
  fields:
  - dimension: product_listing_id
    type: int
    primary_key: true
    sql: ${TABLE}.ProductListingId
  - dimension: cost
    sql: ${TABLE}.Cost
  - dimension: margin_percent
    type: number
    sql: ${TABLE}.MarginPercent
  - dimension: markup_percent
    type: number
    sql: ${TABLE}.MarkupPercent
  - dimension: price
    sql: ${TABLE}.Price
  - dimension: pricing_method_id
    type: yesno
    sql: ${TABLE}.PricingMethodId
  - dimension: product_id
    type: int
    sql: ${TABLE}.ProductId
  - dimension: product_listing_condition_id
    type: int
    sql: ${TABLE}.ProductListingConditionId
  - dimension: product_listing_status_id
    type: int
    sql: ${TABLE}.ProductListingStatusId
  - dimension: sell_type_id
    type: int
    sql: ${TABLE}.SellTypeId
  - dimension: seller_id
    type: int
    sql: ${TABLE}.SellerId
  - dimension: seller_listing_id
    sql: ${TABLE}.SellerListingId
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreatedDate
  - dimension_group: revised
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.RevisedDate
  - measure: count
    type: count
    drill_fields:
    - product_listing_id
    - product.ext_product_id
    - product.product_name
    - product.product_sub_name
    - order_item.count

Contents

  • product_listing.view.lkml
  • product_listing.view.lookml