create revenue_view

Change-Id: I115fcc70fc6d8cee60ab76b2ed60ab28cf68d695

explores/.gitkeep

diff --git a/explores/.gitkeep b/explores/.gitkeep
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/explores/.gitkeep

explores/revenue_explore.view.lkml

diff --git a/explores/revenue_explore.view.lkml b/explores/revenue_explore.view.lkml
new file mode 100644
index 0000000..d3a7a0f
--- /dev/null
+++ b/explores/revenue_explore.view.lkml
@@ -0,0 +1,9 @@
+include: "../views/*.view.lkml"
+explore: revenue_view {
+  view_name: revenue_view
+  label: "revenue explore label"
+  access_filter: {
+    field: revenue_view.billing_account_id
+    user_attribute: dept
+  }
+  }

hdeist-fdm.model.lkml

diff --git a/hdeist-fdm.model.lkml b/hdeist-fdm.model.lkml
index 6007f90..d7800a6 100644
--- a/hdeist-fdm.model.lkml
+++ b/hdeist-fdm.model.lkml
@@ -1,10 +1,10 @@
 
-connection: "concord"
+connection: "gcc-internal"
 
 # bozo
 # wednesday
-include: "/*.view"
-include: "/*.explore"
+include: "views/*.view.lkml"
+# include: "/*.explore"
 datagroup: hdeist_fdm_default_datagroup {
   max_cache_age: "1 hour"
 }

uli_explore.explore.lkml

diff --git a/uli_explore.explore.lkml b/uli_explore.explore.lkml
deleted file mode 100644
index 5a9dd8e..0000000
--- a/uli_explore.explore.lkml
+++ /dev/null
@@ -1,3 +0,0 @@
-include: "/*.view"
-
-explore: uli_view {}

uli_view.view.lkml

diff --git a/uli_view.view.lkml b/uli_view.view.lkml
deleted file mode 100644
index 4b1ce12..0000000
--- a/uli_view.view.lkml
+++ /dev/null
@@ -1,31 +0,0 @@
-
-
-view: uli_view {
-  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 ;;
-  }
-
-  dimension: zork {
-    type: string
-    sql: 'zork' ;;
-  }
-
-  measure: count {
-    type: count
-  }
-
-}

views/.gitkeep

diff --git a/views/.gitkeep b/views/.gitkeep
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/views/.gitkeep

views/revenue.view.lkml

diff --git a/views/revenue.view.lkml b/views/revenue.view.lkml
new file mode 100644
index 0000000..78cd57a
--- /dev/null
+++ b/views/revenue.view.lkml
@@ -0,0 +1,84 @@
+view: revenue_view {
+  sql_table_name: `irvine-sbx2.gcc_internal.revenue`
+    ;;
+
+  dimension: billing_account_id {
+    type: string
+    sql: ${TABLE}.billing_account_id ;;
+  }
+
+  dimension: currency_code {
+    type: string
+    sql: ${TABLE}.currency_code ;;
+  }
+
+  dimension_group: invoice_month_start {
+    type: time
+    timeframes: [
+      raw,
+      date,
+      week,
+      month,
+      quarter,
+      year
+    ]
+    convert_tz: no
+    datatype: date
+    sql: ${TABLE}.invoice_month_start ;;
+  }
+
+  dimension: product_group {
+    type: string
+    sql: ${TABLE}.product_group ;;
+  }
+
+  dimension: product_line {
+    type: string
+    sql: ${TABLE}.product_line ;;
+  }
+
+  dimension: segment {
+    type: string
+    sql: ${TABLE}.segment ;;
+  }
+
+  dimension: sfdc_account_id {
+    type: string
+    sql: ${TABLE}.sfdc_account_id ;;
+  }
+
+  dimension_group: usage {
+    type: time
+    timeframes: [
+      raw,
+      date,
+      week,
+      month,
+      quarter,
+      year
+    ]
+    convert_tz: no
+    datatype: date
+    sql: ${TABLE}.usage_date ;;
+  }
+
+  dimension: usd_revenue_cn {
+    type: number
+    sql: ${TABLE}.usd_revenue_cn ;;
+  }
+
+  dimension: usd_revenue_gross {
+    type: number
+    sql: ${TABLE}.usd_revenue_gross ;;
+  }
+
+  dimension: usd_revenue_net {
+    type: number
+    sql: ${TABLE}.usd_revenue_net ;;
+  }
+
+  measure: count {
+    type: count
+    drill_fields: []
+  }
+}