sku_id, sku_description
diff --git a/revenue_trends.dashboard.lookml b/revenue_trends.dashboard.lookml
index a8a432d..42d0d63 100644
--- a/revenue_trends.dashboard.lookml
+++ b/revenue_trends.dashboard.lookml
@@ -62,8 +62,8 @@
GCP Revenue Source: revenue.gcp_revenue_source
Billing Account ID: revenue.billing_account_id
Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
Is Data Analytics? (Yes / No): revenue.is_data_analytics
Revenue Granularity: revenue.revenue_granularity
Region: revenue.region
@@ -72,12 +72,12 @@
Sub Region: revenue.sub_region
Micro Region: revenue.micro_region
NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
+ Reporting Account Name: revenue.reporting_account_name
Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
row: 12
col: 0
width: 24
@@ -157,8 +157,8 @@
GCP Revenue Source: revenue.gcp_revenue_source
Billing Account ID: revenue.billing_account_id
Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
Is Data Analytics? (Yes / No): revenue.is_data_analytics
Revenue Granularity: revenue.revenue_granularity
Region: revenue.region
@@ -167,12 +167,12 @@
Sub Region: revenue.sub_region
Micro Region: revenue.micro_region
NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
+ Reporting Account Name: revenue.reporting_account_name
Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
row: 24
col: 0
width: 24
@@ -248,8 +248,8 @@
GCP Revenue Source: revenue.gcp_revenue_source
Billing Account ID: revenue.billing_account_id
Logical Product (L3): revenue.logical_product_l3
- # SKU ID: revenue.sku_id
- # Sub-Account Name: vector_customers.account_name
+ SKU ID: revenue.sku_id
+ Sub-Account Name: vector_customers.account_name
Is Data Analytics? (Yes / No): revenue.is_data_analytics
Revenue Granularity: revenue.revenue_granularity
Region: revenue.region
@@ -258,12 +258,12 @@
Sub Region: revenue.sub_region
Micro Region: revenue.micro_region
NAL Cluster: revenue.nal_cluster
- # NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Subcluster: vector_customers.nal_sub_cluster
NAL Name: revenue.nal_name
- # Reporting Account Name: revenue.reporting_account_name
+ Reporting Account Name: revenue.reporting_account_name
Segment: revenue.segment
- # Digital Native vs. Traditional: vector_customers.is_digital_native
- # Is ISV? (Yes / No): vector_customers.is_isv
+ Digital Native vs Traditional: vector_customers.is_digital_native
+ Is ISV? (Yes / No): vector_customers.is_isv
row: 7
col: 3
width: 7
@@ -1778,20 +1778,20 @@
explore: revenue
listens_to_filters: []
field: revenue.nal_cluster
- # - name: NAL Subcluster
- # title: NAL Subcluster
- # type: field_filter
- # default_value: ''
- # allow_multiple_values: true
- # required: false
- # ui_config:
- # type: tag_list
- # display: popover
- # options: []
- # model: hdeist-test-model
- # explore: revenue
- # listens_to_filters: []
- # field: vector_customers.nal_sub_cluster
+ - name: NAL Subcluster
+ title: NAL Subcluster
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: tag_list
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: vector_customers.nal_sub_cluster
- name: NAL Name
title: NAL Name
type: field_filter
@@ -1806,34 +1806,34 @@
explore: revenue
listens_to_filters: []
field: revenue.nal_name
- # - name: Reporting Account Name
- # title: Reporting Account Name
- # type: field_filter
- # default_value: ''
- # allow_multiple_values: true
- # required: false
- # ui_config:
- # type: tag_list
- # display: popover
- # options: []
- # model: hdeist-test-model
- # explore: vector_customers
- # listens_to_filters: []
- # field: vector_customers.reporting_account_name
- # - name: Sub-Account Name
- # title: Sub-Account Name
- # type: field_filter
- # default_value: ''
- # allow_multiple_values: true
- # required: false
- # ui_config:
- # type: tag_list
- # display: popover
- # options: []
- # model: cloud_sales_bi
- # explore: revenue
- # listens_to_filters: [Reporting Account Name]
- # field: vector_customers.account_name
+ - name: Reporting Account Name
+ title: Reporting Account Name
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: tag_list
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: vector_customers
+ listens_to_filters: []
+ field: vector_customers.reporting_account_name
+ - name: Sub-Account Name
+ title: Sub-Account Name
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: tag_list
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: [Reporting Account Name]
+ field: vector_customers.account_name
- name: SFDC Account ID
title: SFDC Account ID
type: field_filter
@@ -1935,34 +1935,34 @@
explore: revenue
listens_to_filters: []
field: revenue.segment
- # - name: Digital Native vs. Traditional
- # title: Digital Native vs. Traditional
- # type: field_filter
- # default_value: ''
- # allow_multiple_values: true
- # required: false
- # ui_config:
- # type: button_group
- # display: inline
- # options: []
- # model: cloud_sales_bi
- # explore: revenue
- # listens_to_filters: []
- # field: vector_customers.is_digital_native
- # - name: SKU ID
- # title: SKU ID
- # type: field_filter
- # default_value: ''
- # allow_multiple_values: true
- # required: false
- # ui_config:
- # type: advanced
- # display: popover
- # options: []
- # model: cloud_sales_bi
- # explore: revenue
- # listens_to_filters: []
- # field: revenue.sku_id
+ - name: Digital Native vs Traditional
+ title: Digital Native vs Traditional
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: button_group
+ display: inline
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: vector_customers.is_digital_native
+ - name: SKU ID
+ title: SKU ID
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.sku_id
- name: Revenue Granularity
title: Revenue Granularity
type: field_filter
@@ -1977,17 +1977,17 @@
explore: revenue
listens_to_filters: []
field: revenue.revenue_granularity
- # - name: Is ISV? (Yes / No)
- # title: Is ISV? (Yes / No)
- # type: field_filter
- # default_value: ''
- # allow_multiple_values: true
- # required: false
- # ui_config:
- # type: advanced
- # display: inline
- # options: []
- # model: cloud_sales_bi
- # explore: vector_customers
- # listens_to_filters: []
- # field: vector_customers.is_isv
+ - name: Is ISV? (Yes / No)
+ title: Is ISV? (Yes / No)
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: inline
+ options: []
+ model: hdeist-test-model
+ explore: vector_customers
+ listens_to_filters: []
+ field: vector_customers.is_isv
diff --git a/views/revenue/revenue.view.lkml b/views/revenue/revenue.view.lkml
index 2c038a3..f2b0367 100644
--- a/views/revenue/revenue.view.lkml
+++ b/views/revenue/revenue.view.lkml
@@ -2,15 +2,39 @@
include: "account_from_account_revenue.view.lkml"
include: "comparisons_from_revenue.view.lkml"
include: "revenue_from_revenue.view.lkml"
-include: "rolling_window.view.lkml"
+# include: "revenue_dailies.view.lkml"
+include: "revenue_from_project_usage_daily.view.lkml"
include: "to_date_fields.view.lkml"
+include: "rolling_window.view.lkml"
+include: "/views/region.view.lkml"
+
view: revenue {
- extends: [account_from_revenue, comparisons_from_revenue, revenue_from_revenue, to_date_fields, rolling_window]
+ extends: [account_from_revenue, comparisons_from_revenue, revenue_from_revenue, to_date_fields, rolling_window, region, revenue_from_project_usage_daily]
+
sql_table_name: `concord-test.stagingservice_gcc.gcc_revenue_partitioned_view`;;
+########## DIMENSIONS ############
+
+ dimension: access_key_hierarchy {
+ description: "Pipe-separated string containing the usernames of individuals assigned to the associated Vector account and everyone in their reporting hierarchy"
+ sql: ${TABLE}.access_key_hierarchy ;;
+ }
+
+ dimension: access_tag_list {
+ description: "Pipe-seperated string containing access information such as Segment, Region, etc"
+ hidden: yes
+ type: string
+ sql: ${TABLE}.access_tag_list ;;
+ }
+
+ dimension: nal_id {
+ sql: ${TABLE}.nal_id ;;
+ }
+
##### PARAMETERS #####
+
parameter: revenue_granularity {
view_label: "Pre- or Post-Split"
description: "Allows the user to toggle between split revenue and non-split revenue. Default value is Split"
diff --git a/views/revenue/revenue_from_revenue.view.lkml b/views/revenue/revenue_from_revenue.view.lkml
index 4220b22..59ec8f2 100644
--- a/views/revenue/revenue_from_revenue.view.lkml
+++ b/views/revenue/revenue_from_revenue.view.lkml
@@ -1,12 +1,16 @@
# emulates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue_from_revenue.view.lkml
view: revenue_from_revenue {
+
extension: required
+
########## DIMENSIONS ############
+
dimension: currency_code {
view_label: "Revenue"
description: "Three letter currency code (e.g. USD) for local billing amount."
sql: ${TABLE}.currency_code ;;
}
+
dimension: dynamic_usage_timeframe {
view_label: "Revenue"
description: "Dynamic field that is returns usage date, dependent on `Usage Timeframe Selector`. If none selected, defaults to daily."
@@ -17,6 +21,7 @@
WHEN {% parameter usage_timeframe_selector %} = 'Month' THEN CONCAT(${usage_month},"-01")
END ;;
}
+
dimension: gcp_revenue_source {
view_label: "Revenue"
label: "GCP Revenue Source"
@@ -37,6 +42,7 @@
else: "Other Revenue"
}
}
+
dimension_group: invoice_month_start {
type: time
timeframes: [raw, date, week, month, quarter, year]
@@ -57,6 +63,7 @@
'Informatica', 'MongoDB Inc.', 'Palantir') ;;
description: "Returns yes if this is Data & Analytics (DA) usage"
}
+
dimension: is_dataproc {
type: yesno
label: "Is Dataproc Node?"
@@ -64,12 +71,14 @@
sql: ${TABLE}.is_dataproc_node ;;
description: "Does this usage come from a Dataproc node?"
}
+
dimension: is_gcp_marketplace {
type: yesno
label: "Is GCP Marketplace?"
view_label: "Product"
sql: ${TABLE}.is_gcp_marketplace ;;
}
+
dimension: is_gke_node {
type: yesno
label: "Is GKE Node?"
@@ -77,6 +86,7 @@
sql: ${TABLE}.is_gke_node ;;
description: "Does this usage come from a GKE node?"
}
+
dimension: product_family_l1 {
label: "Product Family (L1)"
group_label: "Finance Product Hierarchy"
@@ -85,6 +95,7 @@
sql: ${TABLE}.product_group ;;
drill_fields: [product_group_l2]
}
+
dimension: product_group_l2 {
label: "Product Group (L2)"
group_label: "Finance Product Hierarchy"
@@ -93,6 +104,7 @@
sql: ${TABLE}.product_group_l2 ;;
drill_fields: [logical_product_l3]
}
+
dimension: logical_product_l3 {
label: "Logical Product (L3)"
group_label: "Finance Product Hierarchy"
@@ -100,23 +112,26 @@
description: "Examples: Persistent Disk, VM Image Storage, GCE"
sql: ${TABLE}.logical_product_l3 ;;
}
- # dimension: machine_type {
- # view_label: "Product"
- # description: "Machine Type Classifications for Compute Engine"
- # sql: IF(${product_line_raw} = "Compute Engine", CASE
- # WHEN ${is_gke_node} THEN "GKE"
- # WHEN ${is_dataproc} THEN "Dataproc"
- # WHEN ${sku_description} LIKE '%A2 %' THEN 'A2'
- # WHEN ${sku_description} LIKE '%E2 %' THEN 'E2'
- # WHEN ${sku_description} LIKE '%Memory%optimized%' THEN 'M1/M2'
- # WHEN ${sku_description} LIKE '%N2 %' THEN 'N2'
- # WHEN ${sku_description} LIKE '%N2D%' THEN 'N2D'
- # WHEN ${sku_description} LIKE '%Compute%optimized%' THEN 'C2'
- # WHEN LOWER(${sku_description}) LIKE '%custom%ram%' OR ${sku_description} LIKE '%Custom%Core%' OR ${sku_description} LIKE '%N1 %' OR ${sku_description} LIKE '%v1: Cpu%' OR ${sku_description} LIKE '%v1: Ram%' OR ${sku_description} LIKE '%Instance Ram hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance RAM%' OR ${sku_description} LIKE '%Sole Tenancy Instance Ram%' OR ${sku_description} LIKE '%Instance Core hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance Core%' OR ${sku_description} LIKE 'Micro Instance%' OR ${sku_description} LIKE 'Preemptible Micro Instance%' OR ${sku_description} LIKE '%Small Instance%' THEN "N1"
- # ELSE "Other Machine Type"
- # END, NULL) ;;
- # drill_fields: [sku_description]
- # }
+
+
+ dimension: machine_type {
+ view_label: "Product"
+ description: "Machine Type Classifications for Compute Engine"
+ sql: IF(${product_line_raw} = "Compute Engine", CASE
+ WHEN ${is_gke_node} THEN "GKE"
+ WHEN ${is_dataproc} THEN "Dataproc"
+ WHEN ${sku_description} LIKE '%A2 %' THEN 'A2'
+ WHEN ${sku_description} LIKE '%E2 %' THEN 'E2'
+ WHEN ${sku_description} LIKE '%Memory%optimized%' THEN 'M1/M2'
+ WHEN ${sku_description} LIKE '%N2 %' THEN 'N2'
+ WHEN ${sku_description} LIKE '%N2D%' THEN 'N2D'
+ WHEN ${sku_description} LIKE '%Compute%optimized%' THEN 'C2'
+ WHEN LOWER(${sku_description}) LIKE '%custom%ram%' OR ${sku_description} LIKE '%Custom%Core%' OR ${sku_description} LIKE '%N1 %' OR ${sku_description} LIKE '%v1: Cpu%' OR ${sku_description} LIKE '%v1: Ram%' OR ${sku_description} LIKE '%Instance Ram hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance RAM%' OR ${sku_description} LIKE '%Sole Tenancy Instance Ram%' OR ${sku_description} LIKE '%Instance Core hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance Core%' OR ${sku_description} LIKE 'Micro Instance%' OR ${sku_description} LIKE 'Preemptible Micro Instance%' OR ${sku_description} LIKE '%Small Instance%' THEN "N1"
+ ELSE "Other Machine Type"
+ END, NULL) ;;
+ drill_fields: [sku_description]
+ }
+
dimension: product_group {
group_label: "Legacy Product Hierarchy"
view_label: "Product"
