data.ml
LookML Ecommerce supplies

Customer

Customer model for ecommerce supplies.

source-preserved

Blocks

customer.view.lkml · 302 lines
inferred 
view: customer {
  sql_table_name: Customer ;;

  dimension: customer_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.CustomerID ;;
  }

  dimension: active {
    type: yesno
    sql: ${TABLE}.Active = 1 ;;
  }

  dimension: admin_can_view_cc {
    type: yesno
    hidden: yes
    sql: ${TABLE}.AdminCanViewCC = 1 ;;
  }

  dimension: affiliate_id {
    type: int
    hidden: yes
    sql: ${TABLE}.AffiliateID ;;
  }

  dimension: bad_login_count {
    type: int
    sql: ${TABLE}.BadLoginCount ;;
  }

  dimension: billing_address_id {
    type: int
    sql: ${TABLE}.BillingAddressID ;;
  }

  dimension: billing_equals_shipping {
    type: yesno
    sql: ${TABLE}.BillingEqualsShipping = 1 ;;
  }

  dimension: buy_safe {
    sql: ${TABLE}.BuySafe ;;
  }

  dimension: cim_profile_id {
    type: int
    sql: ${TABLE}.CIM_ProfileId ;;
  }

  dimension: codcompany_check_allowed {
    type: yesno
    sql: ${TABLE}.CODCompanyCheckAllowed = 1 ;;
  }

  dimension: codnet30_allowed {
    type: yesno
    sql: ${TABLE}.CODNet30Allowed = 1 ;;
  }

  dimension: coupon_code {
    sql: ${TABLE}.CouponCode ;;
  }

  dimension: currency_setting {
    sql: ${TABLE}.CurrencySetting ;;
  }

  dimension: customer_guid {
    sql: ${TABLE}.CustomerGUID ;;
  }

  dimension: customer_level_id {
    type: int
    sql: ${TABLE}.CustomerLevelID ;;
  }

  dimension: deleted {
    type: yesno
    sql: ${TABLE}.Deleted = 1 ;;
  }

  dimension: email {
    sql: ${TABLE}.Email ;;
  }

  dimension: extension_data {
    sql: ${TABLE}.ExtensionData ;;
  }

  dimension: fax {
    sql: ${TABLE}.FAX ;;
  }

  dimension: finalization_data {
    sql: ${TABLE}.FinalizationData ;;
  }

  dimension: first_name {
    sql: ${TABLE}.FirstName ;;
  }

  dimension: gender {
    sql: ${TABLE}.Gender ;;
  }

  dimension: gift_registry_allow_search_by_others {
    type: yesno
    sql: ${TABLE}.GiftRegistryAllowSearchByOthers = 1 ;;
  }

  dimension: gift_registry_guid {
    sql: ${TABLE}.GiftRegistryGUID ;;
  }

  dimension: gift_registry_hide_shipping_addresses {
    type: yesno
    sql: ${TABLE}.GiftRegistryHideShippingAddresses = 1 ;;
  }

  dimension: gift_registry_is_anonymous {
    type: yesno
    sql: ${TABLE}.GiftRegistryIsAnonymous = 1 ;;
  }

  dimension: gift_registry_nick_name {
    sql: ${TABLE}.GiftRegistryNickName ;;
  }

  dimension: is_admin {
    type: yesno
    sql: ${TABLE}.IsAdmin = 1 ;;
  }

  dimension: is_registered {
    type: yesno
    sql: ${TABLE}.IsRegistered = 1 ;;
  }

  dimension: last_ipaddress {
    sql: ${TABLE}.LastIPAddress ;;
  }

  dimension: last_name {
    sql: ${TABLE}.LastName ;;
  }

  dimension: locale_setting {
    sql: ${TABLE}.LocaleSetting ;;
  }

  dimension: micro_pay_balance {
    sql: ${TABLE}.MicroPayBalance ;;
  }

  dimension: notes {
    sql: ${TABLE}.Notes ;;
  }

  dimension: ok_to_email {
    type: yesno
    sql: ${TABLE}.OkToEmail = 1 ;;
  }

  dimension: order_notes {
    sql: ${TABLE}.OrderNotes ;;
  }

  dimension: order_options {
    sql: ${TABLE}.OrderOptions ;;
  }

  dimension: over13_checked {
    type: yesno
    sql: ${TABLE}.Over13Checked = 1 ;;
  }

  dimension: password {
    sql: ${TABLE}.Password ;;
  }

  dimension: phone {
    sql: ${TABLE}.Phone ;;
  }

  dimension: pwd_change_required {
    type: yesno
    sql: ${TABLE}.PwdChangeRequired = 1 ;;
  }

  dimension: recurring_shipping_method {
    sql: ${TABLE}.RecurringShippingMethod ;;
  }

  dimension: recurring_shipping_method_id {
    type: int
    sql: ${TABLE}.RecurringShippingMethodID ;;
  }

  dimension: referrer {
    sql: CONVERT(varchar(255), ${TABLE}.Referrer) ;;
  }

  dimension: requested_payment_method {
    sql: ${TABLE}.RequestedPaymentMethod ;;
  }

  dimension: rtship_request {
    sql: ${TABLE}.RTShipRequest ;;
  }

  dimension: rtship_response {
    sql: ${TABLE}.RTShipResponse ;;
  }

  dimension: salt_key {
    type: int
    sql: ${TABLE}.SaltKey ;;
  }

  dimension: shipping_address_id {
    type: int
    sql: ${TABLE}.ShippingAddressID ;;
  }

  dimension: skin_id {
    type: int
    sql: ${TABLE}.SkinID ;;
  }

  dimension: store_ccin_db {
    type: yesno
    sql: ${TABLE}.StoreCCInDB = 1 ;;
  }

  dimension: store_id {
    type: int
    sql: ${TABLE}.StoreID ;;
  }

  dimension: vatregistration_id {
    sql: ${TABLE}.VATRegistrationID ;;
  }

  dimension: vatsetting {
    type: int
    sql: ${TABLE}.VATSetting ;;
  }

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
customer.view.lookml · 209 lines
source-preserved 
- view: customer
  sql_table_name: Customer
  fields:
  - dimension: customer_id
    type: int
    primary_key: true
    sql: ${TABLE}.CustomerID
  - dimension: active
    type: yesno
    sql: ${TABLE}.Active = 1
  - dimension: admin_can_view_cc
    type: yesno
    hidden: true
    sql: ${TABLE}.AdminCanViewCC = 1
  - dimension: affiliate_id
    type: int
    hidden: true
    sql: ${TABLE}.AffiliateID
  - dimension: bad_login_count
    type: int
    sql: ${TABLE}.BadLoginCount
  - dimension: billing_address_id
    type: int
    sql: ${TABLE}.BillingAddressID
  - dimension: billing_equals_shipping
    type: yesno
    sql: ${TABLE}.BillingEqualsShipping = 1
  - dimension: buy_safe
    sql: ${TABLE}.BuySafe
  - dimension: cim_profile_id
    type: int
    sql: ${TABLE}.CIM_ProfileId
  - dimension: codcompany_check_allowed
    type: yesno
    sql: ${TABLE}.CODCompanyCheckAllowed = 1
  - dimension: codnet30_allowed
    type: yesno
    sql: ${TABLE}.CODNet30Allowed = 1
  - dimension: coupon_code
    sql: ${TABLE}.CouponCode
  - dimension: currency_setting
    sql: ${TABLE}.CurrencySetting
  - dimension: customer_guid
    sql: ${TABLE}.CustomerGUID
  - dimension: customer_level_id
    type: int
    sql: ${TABLE}.CustomerLevelID
  - dimension: deleted
    type: yesno
    sql: ${TABLE}.Deleted = 1
  - dimension: email
    sql: ${TABLE}.Email
  - dimension: extension_data
    sql: ${TABLE}.ExtensionData
  - dimension: fax
    sql: ${TABLE}.FAX
  - dimension: finalization_data
    sql: ${TABLE}.FinalizationData
  - dimension: first_name
    sql: ${TABLE}.FirstName
  - dimension: gender
    sql: ${TABLE}.Gender
  - dimension: gift_registry_allow_search_by_others
    type: yesno
    sql: ${TABLE}.GiftRegistryAllowSearchByOthers = 1
  - dimension: gift_registry_guid
    sql: ${TABLE}.GiftRegistryGUID
  - dimension: gift_registry_hide_shipping_addresses
    type: yesno
    sql: ${TABLE}.GiftRegistryHideShippingAddresses = 1
  - dimension: gift_registry_is_anonymous
    type: yesno
    sql: ${TABLE}.GiftRegistryIsAnonymous = 1
  - dimension: gift_registry_nick_name
    sql: ${TABLE}.GiftRegistryNickName
  - dimension: is_admin
    type: yesno
    sql: ${TABLE}.IsAdmin = 1
  - dimension: is_registered
    type: yesno
    sql: ${TABLE}.IsRegistered = 1
  - dimension: last_ipaddress
    sql: ${TABLE}.LastIPAddress
  - dimension: last_name
    sql: ${TABLE}.LastName
  - dimension: locale_setting
    sql: ${TABLE}.LocaleSetting
  - dimension: micro_pay_balance
    sql: ${TABLE}.MicroPayBalance
  - dimension: notes
    sql: ${TABLE}.Notes
  - dimension: ok_to_email
    type: yesno
    sql: ${TABLE}.OkToEmail = 1
  - dimension: order_notes
    sql: ${TABLE}.OrderNotes
  - dimension: order_options
    sql: ${TABLE}.OrderOptions
  - dimension: over13_checked
    type: yesno
    sql: ${TABLE}.Over13Checked = 1
  - dimension: password
    sql: ${TABLE}.Password
  - dimension: phone
    sql: ${TABLE}.Phone
  - dimension: pwd_change_required
    type: yesno
    sql: ${TABLE}.PwdChangeRequired = 1
  - dimension: recurring_shipping_method
    sql: ${TABLE}.RecurringShippingMethod
  - dimension: recurring_shipping_method_id
    type: int
    sql: ${TABLE}.RecurringShippingMethodID
  - dimension: referrer
    sql: CONVERT(varchar(255), ${TABLE}.Referrer)
  - dimension: requested_payment_method
    sql: ${TABLE}.RequestedPaymentMethod
  - dimension: rtship_request
    sql: ${TABLE}.RTShipRequest
  - dimension: rtship_response
    sql: ${TABLE}.RTShipResponse
  - dimension: salt_key
    type: int
    sql: ${TABLE}.SaltKey
  - dimension: shipping_address_id
    type: int
    sql: ${TABLE}.ShippingAddressID
  - dimension: skin_id
    type: int
    sql: ${TABLE}.SkinID
  - dimension: store_ccin_db
    type: yesno
    sql: ${TABLE}.StoreCCInDB = 1
  - dimension: store_id
    type: int
    sql: ${TABLE}.StoreID
  - dimension: vatregistration_id
    sql: ${TABLE}.VATRegistrationID
  - dimension: vatsetting
    type: int
    sql: ${TABLE}.VATSetting
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreatedOn
  - dimension_group: date_of_birth
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateOfBirth
  - dimension_group: last_bad_login
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastBadLogin
  - dimension_group: locked_until
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LockedUntil
  - dimension_group: pwd_changed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.PwdChanged
  - dimension_group: register
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.RegisterDate
  - dimension_group: subscription_expires
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.SubscriptionExpiresOn
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.UpdatedOn
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • customer.view.lkml
  • customer.view.lookml