Add stuff to revenue explore Change-Id: I8c357b22780632817c25f643d0f0600f39bc8147
diff --git a/explores/revenue.view.lkml b/explores/revenue.view.lkml index e188b19..d77b2e8 100644 --- a/explores/revenue.view.lkml +++ b/explores/revenue.view.lkml
@@ -1,4 +1,14 @@ # Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/explores/revenue.view.lkml -include: "/views/revenue/revenue.view.lkml" +include: "/views/revenue/*.view.lkml" -explore: revenue {} +explore: revenue { + label: "Usage Revenue" + description: "Daily Revenue for GCC Cloud BI Sales, defaults to Split Revenue" + always_filter: { + filters: [ + revenue.segment: "-Scaled" + , revenue.product_line: "-Looker,-Looker Data Platform SaaS" + , revenue.sub_region: "-NULL" + , revenue.service_family: "CLOUD" + ] + }}
diff --git a/views/revenue/account_from_account_revenue.view.lkml b/views/revenue/account_from_account_revenue.view.lkml new file mode 100644 index 0000000..c627496 --- /dev/null +++ b/views/revenue/account_from_account_revenue.view.lkml
@@ -0,0 +1,197 @@ +# https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/account_from_account_revenue.view.lkml + +view: account_from_revenue { + extension: required + ########## DIMENSIONS ############ + dimension: billing_account_id { + view_label: "Account" + group_label: "Identifiers" + description: "Billing account ID" + sql: ${TABLE}.billing_account_id ;; + } + dimension: country { + alias: [account_meta.country] + view_label: "Account" + group_label: "Geography" + description: "Country code for Account location" + sql: ${TABLE}.country ;; + } + dimension: geocluster { + alias: [account_meta.geocluster] + } + dimension: industry { + view_label: "Account" + group_label: "Industry" + description: "Examples: Software & Internet, Business & Professional Services, Public Sector & EDU" + alias: [account_meta.industry] + sql: ${TABLE}.industry ;; + drill_fields: [sub_industry] + } + dimension: micro_region { + alias: [account_meta.micro_region] + } + dimension: micro_industry { + view_label: "Account" + group_label: "Industry" + description: "Examples: Higher Education, Storage & Data Mgt, Specialty- Apparel & Footware" + alias: [account_meta.micro_industry] + sql: ${TABLE}.micro_industry ;; + } + dimension: nal_cluster { + alias: [account_meta.nal_cluster] + } + dimension: nal_id { + alias: [account_meta.nal_id] + } + dimension: nal_name { + alias: [account_meta.nal_name] + } + dimension: region { + alias: [account_meta.region] + } + dimension: region_toggle { + alias: [account_meta.region_toggle] + sql: {% if region_granularity._parameter_value == "region" %} + ${region} + {% elsif region_granularity._parameter_value == "geocluster" %} + ${geocluster} + {% elsif region_granularity._parameter_value == "sector" %} + ${sector} + {% elsif region_granularity._parameter_value == "sub_region" %} + ${sub_region} + {% elsif region_granularity._parameter_value == "micro_region" %} + ${micro_region} + {% elsif region_granularity._parameter_value == "nal_cluster" %} + ${nal_cluster} + {% elsif region_granularity._parameter_value == "nal_name" %} + ${nal_name} + {% elsif region_granularity._parameter_value == "nal_id" %} + ${nal_id} + {% elsif region_granularity._parameter_value == "reporting_account_name" %} + ${reporting_account_name} + {% elsif region_granularity._parameter_value == "sfdc_account_id" %} + ${sfdc_account_id} + {% endif %} + ;; + drill_fields: [region, geocluster, sector, sub_region, micro_region, nal_cluster, nal_name, nal_id, reporting_account_name, sfdc_account_id] + } + dimension: reporting_account_name { + alias: [account_meta.reporting_account_name] + group_label: "Identifiers" + view_label: "Account" + description: "Top most non roll up “customer” account in the hierarchy" + sql: ${TABLE}.reporting_account_name ;; + link: { + url: "https://lookercs-sales.corp.goog/dashboards-next/82?Reporting+Account+Name={{ filterable_value | url_encode }}" + label: "Revenue Trends" + } + link: { + url: "https://lookercs-sales.corp.goog/dashboards-next/100?Reporting+Account+Name={{ filterable_value | url_encode }}" + label: "Account Lookup" + } + link: { + url: "https://vector.lightning.force.com/lightning/r/Account/{{reporting_id._value}}/view" + label: "View Account in Vector" + } + link: { + url: "https://lookercs-sales.corp.goog/dashboards/137?Reporting+Account+Name={{ filterable_value | url_encode }}" + label: "Product Trends" + } + # suggest_dimension: account_sort.reporting_account_name + } + dimension: reporting_id { + alias: [account_meta.reporting_id] + view_label: "Account" + group_label: "Identifiers" + description: "Sales segment (e.g. Select, Enterprise etc.,)" + sql: ${TABLE}.reporting_id ;; + link: { + url: "https://vector.lightning.force.com/lightning/r/Account/{{reporting_id._value}}/view" + label: "View Account in Vector" + } + } + ## The field below should be replaced once primary campaign field is available in opps + ## @paolarenteria @pweiler + dimension: is_rev_acceleration_reporting_id { + description: "Returns yes if the reporting ID is a part of 2022RevAcceleration campaign" + type: yesno + hidden: yes + sql: ${reporting_id} IN ("0014M00001h4Zl5QAE","0014M00001h6coWQAQ","0014M00001hrNJpQAM","0014M00001hPv9SQAS","0014M00001h4620QAA","0014M00001hexHTQAY","0014M00001hTUQsQAO","0014M00001hXzOLQA0","0014M00001hWckmQAC","0014M00001hrKHIQA2","0014M00001hnl40QAA","0014M00001haScQQAU","0014M00001hTXhQQAW","0014M00001hTTe5QAG","0014M00001heyWJQAY","0014M00001h46dmQAA","0014M00001hPwqcQAC","0014M00001hnnaDQAQ","0014M00001h6grgQAA","0014M00001hTVEPQA4","0014M00001hVXA6QAO","0014M00001hvN38QAE","0014M00001lGN96QAG","0014M00001hk2cUQAQ","0014M00001xjJNrQAM","0014M00001pqBnnQAE","0014M00001hO2j9QAC","0014M00001hocKHQAY","0014M00001hv9CUQAY","0014M00001haJb8QAE","0014M00001jTAiqQAG","0014M00001hRLBrQAO","0014M00001hS473QAC","0014M00001h5slEQAQ","0014M00001w4d00QAA","0014M00001hV6YnQAK","0014M00001kvbLhQAI","0014M00001hp1RcQAI","0014M00001hQXPZQA4","0014M00001lGGlpQAG","0014M00001hclk0QAA","0014M00001hcHmuQAE","0014M00001hS49OQAS","0014M00001hp46lQAA","0014M00001lz6t3QAA","0014M00001hV7OrQAK","0014M00001hqmvkQAA","0014M00001hWDtUQAW","0014M00001yR4ZYQA0","0014M00001m9GvbQAE","0014M00001hiFXAQA2","0014M00001lGGkRQAW","0014M00001hS494QAC","0014M00001lUNZ5QAO","0014M00001hNizIQAS","0014M00001hmZ7SQAU","0014M00001hmYqKQAU","0014M00001qp9JiQAI","0014M00001hNbmUQAS","0014M00001h3M3MQAU","0014M00001hbFluQAE","0014M00001hQt0xQAC","0014M00001hwZhkQAE","0014M00001oY6efQAC","0014M00001oX6ZeQAK","0014M00001txYgcQAE","0014M00001oY6FFQA0","0014M00001hqKVxQAM","0014M00001hNpMRQA0","0014M00001lV628QAC","0014M00001hvTYKQA2","0014M00001hlEpUQAU","0014M00001hvTfXQAU","0014M00001hg2E8QAI","0014M00001hV7QfQAK","0014M00001hd7wpQAA","0014M00001p4RmHQAU","0014M00001lV398QAC","0014M00001rGvG4QAK","0014M00001hM9CeQAK","0014M00001hq1ohQAA","0014M00001hmI1zQAE","0014M00001hmZVkQAM","0014M00001hfW3eQAE","0014M00001hPsFVQA0","0014M00001hLqPVQA0","0014M00001hqW50QAE","0014M00001hg2DJQAY","0014M00001hZd41QAC","0014M00001hPrJVQA0","0014M00001hg2DxQAI","0014M00001lV6HwQAK","0014M00001hQDqyQAG","0014M00001lV2wWQAS","0014M00001sco16QAA","0014M00001hmcIEQAY","0014M00001kh3n5QAA","0014M00001hQXkrQAG","0014M00001hg2DSQAY","0014M00001hlDfCQAU","0014M00001hlXzdQAE","0014M00001hlDfvQAE","0014M00001hLrGIQA0","0014M00001hWAjIQAW","0014M00001p8KKmQAM","0014M00001hWBQyQAO","0014M00001kvDNfQAM","0014M00001hqGb0QAE","0014M00001haErVQAU","0014M00001hWvn4QAC","0014M00001hqIg2QAE","0014M00001hvJiyQAE","0014M00001hPrH2QAK","0014M00001hZd6PQAS","0014M00001hZiuYQAS","0014M00001hhqZTQAY","0014M00001hvYugQAE","0014M00001hlDg0QAE","0014M00001hjwFhQAI","0014M00001hg2EeQAI","0014M00001hlDfeQAE","0014M00001hqbT7QAI","0014M00001p3l0dQAA","0014M00001qLnhsQAC","0014M00001hQ0EKQA0","0014M00001hcSaNQAU","0014M00001hZiBpQAK","0014M00001hY9cTQAS","0014M00001lV5coQAC","0014M00001hY9ckQAC","0014M00001hfsujQAA","0014M00001hSu5kQAC","0014M00001hPrKTQA0","0014M00001hf81NQAQ","0014M00001hrZ3fQAE","0014M00001hTAeKQAW","0014M00001hR92nQAC","0014M00001hg9uvQAA","0014M00001h6gvNQAQ","0014M00001hSdVuQAK","0014M00001hnj4KQAQ","0014M0000279iJYQAY","0014M00001hKdr7QAC","0014M00001hrHTRQA2","0014M00001hXTKCQA4","0014M00001hXeTBQA0","0014M00001h6pfaQAA","0014M00001hYb3yQAC","0014M00001hJjZbQAK","0014M00001hnUhYQAU","0014M00001hcRfHQAU","0014M00001hXfJIQA0","0014M00001hXSSiQAO","0014M00001hrMOqQAM","0014M00001hmULhQAM","0014M00001p6wBDQAY","0014M00001hXkfGQAS","0014M00001hPxqPQAS","0014M00001hPnvaQAC","0014M00001hr79hQAA","0014M00001hnlOHQAY","0014M00001hSwYXQA0","0014M00001hT6HZQA0","0014M00001hcFxEQAU","0014M00001hfstPQAQ","0014M00001hrZQEQA2","0014M00001hd3B9QAI","0014M00001hrHovQAE","0014M00001hk3DKQAY","0014M00001hPwzqQAC","0014M00001h6tlwQAA","0014M00001hQ4xHQAS","0014M00001hTSWbQAO","0014M00001hs1cRQAQ","0014M00001iiTRXQA2","0014M00001hurVyQAI","0014M00001hfbu9QAA","0014M00001hNlxWQAS","0014M00001hg1TeQAI","0014M00001hXczHQAS","0014M00001lV6FgQAK","0014M00001h5JKrQAM","0014M00001hfdGZQAY","0014M00001hmam5QAA","0014M00001lUNHiQAO","0014M00001hv8gRQAQ","0014M00001hfdH7QAI","0014M00001hffYOQAY","0014M00001hcou9QAA","0014M00001h5JKuQAM","0014M00001hazk8QAA","0014M00001hS6cxQAC","0014M00001hrEYQQA2","0014M00001hb3NwQAI","0014M00001hfxCiQAI","0014M00001haTt7QAE","0014M00001hrIXmQAM","0014M00001hrNXdQAM","0014M00001h5K85QAE","0014M00001lUNkeQAG","0014M00001hS251QAC","0014M00001hmDw3QAE","0014M00001hOCGRQA4","0014M0000269GsHQAU","0014M00001hmeFVQAY","0014M00001hvToGQAU","0014M00001h5NIIQA2","0014M00001lV4hYQAS","0014M00001hbX8yQAE","0014M00001rbfzkQAA","0014M00001haoeAQAQ","0014M00001hmpB8QAI","0014M00001hVsjbQAC","0014M00001hNqG1QAK","0014M00001hvTp6QAE","0014M00001lHkjcQAC","0014M00001pcphIQAQ","0014M00001h5rMSQAY","0014M00001hVlQXQA0","0014M00001hvXdTQAU","0014M00001hmeGYQAY","0014M00001hvSnIQAU","0014M00001hvTVDQA2","0014M00001h3pyaQAA","0014M00001nl7S0QAI","0014M00001hOMsMQAW","0014M00001hahlbQAA","0014M00001hQuxdQAC","0014M00001hiLcWQAU","0014M00001hhcmrQAA","0014M00001hZDE1QAO","0014M00001hZ6wxQAC","0014M00001hYMHZQA4","0014M00001htmmbQAA","0014M00001hlkiTQAQ","0014M00001hhrweQAA","0014M00001hox5IQAQ","0014M00001lUNE9QAO","0014M00001hhqauQAA","0014M00001recuuQAA","0014M00001hTnn6QAC","0014M00001h658ZQAQ","0014M00001hOTDzQAO","0014M00001hpckHQAQ","0014M00001hOTExQAO","0014M00001hq7FoQAI","0014M00001xiITqQAM","0014M00001hjY14QAE","0014M00001hpJ5YQAU","0014M00001hjbKiQAI","0014M00001hY8OaQAK","0014M00001hueOLQAY","0014M00001he6mGQAQ","0014M00001hKVFxQAO","0014M00001hpdWVQAY","0014M00001hkFfNQAU","0014M00001yR8WOQA0","0014M00001hOdgXQAS","0014M00001hjVxrQAE","0014M00001hVXp5QAG","0014M00001hXz1FQAS","0014M00001heyARQAY","0014M00001hfRvsQAE","0014M00001hkn8YQAQ","0014M00001huhBWQAY","0014M00001tQg51QAC","0014M00001hknjXQAQ","0014M00001hvBPLQA2","0014M00001hfmoMQAQ","0014M00001hm4sJQAQ","0014M00001hQygPQAS","0014M00001mI3ygQAC","0014M00001hrfZnQAI","0014M00001h5uszQAA","0014M00001hMu8kQAC","0014M00001hNCqbQAG","0014M00001hXMrCQAW","0014M00001hnxrAQAQ","0014M00001hm72jQAA","0014M00001hrthXQAQ","0014M00001hbKKTQA2","0014M00001hgzHyQAI","0014M00001hnyD5QAI","0014M00001hrhP5QAI","0014M00001hgGXeQAM","0014M00001hR356QAC","0014M00001hXS91QAG","0014M00001haalHQAQ","0014M00001hgClXQAU","0014M00001hfEMXQA2","0014M00001hgHc3QAE","0014M00001hR3viQAC","0014M00001hsYbAQAU","0014M00001hrfbKQAQ","0014M00001hhcltQAA","0014M00001hv7PqQAI","0014M00001hbH4sQAE","0014M00001hXSsyQAG","0014M00001hJocVQAS","0014M00001hmRshQAE","0014M00001hm3OtQAI","0014M00001hR0evQAC","0014M00001hf9i5QAA","0014M00001hrgwvQAA","0014M00001hZZHrQAO","0014M00001h5qZcQAI","0014M00001hm4HxQAI","0014M00001hrgy4QAA","0014M00001hbMLgQAM","0014M00001hfmoUQAQ","0014M00001h4NXjQAM","0014M00001kuQ2ZQAU","0014M00001hR1QdQAK","0014M00001hvBQUQA2","0014M00001hm2uxQAA","0014M00001h4PLFQA2","0014M00001lTxELQA0","0014M00001h4vJHQAY","0014M00001h3hA9QAI","0014M00001hci4zQAA","0014M00001hZBH5QAO","0014M00001hjzuzQAA","0014M00001haTtfQAE","0014M00001hJYHwQAO","0014M00001hXVkhQAG","0014M00001h6IIwQAM","0014M00001hbBWAQA2","0014M00001h6E1HQAU","0014M00001hScH8QAK","0014M00001hrAAWQA2","0014M00001hcXOeQAM","0014M00001hs7TvQAI","0014M00001hgig6QAA","0014M00001hlcAiQAI","0014M00001hZ1tSQAS","0014M00001hKBg6QAG","0014M00001hU8QPQA0","0014M00001hbXMNQA2","0014M00001he25WQAQ","0014M00001hNJ77QAG","0014M00001h5dYgQAI","0014M00001hmcojQAA","0014M00001hdekZQAQ","0014M00001h66SIQAY","0014M00001hdrkPQAQ","0014M00001h3frkQAA","0014M00001hM6U5QAK","0014M00001h48jdQAA","0014M00001hgY2oQAE","0014M00001hO2cyQAC","0014M00001hT2QSQA0","0014M00001hSnCYQA0","0014M00001hgxrhQAA","0014M00001hf2cPQAQ","0014M00001hYAC3QAO","0014M00001hmOh8QAE","0014M00001hKnubQAC","0014M00001heks2QAA","0014M00001hcag7QAA","0014M00001huLftQAE","0014M00001hPVvwQAG","0014M00001hZ5EBQA0","0014M00001hcclIQAQ","0014M00001hrcdCQAQ","0014M00001hrwwuQAA","0014M00001h6HLDQA2","0014M00001k44nlQAA","0014M00001hTeu8QAC","0014M00001hJoC3QAK","0014M00001h5v4VQAQ","0014M00001hXtDbQAK","0014M00001h5zW1QAI","0014M00001hObu5QAC","0014M00001hVM0TQAW","0014M00001hcTvLQAU","0014M00001hdMC3QAM","0014M00001hm2mxQAA","0014M00001hPETSQA4","0014M00001hr4WvQAI","0014M00001hr5LgQAI","0014M00001h5nFsQAI","0014M00001hO45pQAC","0014M00001hgZ7XQAU","0014M00001juDN2QAM","0014M00001hdOTAQA2","0014M00001hYiPhQAK","0014M00001hTFivQAG","0014M00001hfursQAA","0014M00001hb7rmQAA","0014M00001hs0dfQAA","0014M00001hZ8JJQA0","0014M00001hWHW9QAO","0014M00001hPAyKQAW","0014M00001h3cUDQAY","0014M00001hZvqdQAC","0014M00001hcTwVQAU","0014M00001hmfcJQAQ","0014M00001hJWX9QAO","0014M00001vn1dBQAQ","0014M00001hRzNQQA0","0014M00001heqPDQAY","0014M00001hUgXxQAK","0014M00001hcj1wQAA","0014M00001hXSEOQA4","0014M00001hNM3zQAG","0014M00001hYBvCQAW","0014M00001hreDDQAY","0014M00001hNsydQAC","0014M00001hOPRSQA4","0014M00001hPFFpQAO","0014M00001hn6ibQAA","0014M00001n6R1GQAU","0014M00001hP4SDQA0","0014M00001hNNlQQAW","0014M00001hqxTlQAI","0014M00001hOb7YQAS","0014M00001hcH3EQAU","0014M00001h4DErQAM","0014M00001hJqotQAC","0014M00001hSoawQAC","0014M00001h42bXQAQ","0014M00001hr2o1QAA","0014M00001kxTiwQAE","0014M00001hepGgQAI","0014M00001hP7F1QAK","0014M00001hPA7lQAG","0014M00001hbhp1QAA","0014M00001hO4NsQAK","0014M00001hRerkQAC","0014M00001lTijpQAC","0014M00001hcGLhQAM","0014M00001hOg0FQAS","0014M00001h49HEQAY","0014M00001hcC4uQAE","0014M00001hXTjhQAG","0014M00001huGmGQAU","0014M00001h3m1ZQAQ","0014M00001heeaDQAQ","0014M00001hS3SaQAK","0014M00001h5mNMQAY","0014M00001lTiRWQA0","0014M00001hhHqzQAE","0014M00001hTKybQAG","0014M00001hNTEFQA4","0014M00001hcxiNQAQ","0014M00001hr781QAA","0014M00001lwYwCQAU","0014M00001h3pEaQAI","0014M00001hNbAFQA0","0014M00001hvea4QAA","0014M00001h5cpbQAA","0014M00001hbYDxQAM","0014M00001hZRVSQA4","0014M00001mIRBrQAO","0014M00001hJybrQAC","0014M00001hJu1cQAC","0014M00001hXyVhQAK","0014M00001hNOV9QAO","0014M00001hSMYZQA4","0014M00001hm6OrQAI","0014M00001hU6E7QAK","0014M00001h3rwOQAQ","0014M00001h4DcxQAE","0014M00001hXHlBQAW","0014M00001h4BpLQAU","0014M00001hrTEUQA2","0014M00001hfJYEQA2","0014M00001h4YYUQA2","0014M00001hTaDPQA0","0014M00001hRaOWQA0","0014M00001hmOFjQAM","0014M00001hrNS5QAM","0014M00001hg9T5QAI","0014M00001ioTXjQAM","0014M00001hvgWPQAY","0014M00001hZqFaQAK","0014M00001hpityQAA","0014M00001hXswvQAC","0014M00001hv9fTQAQ","0014M00001hmf2TQAQ","0014M00001hJa1kQAC","0014M00001hJxrFQAS","0014M00001hYy62QAC","0014M00001hUqUEQA0","0014M00001h4QCKQA2","0014M00001hrsP0QAI","0014M00001hr42JQAQ","0014M00001hrXBdQAM","0014M00001hbcIAQAY","0014M00001h5rhmQAA","0014M00001hryO2QAI","0014M00001hStyDQAS","0014M00001hZoHaQAK","0014M00001hS6UzQAK","0014M00001hqEKlQAM","0014M00001h3TW4QAM","0014M00001hdFhzQAE","0014M00001h5cA2QAI","0014M00001hcPMuQAM","0014M00001lTiejQAC","0014M00001hSmNUQA0","0014M00001hmtR4QAI","0014M00001hJtN9QAK","0014M00001hrh7iQAA","0014M00001hfHuqQAE","0014M00001h6g2NQAQ","0014M00001hSjFFQA0","0014M00001hYzTfQAK","0014M00001hJjORQA0","0014M00001hP6FLQA0","0014M00001hmgjyQAA","0014M00001hbLbBQAU","0014M00001h4RmhQAE","0014M00001hTxzDQAS","0014M00001hYZOfQAO","0014M00001h3X2KQAU","0014M00001hhSccQAE","0014M00001hP1syQAC","0014M00001hbA34QAE","0014M00001hZr9FQAS","0014M00001hgBCDQA2","0014M00001hZYNPQA4","0014M00001hb5ipQAA","0014M00001hde39QAA","0014M00001hrBEDQA2","0014M00001h3lSlQAI","0014M00001hThShQAK","0014M00001hNmInQAK","0014M00001hqzCyQAI","0014M00001hlMfJQAU","0014M00001hcWJgQAM","0014M00001hsZHXQA2","0014M00001hrjPMQAY","0014M00001hY5uNQAS","0014M00001hgCoBQAU","0014M00001hKMLBQA4","0014M00001haFvZQAU","0014M00001hmUNGQA2","0014M00001hOHW3QAO","0014M00001hdwpSQAQ","0014M00001hbGoHQAU","0014M00001hpTiUQAU","0014M00001lTxIhQAK","0014M00001hdnfbQAA","0014M00001hrGdvQAE","0014M00001hPYsEQAW","0014M00001hOEwsQAG","0014M00001hJxpFQAS","0014M00001hrOcPQAU","0014M00001h5ySGQAY","0014M00001hKizjQAC","0014M00001hTCTLQA4","0014M00001hbbkNQAQ","0014M00001hgU2cQAE","0014M00001hcT9mQAE","0014M00001hkO33QAE","0014M00001hO0dMQAS","0014M00001hJoDIQA0","0014M00001h470qQAA","0014M00001hKbQjQAK","0014M00001hcv8mQAA","0014M00001hZEvWQAW","0014M00001hdcWjQAI","0014M00001hPLssQAG","0014M00001hRSSwQAO","0014M00001hc8xVQAQ","0014M00001hmUx7QAE","0014M00001h4R5nQAE","0014M00001hmglHQAQ","0014M00001h41gNQAQ","0014M00001hZqFLQA0","0014M00001hPJZXQA4","0014M00001hXlqjQAC","0014M00001hvhP5QAI","0014M00001h4NGeQAM","0014M00001hNSLnQAO","0014M00001hKQXhQAO","0014M00001hYNtpQAG","0014M00001htxAKQAY","0014M00001hKPYYQA4","0014M00001hZ2cnQAC","0014M00001hgOrvQAE","0014M00001hdQ3cQAE","0014M00001mm9k1QAA","0014M00001h3POyQAM","0014M00001hr5JuQAI","0014M00001hrDbhQAE","0014M00001heeYSQAY","0014M00001hb6C2QAI","0014M00001hhahBQAQ","0014M00001hW7VfQAK","0014M00001hriSNQAY","0014M00001hRvteQAC","0014M00001hZxgNQAS","0014M00001hNPQAQA4","0014M00001hP7HCQA0","0014M00001hr77pQAA","0014M00001hZdFfQAK","0014M00001hOrkhQAC","0014M00001hJX4OQAW","0014M00001hbEbcQAE","0014M00001hdmH0QAI","0014M00001hmZTkQAM","0014M00001hTtIOQA0","0014M00001hTEkgQAG","0014M00001hOcrxQAC","0014M00001hJwOQQA0","0014M00001h3OyuQAE","0014M00001h5nFnQAI","0014M00001hKQZgQAO","0014M00001hZOTGQA4","0014M00001hUoujQAC","0014M00001hSvoPQAS","0014M00001hoiQeQAI","0014M00001hqyVdQAI","0014M00001m8PSOQA2","0014M00001hav1CQAQ","0014M00001hT2SGQA0","0014M00001hgKcgQAE","0014M00001hPYs5QAG","0014M00001hZ0yfQAC","0014M00001hdhunQAA","0014M00001hbJUlQAM","0014M00001hp1mHQAQ","0014M00001h3QYiQAM","0014M00001h6GpLQAU","0014M00001h65DRQAY","0014M00001hVB5eQAG","0014M00001hg8TuQAI","0014M00001hOjtFQAS","0014M00001hd5UnQAI","0014M00001hZEwmQAG","0014M00001hs2qMQAQ","0014M00001hP0zzQAC","0014M00001hcQUSQA2","0014M00001hQgRFQA0","0014M00001hndgpQAA","0014M00001hheI2QAI","0014M00001hkpv5QAA","0014M00001hcj25QAA","0014M00001hYgSQQA0","0014M00001hmhMhQAI","0014M00001h4EhEQAU","0014M00001hYJ92QAG","0014M00001hczbMQAQ","0014M00001hc9zOQAQ","0014M00001hZ5EGQA0","0014M00001hmcoyQAA","0014M00001hgmbQQAQ","0014M00001hT0UKQA0","0014M00001hm172QAA","0014M00001h6QovQAE","0014M00001hs3ygQAA","0014M00001h4Cp9QAE","0014M00001hXWaRQAW","0014M00001hrOc9QAE","0014M00001hd9V4QAI","0014M00001h5wFlQAI","0014M00001hZH76QAG","0014M00001hsjh1QAA","0014M00001hrsiWQAQ","0014M00001hiv1dQAA","0014M00001hnsQ8QAI","0014M00001hph2DQAQ","0014M00001hS4lvQAC","0014M00001ohednQAA","0014M00001hJpstQAC","0014M00001hiqA3QAI","0014M00001hmhNeQAI","0014M00001htia7QAA","0014M00001hlxiMQAQ","0014M00001hsDhLQAU","0014M00001hRbVpQAK","0014M00001ijD9TQAU","0014M00001hXbrpQAC","0014M00001hgxMTQAY","0014M00001hrHxUQAU","0014M00001hlhDeQAI","0014M00001h3oUjQAI","0014M00001hudkXQAQ","0014M00001hP4SSQA0","0014M00001hNsx2QAC","0014M00001hvggTQAQ","0014M00001hpJuKQAU","0014M00001hvX1NQAU","0014M00001hN7JqQAK","0014M00001h45wnQAA","0014M00001hrdDrQAI","0014M00001hNLGQQA4","0014M00001hnoF3QAI","0014M00001hP5Q6QAK","0014M00001hRHEuQAO","0014M00001heCW2QAM","0014M00001hJwXjQAK","0014M00001lUObCQAW","0014M00001hZRVQQA4","0014M00001hJamZQAS","0014M00001hY6egQAC","0014M00001hmC6SQAU","0014M00001h3P0YQAU","0014M00001hbpUfQAI","0014M00001hOs4kQAC","0014M00001hUcxPQAS","0014M00001hf2VTQAY","0014M00001hPJZgQAO","0014M00001jRs6hQAC","0014M00001hbkx1QAA","0014M00001hSs6pQAC","0014M00001hd4e2QAA","0014M00001hiLuuQAE","0014M00001hi64QQAQ","0014M00001hgDMIQA2","0014M00001lUOYDQA4","0014M00001hNEc8QAG","0014M00001h3V0FQAU","0014M00001hmfpOQAQ","0014M00001hjNH9QAM","0014M00001h4Lj8QAE","0014M00001h5q2OQAQ","0014M00001hgCJzQAM","0014M00001hZzDzQAK","0014M00001hv6x3QAA","0014M00001hTIfQQAW","0014M00001hav33QAA","0014M00001hn5cJQAQ","0014M00001hcZY3QAM","0014M00001hgsvQQAQ","0014M00001hP7ZxQAK","0014M00001h5q46QAA","0014M00001h5uNNQAY","0014M00001hg9yJQAQ","0014M00001hgDLWQA2","0014M00001hN9CRQA0","0014M00001hJZ5QQAW","0014M00001h5VGRQA2","0014M00001hg9z6QAA","0014M00001h3oUsQAI","0014M00001hfurvQAA","0014M00001hmbUXQAY","0014M00001hNNl5QAG","0014M00001rbgyOQAQ","0014M00001hrtJ3QAI","0014M00001h6JIvQAM","0014M00001hJxpEQAS","0014M00001hcfgvQAA","0014M00001hgVLOQA2","0014M00001hmmX3QAI","0014M00001hmsPIQAY","0014M00001hSGuNQAW","0014M00001hZc6WQAS","0014M00001hS7VHQA0","0014M00001hKBi3QAG","0014M00001hmehIQAQ","0014M00001heitUQAQ","0014M00001h4Zt4QAE","0014M00001ha7NvQAI","0014M00001hhMoMQAU","0014M00001hZeKCQA0","0014M00001hn4rRQAQ","0014M00001hbhrcQAA","0014M00001hMdhEQAS","0014M00001hbB6xQAE","0014M00001hcsaDQAQ","0014M00001hk0jmQAA","0014M00001hLNL6QAO","0014M00001hTgVxQAK","0014M00001hZ7ffQAC","0014M00001hfrbzQAA","0014M00001hsHZKQA2","0014M00001hetdCQAQ","0014M00001heVs9QAE","0014M00001hWaQWQA0","0014M00001haig5QAA","0014M00001hJlWzQAK","0014M00001hahqfQAA","0014M00001hMuxlQAC","0014M00001mtMEJQA2","0014M00001h3Ym1QAE","0014M00001hMt5KQAS","0014M00001hRgvBQAS","0014M00001hlz2SQAQ","0014M00001hRc5LQAS","0014M00001hWdnvQAC","0014M00001h4TWoQAM","0014M00001hc7VEQAY","0014M00001k3IUJQA2","0014M00001hWebeQAC","0014M00001hWc5SQAS","0014M00001mdMP6QAM","0014M00001hTUHNQA4","0014M00001hdfhzQAA","0014M00001hj4bqQAA","0014M00001hJcFUQA0","0014M00001lV261QAC","0014M00001hJpiHQAS","0014M00001hda7zQAA","0014M00001hv1NNQAY","0014M00001hTcG8QAK","0014M00001hXalHQAS","0014M00001hV4irQAC","0014M00001hbdRYQAY","0014M00001nkw7IQAQ","0014M00001kgCFoQAM","0014M00001hO8DHQA0","0014M00001xA1myQAC","0014M00001hO7PEQA0","0014M00001hWzOiQAK","0014M00001hm59kQAA","0014M00001hJecpQAC","0014M00001hhNONQA2","0014M00001ho1VOQAY","0014M00001hTSqSQAW","0014M00001h52GDQAY","0014M00001hRE19QAG","0014M00001huDUzQAM","0014M00001hTRwMQAW","0014M00001htct2QAA","0014M00001hmuh8QAA","0014M00001hTpTjQAK","0014M00001hOfutQAC","0014M00001hsLXCQA2","0014M00001hj0xCQAQ","0014M00001hkyGHQAY","0014M00001hTc29QAC","0014M00001hs1p1QAA","0014M00001hOyQQQA0","0014M00001hYXIyQAO","0014M00001hWkxpQAC","0014M00001hQA5iQAG","0014M00001h5VHYQA2","0014M000026rYF0QAM","0014M00001hhF4NQAU","0014M00001hYPPxQAO","0014M00001m2TjUQAU","0014M00001hYFbTQAW","0014M00001hOr6GQAS","0014M00001hOsTjQAK","0014M00001he3c9QAA","0014M00001hWq6hQAC","0014M00001hbALDQA2","0014M00001ho2b5QAA","0014M00001htcsRQAQ","0014M00001htbPXQAY","0014M00001n6bCwQAI","0014M00001htnkxQAA","0014M00001hXR4rQAG","0014M00001hcdoWQAQ","0014M00001hjSJbQAM","0014M00001hbbkqQAA","0014M00001hngBLQAY","0014M00001hnGUkQAM","0014M00001hcej6QAA","0014M00001hsLXVQA2","0014M00001hTvUMQA0","0014M00001qLANbQAO","0014M00001hOr7eQAC","0014M00001hnGsLQAU","0014M00001hpmpCQAQ","0014M00001hdfitQAA","0014M00001hdmroQAA","0014M00001hZ1WPQA0","0014M00001hqcEYQAY","0014M00001hMU2IQAW","0014M00001hLV47QAG","0014M00001hM6enQAC","0014M00001hSXV7QAO","0014M00001htHlrQAE","0014M00001hoLUyQAM","0014M00001hZ1VoQAK","0014M00001hMqKtQAK","0014M00001hrc1IQAQ","0014M00001hWedJQAS","0014M00001hRguzQAC","0014M00001hWeeFQAS","0014M00001hWaODQA0","0014M00001heRpiQAE","0014M00001hJfEEQA0","0014M00001hMqK1QAK","0014M00001hWZbdQAG","0014M00001h5WVQQA2","0014M00001hRgAbQAK","0014M00001hcVjOQAU","0014M00001hMqIvQAK","0014M00001hRPr5QAG","0014M00001hqzVRQAY","0014M0000267jNgQAI","0014M00001hgV2vQAE","0014M00001hqzXRQAY","0014M00001heTO6QAM","0014M00001hTIx6QAG","0014M00001hTcIXQA0","0014M00001hTRirQAG","0014M00001hObaeQAC","0014M00001hdsAbQAI","0014M00001hj3SvQAI","0014M00001hXRSsQAO","0014M00001hOcJnQAK","0014M00001hv3jbQAA","0014M00001hOlvXQAS","0014M00001hOk54QAC","0014M00001hj5LXQAY","0014M00001hh5ASQAY","0014M00001hpPKUQA2","0014M00001hdufAQAQ","0014M00001hTdsiQAC","0014M00001hj3TsQAI","0014M00001hv2MPQAY","0014M00001hdsC0QAI","0014M00001hl4GEQAY","0014M00001lV21QQAS","0014M00001hJfipQAC","0014M00001hdwOQQAY","0014M00001hTcI3QAK","0014M00001hpRJgQAM","0014M00001hTiDnQAK","0014M00001hJpiCQAS","0014M00001hXOcJQAW","0014M00001hj7LfQAI","0014M00001hr8RCQAY","0014M00001hLJp6QAG","0014M00001hZ5tFQAS","0014M00001hqUZ5QAM","0014M00001hZ7fPQAS","0014M00001hQA5JQAW","0014M00001hYZg1QAG","0014M00001hkX8DQAU","0014M00001heLEuQAM","0014M00001hlRMFQA2","0014M00001hlCZ1QAM","0014M00001hZ6mhQAC","0014M00001hlBmGQAU","0014M00001hle4mQAA","0014M00001hdbFZQAY","0014M00001hLKqEQAW","0014M00001hV8AaQAK","0014M00001hPQFoQAO","0014M00001hV4jVQAS","0014M00001hbYj5QAE","0014M00001h3qESQAY","0014M00001hOfzVQAS","0014M00001hn3EkQAI","0014M00001h6ETNQA2","0014M00001hqozGQAQ","0014M00001hbYiQQAU","0014M00001hqtUYQAY","0014M00001h3wnZQAQ","0014M00001jaHfjQAE","0014M00001hOg0JQAS","0014M00001hr3r7QAA","0014M00001hOfzzQAC","0014M00001h42pCQAQ","0014M00001hpJ6HQAU","0014M00001k4NffQAE","0014M00001hqoyMQAQ","0014M00001tRv4SQAS","0014M00001hO4v1QAC","0014M00001hTnVLQA0","0014M00001hkLQgQAM","0014M00001lvQ11QAE","0014M00001hi0qeQAA","0014M00001lv9FLQAY","0014M00001hKsOWQA0","0014M00001hbcPBQAY","0014M00001hbcOcQAI","0014M00001h3XKSQA2","0014M00001hdeLOQAY","0014M00001hg5KtQAI","0014M00001hsI4RQAU","0014M00001hYZnHQAW","0014M00001hvHA0QAM","0014M00001hlZJUQA2","0014M00001hWOk4QAG","0014M00001h5NqhQAE","0014M00001hPuwoQAC","0014M00001hVSdMQAW","0014M00001hY8UNQA0","0014M00001hL9dxQAC","0014M00001hYxVHQA0","0014M00001h5G9uQAE","0014M00001qxDAQQA2","0014M00001rbfWJQAY","0014M00001hZLF4QAO","0014M00001hdmrSQAQ","0014M00001hR77EQAS","0014M00001hLQO2QAO","0014M00001hlY9oQAE","0014M00001hqaQfQAI","0014M00001m2mCUQAY","0014M00001hp1d4QAA","0014M00001nU9dTQAS","0014M00001hu1vvQAA","0014M00001hTUnSQAW","0014M00001hm5g7QAA","0014M00001h3H0TQAU","0014M00001h5FFvQAM","0014M00001hcyreQAA","0014M00001hiyXvQAI","0014M00001hJdvlQAC","0014M00001hqNSfQAM","0014M00001h3E0GQAU","0014M00001hlRe3QAE","0014M00001hdbnoQAA","0014M00001hljroQAA","0014M00001hlvr2QAA","0014M00001hRAVlQAO","0014M00001hlyjJQAQ","0014M00001hRF4IQAW","0014M00001hcbOvQAI","0014M00001huIgUQAU","0014M00001hUIAwQAO","0014M00001hcvB2QAI","0014M00001hNoeDQAS","0014M00001m9A9sQAE","0014M00001hcabIQAQ","0014M00001hNK34QAG","0014M00001h5XQuQAM","0014M00001hK4AmQAK","0014M00001hp0vbQAA","0014M00001hOjEjQAK","0014M00001hUwEmQAK","0014M00001hlT8JQAU","0014M00001hK81wQAC","0014M00001hh2zmQAA","0014M00001hmtK2QAI","0014M00001hsZMTQA2","0014M00001hpFwFQAU","0014M00001hYfssQAC","0014M00001hmrG0QAI","0014M00001heXYjQAM","0014M00001hrynZQAQ","0014M00001hcAvWQAU","0014M00001hs0ZXQAY","0014M00001hRF2AQAW","0014M00001hrvbUQAQ","0014M00001hTkXkQAK","0014M00001hK81XQAS","0014M00001hK2TqQAK","0014M00001hh5ArQAI","0014M00001hrvcMQAQ","0014M00001hTmyHQAS","0014M00001hmyG8QAI","0014M00001hTgW0QAK","0014M00001h4nnmQAA","0014M00001hjE37QAE","0014M00001hKASdQAO","0014M00001m2gy1QAA","0014M00001hYY8bQAG","0014M00001hrxFhQAI","0014M00001hhda3QAA","0014M00001hctWlQAI","0014M00001mm4xZQAQ","0014M00001hs4AdQAI","0014M00001hWaPrQAK","0014M00001h4tV7QAI","0014M00001hv0QLQAY","0014M00001hLEdYQAW","0014M00001hcmWVQAY","0014M00001hhJv8QAE","0014M00001hQ7E1QAK","0014M00001hs39QQAQ","0014M00001hmriKQAQ","0014M00001h4c6TQAQ","0014M00001hm7yJQAQ","0014M00001hcptaQAA","0014M00001hlScQQAU","0014M00001hmtM0QAI","0014M00001hZaddQAC","0014M00001hYSo6QAG","0014M00001hpxzUQAQ","0014M00001hhOPxQAM","0014M00001hut9vQAA","0014M00001hmvu9QAA","0014M00001hs1OpQAI","0014M00001hpv8xQAA","0014M00001hZsdzQAC","0014M00001hOqKhQAK","0014M00001hcmUeQAI","0014M00001hjTLNQA2","0014M00001hJqZoQAK","0014M00001hjdm8QAA","0014M00001hYUT7QAO","0014M00001hmuFcQAI","0014M00001hUlB9QAK","0014M00001rbfBWQAY","0014M00001hq1BuQAI","0014M00001hu9MoQAI","0014M00001hhMKkQAM","0014M00001hUTHyQAO","0014M00001hZTd5QAG","0014M00001hgPSkQAM","0014M00001hPh65QAC","0014M00001hrzEeQAI","0014M00001hPvRoQAK","0014M00001hTrNxQAK","0014M00001hlkhbQAA","0014M00001h4caWQAQ","0014M00001hZoLSQA0","0014M00001hPJX4QAO","0014M00001hTizWQAS","0014M00001qnvEhQAI","0014M00001hlUY0QAM","0014M00001he79aQAA","0014M00001hPvRDQA0","0014M00001hul0FQAQ","0014M00001hTiCBQA0","0014M00001her7LQAQ","0014M00001hYbkqQAC","0014M00001hUUzBQAW","0014M00001hpukuQAA","0014M00001hkTgrQAE","0014M00001hPmy7QAC","0014M00001hYqUaQAK","0014M00001hVdviQAC","0014M00001iqNj4QAE","0014M00001hmrGdQAI","0014M00001hgCHyQAM","0014M00001hMhtnQAC","0014M00001ihhxrQAA","0014M00001hXFvxQAG","0014M00001hujmyQAA","0014M00001hejHFQAY","0014M00001hrvcdQAA","0014M00001hmrGxQAI","0014M00001hcl0cQAA","0014M00001hZjLFQA0","0014M00001hrw9CQAQ","0014M00001k2l3PQAQ","0014M00001hlq9KQAQ","0014M00001hPFLDQA4","0014M00001hcbW1QAI","0014M00001hMaXsQAK","0014M00001nVTPkQAO","0014M00001hq8ZMQAY","0014M00001hlBuFQAU","0014M00001hLwSJQA0","0014M00001hq7GeQAI","0014M00001hWHxVQAW","0014M00001hWQVbQAO","0014M00001s9vrgQAA","0014M00001hUsYVQA0","0014M00001htrQpQAI","0014M00001hYIamQAG","0014M00001hYKNNQA4","0014M00001hYBbXQAW","0014M00001hlJacQAE","0014M00001hlBYiQAM","0014M00001hUsVxQAK","0014M00001hjEsRQAU","0014M00001hjDMeQAM","0014M00001hYv2PQAS","0014M00001hq7Z2QAI","0014M00001hWmpbQAC","0014M00001hLwQLQA0","0014M00001hjEsEQAU","0014M00001hckVwQAI","0014M00001he8mEQAQ","0014M00001hlkoBQAQ","0014M00001htrOlQAI","0014M00001uHS40QAG","0014M00001hVl12QAC","0014M00001hUsWQQA0","0014M00001hjDKAQA2","0014M00001hqbfZQAQ","0014M00001hPxSdQAK","0014M00001hYJY3QAO","0014M00001hdJHOQA2","0014M00001hjDLVQA2","0014M00001hcbW4QAI","0014M00001hVJksQAG","0014M00001hPG6RQAW","0014M00001htqaTQAQ","0014M00001lyl41QAA","0014M00001hdJHeQAM","0014M00001hYCSZQA4","0014M00001hYCTjQAO","0014M00001hjE4IQAU","0014M00001hLwPMQA0","0014M00001hUsXtQAK","0014M00001huqMbQAI","0014M00001hPG5zQAG","0014M00001hrE8jQAE","0014M00001hYa3tQAC","0014M00001hdMQcQAM","0014M00001hjEsaQAE","0014M00001hcaY6QAI","0014M00001hPO8tQAG","0014M00001hlsPOQAY","0014M00001hYJZIQA4","0014M00001hjE48QAE","0014M00001hLwRdQAK","0014M00001hRHibQAG","0014M00001hjFZMQA2","0014M00001h5wsIQAQ","0014M00001hcbWWQAY","0014M00001hlB6uQAE","0014M00001hM3uIQAS","0014M00001htqbWQAQ","0014M00001hYCSpQAO","0014M00001hVhRKQA0","0014M00001hPOwfQAG","0014M00001hlAfLQAU","0014M00001htqZ7QAI","0014M00001hPNQ5QAO","0014M00001hUuRpQAK","0014M00001hPO90QAG","0014M00001hLxFsQAK","0014M00001hPFLEQA4","0014M00001hYBbsQAG","0014M00001htrR4QAI","0014M00001hq7YCQAY","0014M00001hPG6IQAW","0014M00001lSeE7QAK","0014M00001hccWEQAY","0014M00001hNh7cQAC","0014M00001hYJXeQAO","0014M00001hPOAqQAO","0014M00001hfcl5QAA","0014M00001hKEo1QAG","0014M00001hc2cTQAQ","0014M00001jSdSDQA0","0014M00001kanETQAY","0014M00001htXKJQA2","0014M00001hdNAcQAM","0014M00001klK3JQAU","0014M00001hKEmxQAG","0014M00001hUEKqQAO","0014M00001hUFxMQAW","0014M00001hqASiQAM","0014M00001hkAMdQAM","0014M00001hQaewQAC","0014M00001hbB0kQAE","0014M00001n6bILQAY","0014M00001hQicyQAC","0014M00001hNp7wQAC","0014M00001hNoB3QAK","0014M00001hq7oCQAQ","0014M00001hY1qlQAC","0014M00001hNoD0QAK","0014M00001hrH69QAE","0014M00001hY9poQAC","0014M00001hN6UzQAK","0014M00001hUMmdQAG","0014M00001jwiP5QAI","0014M00001hPgjrQAC","0014M00001kwVP0QAM","0014M00001hb2o2QAA","0014M00001hq5fKQAQ","0014M00001hjxG2QAI","0014M00001hlrtCQAQ","0014M00001hXzACQA0","0014M00001lyy57QAA","0014M00001jbD4CQAU","0014M00001hWyjHQAS","0014M00001hKqGZQA0","0014M00001hihL7QAI","0014M00001hKJqYQAW","0014M00001hc6CrQAI","0014M00001hY1qwQAC","0014M00001hY0DZQA0","0014M00001hKIoNQAW","0014M00001htYYZQA2","0014M00001htYZZQA2","0014M00001hL8y3QAC","0014M00001p2T17QAE","0014M00001hipvpQAA","0014M00001iqTWjQAM","0014M00001hkalmQAA","0014M00001hqAtpQAE","0014M00001hY6x7QAC","0014M00001hkCHdQAM","0014M00001hirjtQAA","0014M00001hUO6mQAG","0014M00001hlzuAQAQ","0014M00001hq7pJQAQ","0014M00001hkBGOQA2","0014M00001hNioPQAS","0014M00001h5uBxQAI","0014M00001hdGA4QAM","0014M00001h42dlQAA","0014M00001hnQ6fQAE","0014M00001h3lWyQAI","0014M00001hgeR2QAI","0014M00001htuPqQAI","0014M00001hhjPzQAI","0014M00001hhwj3QAA","0014M00001hoKgCQAU","0014M00001hRPLmQAO","0014M00001hhcfgQAA","0014M00001hMkk2QAC","0014M00001hhld1QAA","0014M00001h5RhHQAU","0014M00001hVamiQAC","0014M00001hiRHLQA2","0014M00001hp5OIQAY","0014M00001hOB6EQAW","0014M00001meEuDQAU","0014M00001lHdYcQAK","0014M00001hO4nXQAS","0014M00001huiauQAA","0014M00001hjFUIQA2","0014M00001hd6LDQAY","0014M00001hWmYUQA0","0014M00001heFQqQAM","0014M00001hPls7QAC","0014M00001hiqrTQAQ","0014M00001hf6o2QAA","0014M00001hendwQAA","0014M00001hRM0nQAG","0014M00001hXoQvQAK","0014M00001hcRwmQAE","0014M00001hXuLEQA0","0014M00001h3QEXQA2","0014M00001hree3QAA","0014M00001m2U0GQAU","0014M00001hbJzbQAE") ;; + } + dimension: segment { + alias: [account_meta.segment] + view_label: "Account" + description: "Account Segment from Vector" + sql: ${TABLE}.segment ;; + } + dimension: sector { + alias: [account_meta.sector] + } + dimension: sfdc_account_id { + alias: [account_meta.sfdc_account_id] + label: "SFDC Account ID" + view_label: "Account" + description: "Salesforce account of the opportunity" + type: string + sql: ${TABLE}.sfdc_account_id ;; + link: { + label: "Account in Vector" + url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view" + } + } + dimension: sub_region { + alias: [account_meta.sub_region] + } + dimension: sub_industry { + view_label: "Account" + group_label: "Industry" + description: "Examples: Education, Construction, Electronics" + alias: [account_meta.sub_industry] + sql: ${TABLE}.sub_industry ;; + drill_fields: [micro_industry] + } + ##### PARAMETERS ##### + parameter: region_granularity { + alias: [account_meta.region_granularity] + allowed_value: { + label: "Region" + value: "region" + } + allowed_value: { + label: "EMEA Geocluster" + value: "geocluster" + } + allowed_value: { + label: "NORTHAM Sector" + value: "sector" + } + allowed_value: { + label: "Sub Region" + value: "sub_region" + } + allowed_value: { + label: "Micro Region" + value: "micro_region" + } + allowed_value: { + label: "NAL Cluster" + value: "nal_cluster" + } + allowed_value: { + label: "NAL Name" + value: "nal_name" + } + allowed_value: { + label: "NAL ID" + value: "nal_id" + } + allowed_value: { + label: "Reporting Account Name" + value: "reporting_account_name" + } + allowed_value: { + label: "SFDC Account ID" + value: "sfdc_account_id" + } + } +}
diff --git a/views/revenue/revenue.view.lkml b/views/revenue/revenue.view.lkml index 9dfb42d..cba9b62 100644 --- a/views/revenue/revenue.view.lkml +++ b/views/revenue/revenue.view.lkml
@@ -1,80 +1,80 @@ # Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue.view.lkml +include: "account_from_account_revenue.view.lkml" +include: "revenue_from_revenue.view.lkml" -# bits from: -# https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/account_from_account_revenue.view.lkml view: revenue { - + extends: [account_from_revenue, revenue_from_revenue] sql_table_name: `concord-test.stagingservice_gcc.gcc_revenue_partitioned_view`;; - dimension: billing_account_id { - view_label: "Account" - group_label: "Identifiers" - description: "Billing account ID" - sql: ${TABLE}.billing_account_id ;; - } + # dimension: billing_account_id { + # view_label: "Account" + # group_label: "Identifiers" + # description: "Billing account ID" + # sql: ${TABLE}.billing_account_id ;; + # } - dimension: sfdc_account_id { - alias: [account_meta.sfdc_account_id] - label: "SFDC Account ID" - view_label: "Account" - description: "Salesforce account of the opportunity" - type: string - sql: ${TABLE}.sfdc_account_id ;; - link: { - label: "Account in Vector" - url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view" - } - } + # dimension: sfdc_account_id { + # alias: [account_meta.sfdc_account_id] + # label: "SFDC Account ID" + # view_label: "Account" + # description: "Salesforce account of the opportunity" + # type: string + # sql: ${TABLE}.sfdc_account_id ;; + # link: { + # label: "Account in Vector" + # url: "https://vector.lightning.force.com/lightning/r/Account/{{ value }}/view" + # } + # } - dimension: currency_code { - view_label: "Revenue" - description: "Three letter currency code (e.g. USD) for local billing amount." - sql: ${TABLE}.currency_code ;; - } + # dimension: currency_code { + # view_label: "Revenue" + # description: "Three letter currency code (e.g. USD) for local billing amount." + # sql: ${TABLE}.currency_code ;; + # } - dimension_group: invoice_month_start { - type: time - timeframes: [raw, date, week, month, quarter, year] - view_label: "Revenue" - sql: ${TABLE}.invoice_month_start ;; - datatype: date - convert_tz: no - } + # dimension_group: invoice_month_start { + # type: time + # timeframes: [raw, date, week, month, quarter, year] + # view_label: "Revenue" + # sql: ${TABLE}.invoice_month_start ;; + # datatype: date + # convert_tz: no + # } - dimension: product_family_l1 { - label: "Product Family (L1)" - group_label: "Finance Product Hierarchy" - view_label: "Product" - description: "Examples: Google Workspace, GCP, Maps, PSO" - sql: ${TABLE}.product_group ;; - drill_fields: [product_group_l2] - } - dimension: product_group_l2 { - label: "Product Group (L2)" - group_label: "Finance Product Hierarchy" - view_label: "Product" - description: "Examples: Marketplace Services, Compute, Support, Databases, etc." - sql: ${TABLE}.product_group_l2 ;; - drill_fields: [logical_product_l3] - } - dimension: logical_product_l3 { - label: "Logical Product (L3)" - group_label: "Finance Product Hierarchy" - view_label: "Product" - description: "Examples: Persistent Disk, VM Image Storage, GCE" - sql: ${TABLE}.logical_product_l3 ;; - } + # dimension: product_family_l1 { + # label: "Product Family (L1)" + # group_label: "Finance Product Hierarchy" + # view_label: "Product" + # description: "Examples: Google Workspace, GCP, Maps, PSO" + # sql: ${TABLE}.product_group ;; + # drill_fields: [product_group_l2] + # } + # dimension: product_group_l2 { + # label: "Product Group (L2)" + # group_label: "Finance Product Hierarchy" + # view_label: "Product" + # description: "Examples: Marketplace Services, Compute, Support, Databases, etc." + # sql: ${TABLE}.product_group_l2 ;; + # drill_fields: [logical_product_l3] + # } + # dimension: logical_product_l3 { + # label: "Logical Product (L3)" + # group_label: "Finance Product Hierarchy" + # view_label: "Product" + # description: "Examples: Persistent Disk, VM Image Storage, GCE" + # sql: ${TABLE}.logical_product_l3 ;; + # } - dimension: usd_revenue_gross { - # hidden: yes - view_label: "Revenue" - description: "Monetised value for resource consumption, before application of any credits, reported in USD($) using a monthly Ceilometer exchange rate. (Generally a positive number)" - sql: ${TABLE}.usd_revenue_gross ;; - } - dimension: usd_revenue_gross_cn { - hidden: yes - view_label: "Revenue" - sql: ${TABLE}.usd_revenue_gross_cn ;; - } + # dimension: usd_revenue_gross { + # # hidden: yes + # view_label: "Revenue" + # description: "Monetised value for resource consumption, before application of any credits, reported in USD($) using a monthly Ceilometer exchange rate. (Generally a positive number)" + # sql: ${TABLE}.usd_revenue_gross ;; + # } + # dimension: usd_revenue_gross_cn { + # hidden: yes + # view_label: "Revenue" + # sql: ${TABLE}.usd_revenue_gross_cn ;; + # } }
diff --git a/views/revenue/revenue_from_revenue.view.lkml b/views/revenue/revenue_from_revenue.view.lkml new file mode 100644 index 0000000..21e4606 --- /dev/null +++ b/views/revenue/revenue_from_revenue.view.lkml
@@ -0,0 +1,908 @@ +# 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." + type: date + sql: CASE + WHEN {% parameter usage_timeframe_selector %} = 'Date' THEN SAFE_CAST(${usage_date} AS STRING) + WHEN {% parameter usage_timeframe_selector %} = 'Week' THEN ${usage_week} + WHEN {% parameter usage_timeframe_selector %} = 'Month' THEN CONCAT(${usage_month},"-01") + END ;; + } + dimension: gcp_revenue_source { + view_label: "Revenue" + label: "GCP Revenue Source" + description: "Used by the Northam team to filter revenue. Values can be Organic GCP (all products except for Marketplace Services), MP Standard (Marketplace Services that aren't pre-paid), or MP Prepay (Marketplace Services that are prepaid)." + case: { + when: { + sql: ${product_group} != "Non-Cloud" ;; + label: "Organic GCP" + } + when: { + sql: ${product_group} = "Non-Cloud" AND NOT ${is_nonmetered} ;; + label: "MP Standard" + } + when: { + sql: ${product_group} = "Non-Cloud" AND ${is_nonmetered} ;; + label: "MP Prepaid" + } + else: "Other Revenue" + } + } + dimension_group: invoice_month_start { + type: time + timeframes: [raw, date, week, month, quarter, year] + view_label: "Revenue" + sql: ${TABLE}.invoice_month_start ;; + datatype: date + convert_tz: no + } + + dimension: is_data_analytics { + type: yesno + label: "Is Data Analytics?" + view_label: "Product" + sql: ${revenue.product_group_l2} = 'Analytics' + OR ${revenue.is_dataproc} + OR ${revenue.logical_product_l3} IN ('AI Platform', 'Confluent', 'Confluent Dev', + 'Confluent Staging', 'Databricks', 'Elastic', 'Elastic - Dev', 'Fivetran', + 'Informatica', 'MongoDB Inc.', 'Palantir') ;; + description: "Returns yes if this is Data & Analytics (DA) usage" + } + dimension: is_dataproc { + type: yesno + label: "Is Dataproc Node?" + view_label: "Product" + 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?" + view_label: "Product" + 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" + view_label: "Product" + description: "Examples: Google Workspace, GCP, Maps, PSO" + sql: ${TABLE}.product_group ;; + drill_fields: [product_group_l2] + } + dimension: product_group_l2 { + label: "Product Group (L2)" + group_label: "Finance Product Hierarchy" + view_label: "Product" + description: "Examples: Marketplace Services, Compute, Support, Databases, etc." + sql: ${TABLE}.product_group_l2 ;; + drill_fields: [logical_product_l3] + } + dimension: logical_product_l3 { + label: "Logical Product (L3)" + group_label: "Finance Product Hierarchy" + view_label: "Product" + 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: product_group { + group_label: "Legacy Product Hierarchy" + view_label: "Product" + description: "Groupings of Product Line into broader categories like \"Compute\" or \"Data Analytics\"" + sql: ${TABLE}.product_group ;; + drill_fields: [product_line] + } + dimension: product_line { + group_label: "Legacy Product Hierarchy" + view_label: "Product" + description: "Product Line, but with is_gke_node = True reassigned to Kubernetes Engine and is_dataproc = True reassigned to Dataproc" + sql: IF(${product_line_raw} = "Compute Engine", + CASE + WHEN ${is_gke_node} THEN "Kubernetes Engine" + WHEN ${is_dataproc} THEN "Dataproc" + ELSE "Compute Engine" + END, + ${product_line_raw});; + drill_fields: [sku_description, ] + } + dimension: product_line_raw { + hidden: yes + group_label: "Legacy Product Hierarchy" + view_label: "Product" + sql: ${TABLE}.product_line;; + #drill_fields: [sku_description] + } + + # dimension: product_line_raw { + # hidden: yes + # group_label: "Legacy Product Hierarchy" + # view_label: "Product" + # sql: {% if project_number._in_query %} ${TABLE}.product_name + # {% elsif project_name._in_query %} ${TABLE}.product_name + # {% elsif project_id._in_query %} ${TABLE}.product_name + # {% elsif sku_id._in_query %} ${TABLE}.product_name + # {% elsif sku_description._in_query %} ${TABLE}.product_name + # {% elsif machine_type._in_query %} ${TABLE}.product_name + # {% elsif resource_group._in_query %} ${TABLE}.product_name + # {% elsif storage_locality._in_query %} ${TABLE}.product_name + # {% elsif storage_class._in_query %} ${TABLE}.product_name + # {% elsif usage_location._in_query %} ${TABLE}.product_name + # {% elsif usage_unit._in_query %} ${TABLE}.product_name + # {% elsif usage_in_usage_units._in_query %} ${TABLE}.product_name + # {% else %} ${TABLE}.product_line {% endif %} ;; + # drill_fields: [sku_description] + # } + # dimension: product_specialization { + # view_label: "Product" + # sql: {% if project_number._in_query %} ${TABLE}.specialization + # {% elsif project_name._in_query %} ${TABLE}.specialization + # {% elsif project_id._in_query %} ${TABLE}.specialization + # {% elsif sku_id._in_query %} ${TABLE}.specialization + # {% elsif sku_description._in_query %} ${TABLE}.specialization + # {% elsif machine_type._in_query %} ${TABLE}.specialization + # {% elsif resource_group._in_query %} ${TABLE}.specialization + # {% elsif storage_locality._in_query %} ${TABLE}.specialization + # {% elsif storage_class._in_query %} ${TABLE}.specialization + # {% elsif usage_location._in_query %} ${TABLE}.specialization + # {% elsif usage_unit._in_query %} ${TABLE}.specialization + # {% elsif usage_in_usage_units._in_query %} ${TABLE}.specialization + # {% else %} ${TABLE}.product_specialization {% endif %} ;; + # drill_fields: [sku_description] + # } + dimension: service_family { + view_label: "Product" + description: "Service family, i.e. CLOUD or GEO" + type: string + sql: ${TABLE}.service_family ;; + } + # dimension: storage_class { + # view_label: "Product" + # group_label: "Cloud Storage" + # description: "Groups Cloud Storage into Archive, Coldline, Nearline, and Standard based on sku description." + # case: { + # when: { + # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Archive%' ;; + # label: "Archive" + # } + # when: { + # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Coldline%' ;; + # label: "Coldline" + # } + # when: { + # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Nearline%' ;; + # label: "Nearline" + # } + # when: { + # sql: ${product_line_raw} = "Cloud Storage" ;; + # label: "Standard" + # } + # } + # } + # dimension: storage_locality { + # view_label: "Product" + # group_label: "Cloud Storage" + # description: "Groups Cloud Storage into Multi-Region, Dual-Region, or Regional based on sku description." + # case: { + # when: { + # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Multi%' ;; + # label: "Multi-Region" + # } + # when: { + # sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Dual%' ;; + # label: "Dual-Region" + # } + # when: { + # sql: ${product_line_raw} = "Cloud Storage" ;; + # label: "Regional" + # } + # } + # } + dimension_group: usage { + type: time + timeframes: [raw, day_of_month, day_of_year, day_of_week, date, week, month, month_name, quarter, quarter_of_year, year] + view_label: "Revenue" + description: "Date on which usage was recorded" + sql: ${TABLE}.partition_date ;; + datatype: date + convert_tz: no + } + dimension: usd_revenue_blended { + hidden: yes + view_label: "Revenue" + sql: {% if filter_nonmetered._parameter_value == "true" %} + IF(NOT ${is_nonmetered}, ${TABLE}.usd_revenue_blended, 0) + {% else %} + ${TABLE}.usd_revenue_blended + {% endif %} + ;; + } + dimension: usd_revenue_bmod { + hidden: yes + view_label: "Revenue" + sql: ${TABLE}.usd_revenue_bmod ;; + } + dimension: usd_revenue_cross_pa_credits { + hidden: yes + description: "Added to usd_revenue_net_cn to create GCP Actuals" + sql: ${TABLE}.usd_revenue_cross_pa_credits ;; + } + dimension: usd_revenue_cud { + hidden: yes + view_label: "Revenue" + description: "Committed Usage Discount credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate." + sql: ${TABLE}.usd_revenue_cud ;; + } + dimension: usd_revenue_ft { + hidden: yes + view_label: "Revenue" + description: "Free Trial credit applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate." + sql: ${TABLE}.usd_revenue_ft ;; + } + dimension: usd_revenue_gross { + hidden: yes + view_label: "Revenue" + description: "Monetised value for resource consumption, before application of any credits, reported in USD($) using a monthly Ceilometer exchange rate. (Generally a positive number)" + sql: ${TABLE}.usd_revenue_gross ;; + } + dimension: usd_revenue_gross_cn { + hidden: yes + view_label: "Revenue" + sql: ${TABLE}.usd_revenue_gross_cn ;; + } + dimension: usd_revenue_list { + hidden: yes + view_label: "Revenue" + sql: ${TABLE}.usd_revenue_list ;; + } + dimension: usd_revenue_net { + hidden: yes + view_label: "Revenue" + description: "Final billed amounts after application of all other credits, reported in USD($) using an annual exchange rate. (Net amounts are normally positive or round to zero, but it some cases credits can exceed gross and net will be negative)" + sql: ${TABLE}.usd_revenue_net ;; + } + dimension: usd_revenue_ntg { + hidden: yes + view_label: "Revenue" + description: "Net to Google Revenue" + sql: ${TABLE}.usd_revenue_ntg ;; + } + dimension: usd_revenue_net_cn { + hidden: yes + view_label: "Revenue" + sql: {% if filter_nonmetered._parameter_value == "true" %} + IF(NOT ${is_nonmetered}, ${TABLE}.usd_revenue_net_cn, 0) + {% else %} + ${TABLE}.usd_revenue_net_cn + {% endif %} + ;; + } + dimension: usd_revenue_promo { + hidden: yes + view_label: "Revenue" + description: "Other promotional credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate." + sql: ${TABLE}.usd_revenue_promo ;; + } + dimension: usd_revenue_protected_credit { + hidden: yes + view_label: "Revenue" + sql: ${TABLE}.usd_revenue_protected_credit ;; + } + dimension: usd_revenue_reseller { + hidden: yes + view_label: "Revenue" + sql: ${TABLE}.usd_revenue_reseller ;; + } + dimension: usd_revenue_rvp { + hidden: yes + view_label: "Revenue" + description: "Revenue for RVPs: see go/revenue-walk for details" + sql: ${TABLE}.usd_revenue_rvp ;; + } + dimension: usd_revenue_sud { + hidden: yes + view_label: "Revenue" + description: " Usage Discount credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate." + sql: ${TABLE}.usd_revenue_sud ;; + } + dimension: is_nonmetered { + type: yesno + label: "Is Nonmetered?" + view_label: "Product" + sql: ${TABLE}.is_nonmetered ;; + } + #### MEASURES #### + measure: revenue_invoice { + alias: [revenue_actuals] + label: "Revenue (Invoice)" + view_label: "Revenue" + description: "Sum of Revenue (Sales) minus hug credits. Post alignment we have agreed to keep only one source of truth for revenue and it will be gcc.revenue. Gcp_consumpiton will be deprecated but another table(with adjustments) will be established to enable the bridge from gcc.revenue to finance." + type: sum + sql: ${usd_revenue_net} - ${usd_revenue_cross_pa_credits};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_actuals, revenue_net_cn] + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10" + label: "Top 10 Product Lines" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 Accounts" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Segment" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Account Category" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Region" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc + " + label: "Drill by NAL" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}" + label: "Drill by Product Group" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_bmod { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Billing Modifications)" + view_label: "Revenue" + description: "The subset of revenue that is due to a billing modification. Billing Modifications (BMods) are requested when an adjustment affecting the regular invoicing process needs to be made." + type: sum + sql: ${usd_revenue_bmod};; + value_format_name: usd_0 + drill_fields: [billing_account_id, usd_revenue_bmod, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_cross_pa_credits { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (xPA Credits)" + view_label: "Revenue" + description: "Cross PA Credits." + type: sum + sql: ${usd_revenue_cross_pa_credits};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_cross_pa_credits, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_cud { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Committed Usage Discount)" + view_label: "Revenue" + description: "Committed Usage Discount credits applied against the Gross amount." + type: sum + sql: ${usd_revenue_cud};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_cud, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_discounts_other { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Other Discounts)" + view_label: "Revenue" + description: "Differences between Gross and Revenue (Sales) not due to BMods, CUD, SUD, Free Trial, or Promo, Cross PA Credits." + type: sum + sql: -1 * (${usd_revenue_gross} - ${usd_revenue_blended} + ${usd_revenue_cud} + ${usd_revenue_ft} + ${usd_revenue_promo} + ${usd_revenue_sud} +${usd_revenue_reseller}) ;; + value_format_name: usd_0 + drill_fields: [billing_account_id + , revenue_discounts_other + , revenue_gross + , revenue_net_cn + ] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_ft { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Free Trial)" + view_label: "Revenue" + description: "Free Trial credit applied against the Gross amount." + type: sum + sql: ${usd_revenue_ft};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_ft, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_gross { + label: "Revenue (Gross)" + view_label: "Revenue" + description: "Monetised values for resource consumption, before application of credits (adjustments). Gross values are generally positive." + type: sum + sql: ${usd_revenue_gross};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10" + label: "Top 10 Product Lines" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 Accounts" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Segment" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Account Category" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Region" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc + " + label: "Drill by NAL" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}" + label: "Drill by Product Group" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + } + measure: revenue_list { + label: "[go/listrev] Revenue (List)" + view_label: "Revenue" + description: "Learn more at go/listrev. Amount of monetized usage calculared based on the list price of each SKU (with no discounts applied)." + type: sum + sql: ${usd_revenue_list} ;; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_list, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + link: { + url: "http://go/listrev" + label: "Learn more about List Revenue Metric" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10" + label: "Top 10 Product Lines" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 Accounts" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Segment" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Account Category" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Region" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc + " + label: "Drill by NAL" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}" + label: "Drill by Product Group" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + } + measure: revenue_net_cn { + label: "Revenue (Sales)" + view_label: "Revenue" + description: "Channel-neutral revenue (usd_revenue_net_cn) for accounts which are SMB, Corp, or GPS. Net-to-google revenue for commercial Select/Enterprise accounts." + type: sum + sql: ${usd_revenue_blended};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_net_cn] + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10" + label: "Top 10 Product Lines" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 Accounts" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.product_group,revenue.sku_id,revenue.sku_description\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 SKUs" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Segment" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Account Category" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Region" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc + " + label: "Drill by NAL" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}" + label: "Drill by Product Group" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_promo { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Promo)" + view_label: "Revenue" + description: "Other promotional credits applied against the Gross amount" + type: sum + sql: ${usd_revenue_promo};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_promo, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_reseller { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Reseller)" + view_label: "Revenue" + description: "Reseller Discount credits applied against the Gross amount." + type: sum + sql: ${usd_revenue_reseller};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_reseller, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_rvp { + label: "Revenue (RVP)" + view_label: "Revenue" + description: "Revenue definition used by Region VPs. See go/revenue-walk" + type: sum + sql: ${usd_revenue_rvp};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_net_cn] + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10" + label: "Top 10 Product Lines" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 Accounts" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.product_group,revenue.sku_id,revenue.sku_description\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 SKUs" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Segment" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Account Category" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Region" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc + " + label: "Drill by NAL" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}" + label: "Drill by Product Group" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_sud { + group_label: "Discounts, Credits & BMODS" + label: "Revenue (Sustained Usage Discount)" + view_label: "Revenue" + description: "Sustained Usage Discount credits applied against the Gross amount." + type: sum + sql: ${usd_revenue_sud};; + value_format_name: usd_0 + drill_fields: [billing_account_id, revenue_sud, revenue_gross, revenue_net_cn] + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + measure: revenue_toggle { + group_label: "Other Revenue" + label: "Revenue (Toggle-able)" + label_from_parameter: metric_selector + view_label: "Revenue" + description: "This parameter is for dashboard building only! This allows users to select a metric type + from a dashboard filter. For example, the dashboard might default to using Gross Revenue, but the user + can use this parameter to change to using 2021 Def. Sales Revenue instead. Must be used with the + Metric Selector parameter to select what this metric will display" + type: sum + sql: {% if metric_selector._parameter_value == 'invoice' %} ${usd_revenue_net} + {% elsif metric_selector._parameter_value == 'ntg' %} ${usd_revenue_ntg} + {% elsif metric_selector._parameter_value == 'net_channel_neutral' %} ${usd_revenue_net_cn} + {% elsif metric_selector._parameter_value == 'gross' %} ${usd_revenue_gross} + {% elsif metric_selector._parameter_value == 'blended' %} ${usd_revenue_blended} + {% elsif metric_selector._parameter_value == 'rvp' %} ${usd_revenue_rvp} + {% endif %} ;; + drill_fields: [billing_account_id, revenue_toggle] + value_format_name: usd_0 + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10" + label: "Top 10 Product Lines" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Top 10 Accounts" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Segment" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Account Category" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc + " + label: "Drill by Region" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: " + {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %} + {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc + " + label: "Drill by NAL" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + link: { + url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}" + label: "Drill by Product Group" + icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png" + } + # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926 + # html: @{custom_dollar_formatting} ;; + } + #### PARAMETERS #### + parameter: metric_selector { + view_label: "Revenue" + description: "This parameter is for dashboard building only. This allows users to select a metric type + from a dashboard filter. For example, the dashboard might default to using Gross Revenue, but the user + can use this parameter to change to using 2021 Def. Sales Revenue instead. Must be used with the + Toggleable Revenue Metric, and not the normal metrics." + default_value: "blended" + type: unquoted + allowed_value: { + label: "Revenue (Sales)" + value: "blended" + } + allowed_value: { + label: "Revenue (RVP)" + value: "rvp" + } + allowed_value: { + label: "Revenue (2021 Def.)" + value: "net_channel_neutral" + } + allowed_value: { + label: "Revenue (Invoice)" + value: "invoice" + } + allowed_value: { + label: "Revenue (Gross)" + value: "gross" + } + allowed_value: { + label: "Revenue (Net-to-Google)" + value: "ntg" + } + } + parameter: filter_nonmetered { + view_label: "Revenue" + label: "Remove Prepaid Purchases?" + description: "Filters out Marketplace Prepaid Purchases, which can erroneously inflate forecasts. Default is to filter these out." + default_value: "false" + type: unquoted + allowed_value: { + label: "Remove" + value: "true" + } + allowed_value: { + label: "Include" + value: "false" + } + } + parameter: usage_timeframe_selector { + view_label: "Revenue" + description: "Updates the `Dynamic Usage Timeframe` field based on selection of granularity." + type: string + default_value: "Date" + allowed_value: { + value: "Date" + } + allowed_value: { + value: "Week" + } + allowed_value: { + value: "Month" + } + } +}