| view: region { |
| extension: required |
| #### DIMENSIONS #### |
| dimension: geocluster { |
| view_label: "Account" |
| group_label: "Region" |
| label: "EMEA Geocluster" |
| description: "EMEA grouping between Region and Sub-Region that includes: North, South, UK/IE, and Industry" |
| type: string |
| sql: IF(${region} = "EMEA", |
| CASE |
| WHEN ${sub_region} IN ('Germany', 'CEE', 'Alps', 'Nordics') |
| THEN "North" |
| WHEN ${sub_region} IN ('ISRAEL', 'Italy', 'France', 'MEA', 'Benelux', 'Iberia') |
| THEN "South" |
| WHEN ${sub_region} LIKE "UK/IE%" |
| THEN "UK/IE" |
| WHEN ${sub_region} IN ('Telco Dir', 'Retail & CPG', 'Banking Dir', 'Life Sciences Dir') |
| THEN "Industry" |
| WHEN ${sub_region} IN ('EMEA - PS') |
| THEN 'Public Sector' |
| END |
| , NULL);; |
| drill_fields: [sub_region, micro_region, nal_cluster, nal_name, nal_id] |
| suggestions: ["North", "South", "UK/IE", "Industry", "Public Sector"] |
| } |
| dimension: micro_region { |
| view_label: "Account" |
| group_label: "Region" |
| description: "e.g. Bay Area, NewEngland, Emerging, Benelux, Italy" |
| sql: ${TABLE}.micro_region ;; |
| drill_fields: [nal_cluster, nal_name, nal_id] |
| suggest_explore: vector_customers_suggestions |
| suggest_dimension: vector_customers_suggestions.micro_region |
| } |
| dimension: nal_cluster { |
| view_label: "Account" |
| group_label: "Region" |
| label: "NAL Cluster" |
| description: "First level rollup for a group of NALs (e.g. NA Corp Digit.)" |
| sql: ${TABLE}.nal_cluster ;; |
| drill_fields: [nal_name, nal_id] |
| suggest_explore: vector_customers_suggestions |
| suggest_dimension: vector_customers_suggestions.nal_cluster |
| } |
| dimension: nal_id { |
| view_label: "Account" |
| label: "NAL ID" |
| group_label: "Region" |
| description: "Int64 unique identifier for a NAL" |
| type: number |
| sql: ${TABLE}.nal_id ;; |
| drill_fields: [reporting_account_name] |
| suggest_explore: vector_customers_suggestions |
| suggest_dimension: vector_customers_suggestions.nal_id |
| } |
| dimension: nal_name { |
| view_label: "Account" |
| label: "NAL Name" |
| group_label: "Region" |
| description: "Nal name (e.g. DACH PS ENT Gov (ricardonunez))" |
| sql: ${TABLE}.nal_name ;; |
| drill_fields: [reporting_account_name] |
| suggest_explore: vector_customers_suggestions |
| suggest_dimension: vector_customers_suggestions.nal_name |
| } |
| dimension: region { |
| view_label: "Account" |
| group_label: "Region" |
| description: "Sales region (e.g. NORTHAM, EMEA, JAPAN, APAC, LATAM)" |
| sql: ${TABLE}.region ;; |
| drill_fields: [geocluster, sector, sub_region, micro_region, nal_cluster, nal_name, nal_id] |
| order_by_field: region_order |
| suggest_explore: vector_customers_suggestions |
| suggest_dimension: vector_customers_suggestions.region |
| } |
| dimension: region_order { |
| hidden: yes |
| type: number |
| view_label: "Account" |
| description: "Account Segment from Vector" |
| sql: CASE |
| WHEN ${region} = "NORTHAM" THEN 1 |
| WHEN ${region} = "EMEA" THEN 2 |
| WHEN ${region} = "LATAM" THEN 3 |
| WHEN ${region} = "APAC" THEN 4 |
| WHEN ${region} = "JAPAN" THEN 5 |
| WHEN ${region} = "PUBLIC SECTOR" THEN 6 |
| WHEN ${region} = "EDU FA" THEN 7 |
| WHEN ${region} = "SCALED" THEN 8 |
| ELSE 9 |
| END |
| ;; |
| } |
| dimension: region_toggle { |
| view_label: "Account" |
| group_label: "Region" |
| label: "Region (Toggle-able)" |
| description: "USE ONLY FOR DASHBOARDING. This is a region dimension that can be toggled with a dashboard filter using the Region Granularity parameter. Choose from Region, Sub-Region, Micro-Region, NAL Cluster, NAL ID, or Reporting Account Name. Default is NAL Name." |
| label_from_parameter: region_granularity |
| 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} |
| {% endif %} |
| ;; |
| drill_fields: [region, geocluster, sector, sub_region, micro_region, nal_cluster, nal_name, nal_id, commit_curve.leg] |
| } |
| dimension: sector { |
| view_label: "Account" |
| group_label: "Region" |
| label: "NORTHAM Sector" |
| description: "NORTHAM grouping between Region and Sub-Region that includes: GEO and VERTICAL" |
| type: string |
| sql: IF(${region} = "NORTHAM", |
| CASE |
| WHEN ${sub_region} IN ("Corp", "Central", "US West", "US SouthCentral", "US NorthCentral", "US East", "Canada") |
| THEN "GEO" |
| WHEN ${sub_region} IN ("US TMEG", "US Retail", "US HCLS", "US FS") |
| THEN "VERTICAL" |
| WHEN ${nal_name} LIKE "AMER Geo%" |
| THEN "GEO" |
| WHEN ${nal_name} LIKE "AMER Vertical%" |
| THEN "VERTICAL" |
| END |
| , NULL) ;; |
| drill_fields: [sub_region, micro_region, nal_cluster, nal_name, nal_id] |
| suggestions: ["GEO", "VERTICAL"] |
| } |
| dimension: sub_region { |
| view_label: "Account" |
| group_label: "Region" |
| description: "Sales sub-region (e.g. US West, North Asia, UK/IE)" |
| sql: ${TABLE}.sub_region ;; |
| drill_fields: [micro_region, nal_cluster, nal_name, nal_id] |
| suggest_explore: vector_customers_suggestions |
| suggest_dimension: vector_customers_suggestions.sub_region |
| } |
| ##### PARAMETERS ##### |
| parameter: region_granularity { |
| type: unquoted |
| view_label: "Account" |
| description: "A parameter that should be used with the region_toggle dimension to change the granularity at which region is shown. Choose from Region, EMEA Geocluster, NORTHAM Sector, Sub-Region, Micro-Region, NAL Cluster, NAL ID." |
| default_value: "nal_name" |
| 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" |
| } |
| } |
| } |
