LKML Retail gastronomy

Fact Agg Item Sales By Day

Fact Agg Item Sales By Day model for retail gastronomy.

inferred

Blocks

LKML LookML

fact_agg_item_sales_by_day.view.lkml · 69 lines

inferred

view: fact_agg_item_sales_by_day {
  sql_table_name: FactAggItemSalesByDay ;;

  dimension: date_key {
    type: int
    sql: ${TABLE}.DateKey ;;
  }

  dimension: sales_outlet_key {
    type: int
    sql: ${TABLE}.SalesOutletKey ;;
  }

  dimension: source_key {
    type: int
    sql: ${TABLE}.SourceKey ;;
  }

  dimension: category_group {
    sql: ${TABLE}.CategoryGroup ;;
  }

  dimension: category {
    sql: ${TABLE}.Category ;;
  }

  dimension: sub_category {
    sql: ${TABLE}.SubCategory ;;
  }

  dimension: item_description {
    sql: ${TABLE}.ItemDescription ;;
  }

  dimension: quantity {
    type: number
    sql: ${TABLE}.Quantity ;;
  }

  dimension: avg_price {
    sql: ${TABLE}.AvgPrice ;;
  }

  dimension: gross_sales {
    sql: ${TABLE}.GrossSales ;;
  }

  dimension: net_sales {
    sql: ${TABLE}.NetSales ;;
  }

  measure: total_gross_sales {
    type: sum
    drill_fields: [category_group, category, sub_category, total_gross_sales]
    sql: ${gross_sales} ;;
  }

  measure: total_net_sales {
    type: sum
    drill_fields: [drill_path*]
    sql: ${net_sales} ;;
  }

  measure: total_quantity {
    type: sum
    drill_fields: [drill_path*]
    sql: ${quantity} ;;
  }
}

fact_agg_item_sales_by_day.view.lookml · 47 lines

source-preserved

- view: fact_agg_item_sales_by_day
  sql_table_name: FactAggItemSalesByDay
  fields:
  - dimension: date_key
    type: int
    sql: ${TABLE}.DateKey
  - dimension: sales_outlet_key
    type: int
    sql: ${TABLE}.SalesOutletKey
  - dimension: source_key
    type: int
    sql: ${TABLE}.SourceKey
  - dimension: category_group
    sql: ${TABLE}.CategoryGroup
  - dimension: category
    sql: ${TABLE}.Category
  - dimension: sub_category
    sql: ${TABLE}.SubCategory
  - dimension: item_description
    sql: ${TABLE}.ItemDescription
  - dimension: quantity
    type: number
    sql: ${TABLE}.Quantity
  - dimension: avg_price
    sql: ${TABLE}.AvgPrice
  - dimension: gross_sales
    sql: ${TABLE}.GrossSales
  - dimension: net_sales
    sql: ${TABLE}.NetSales
  - measure: total_gross_sales
    type: sum
    drill_fields:
    - category_group
    - category
    - sub_category
    - total_gross_sales
    sql: ${gross_sales}
  - measure: total_net_sales
    type: sum
    drill_fields:
    - drill_path*
    sql: ${net_sales}
  - measure: total_quantity
    type: sum
    drill_fields:
    - drill_path*
    sql: ${quantity}

fact_agg_item_sales_by_day.view.lkml
fact_agg_item_sales_by_day.view.lookml

Fact Agg Item Sales By Day

Blocks

Contents