data.ml
LKML Fintech consulting

Fiscal Dell

Fiscal Dell model for fintech consulting.

inferred

Blocks

fiscal_dell.view.lkml · 49 lines
inferred 
view: fiscal_dell {
  sql_table_name: ${TABLE}.fiscal_data ;;

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

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

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

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

  dimension: fy_year_week {
    type: string
    sql: CONCAT(${TABLE}.fy_year,' FW',LPAD(${TABLE}.fy_week,2,'0')) ;;
  }

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

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

  dimension_group: trx_date {
    type: time
    timeframes: [date]
    sql: ${TABLE}.trx_date ;;
  }

  measure: count {
    type: count
  }
}
fiscal_dell.view.lookml · 34 lines
source-preserved 
- view: fiscal_dell
  sql_table_name: ${TABLE}.fiscal_data
  fields:
  - dimension: fq_week
    type: int
    sql: ${TABLE}.fq_week
  - dimension: fy_qrtr
    type: int
    sql: ${TABLE}.fy_qrtr
  - dimension: fy_week
    type: int
    sql: ${TABLE}.fy_week
  - dimension: fy_year
    type: int
    sql: ${TABLE}.fy_year
  - dimension: fy_year_week
    type: string
    sql: CONCAT(${TABLE}.fy_year,' FW',LPAD(${TABLE}.fy_week,2,'0'))
  - dimension: holiday
    type: int
    sql: ${TABLE}.holiday
  - dimension_group: trx
    type: time
    timeframes:
    - week
    - month
    sql: ${TABLE}.trx_date
  - dimension_group: trx_date
    type: time
    timeframes:
    - date
    sql: ${TABLE}.trx_date
  - measure: count
    type: count

Contents

  • fiscal_dell.view.lkml
  • fiscal_dell.view.lookml