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"