create derived table pru Change-Id: I9755efb9b0e481e185b0c520798349854629da68

diff --git a/hdeist-pdt.model.lkml b/hdeist-pdt.model.lkml
index 388ed00..669feb4 100644
--- a/hdeist-pdt.model.lkml
+++ b/hdeist-pdt.model.lkml

@@ -1,10 +1,12 @@
 connection: "fdm_pdt"
 
-# include: "/*.view"
+include: "/*.view"
 datagroup: pdt_datagroup {
   max_cache_age: "1 hour"
 }
 
 persist_with: pdt_datagroup
 
-# explore: uli_view {}
+explore: uli_view2 {}
+
+explore: pru {}

diff --git a/pru.view.lkml b/pru.view.lkml
new file mode 100644
index 0000000..190dcd8
--- /dev/null
+++ b/pru.view.lkml

@@ -0,0 +1,12 @@
+view: pru {
+  derived_table : {
+    explore_source: uli_view2 {
+      column: partition_date {
+        field: uli_view2.partition_date
+      }
+      column: usage_date {
+        field: uli_view2.usage_date
+      }
+    }
+  }
+}

diff --git a/uli_view2.view.lkml b/uli_view2.view.lkml
new file mode 100644
index 0000000..43064cf
--- /dev/null
+++ b/uli_view2.view.lkml

@@ -0,0 +1,26 @@
+
+
+view: uli_view2 {
+  sql_table_name: `irvine-sbx.fdm.uli` ;;
+
+  dimension: partition_date {
+    type: string
+    sql: ${TABLE}.partition_date ;;
+  }
+
+  dimension: service_id {
+    type: string
+    sql: ${TABLE}.service_id ;;
+  }
+
+  dimension: usage_date {
+    type: date
+    datatype: date
+    sql: ${TABLE}.usage_date ;;
+  }
+
+  measure: count {
+    type: count
+  }
+
+}