updates
Change-Id: I43f7d673bcacf406d4ac0b19c222aaf706b645f0
diff --git a/explores/revenue_explore.view.lkml b/explores/revenue_explore.view.lkml
index 086b41a..70666e2 100644
--- a/explores/revenue_explore.view.lkml
+++ b/explores/revenue_explore.view.lkml
@@ -1,4 +1,8 @@
include: "../views/*.view.lkml"
-explore: revenue_view {
+explore: revenue_view2 {
+ view_name: revenue_view2
label: "revenue explore label"
-}
+access_filter: {
+ field: revenue_view2.billing_account_id
+ user_attribute: dept
+}}
diff --git a/revenue.model.lkml b/revenue.model.lkml
index 284c253..602e628 100644
--- a/revenue.model.lkml
+++ b/revenue.model.lkml
@@ -2,3 +2,4 @@
include: "/views/*.view.lkml" # include all views in the views/ folder in this project
include: "/explores/*.view.lkml" # include all views in the views/ folder in this project
+label: "revenue label"
diff --git a/views/revenue_view.view.lkml b/views/revenue_view.view.lkml
index 9f1957e..ebc730a 100644
--- a/views/revenue_view.view.lkml
+++ b/views/revenue_view.view.lkml
@@ -1,4 +1,4 @@
-view: revenue_view {
+view: revenue_view2 {
label: "revenue view label"
# # You can specify the table name if it's different from the view name:
sql_table_name: gcc_internal.revenue ;;
@@ -9,6 +9,11 @@
type: date
sql: ${TABLE}.usage_date ;;
}
+ dimension: billing_account_id {
+ description: "this is the billing account id"
+ type: string
+ sql: ${TABLE}.billing_account_id ;;
+ }
#
# dimension: lifetime_orders {
# description: "The total number of orders for each user"
