drstrangelooker
commented
1 year ago The newly imported dashboard is 1126, not 2279.
11:48:09 Imported dashboard 1126
It was 2279 on the original system, but gets a new id on the new system.
Closed SivanarayanaReddyTamalampudi closed 1 year ago
drstrangelooker
commented
1 year ago The newly imported dashboard is 1126, not 2279.
11:48:09 Imported dashboard 1126
It was 2279 on the original system, but gets a new id on the new system.
SivanarayanaReddyTamalampudi
commented
1 year ago script used in build: echo "DEBUGL: Passed parameters are $dashboard_file_name $source_deployed_space_id $source_client_id $source_client_secret $source_host $target_space_id $target_client_id $target_client_secret $target_host"
echo "DEBUGL: gzr dashboard import $dashboard_file_name ${target_space_id} --host=${target_host} --port=443 --client-id=${target_client_id} --client-secret=${target_client_secret} --debug --force" gzr dashboard import "$dashboard_file_name" ${target_space_id} --host="${target_host}" --port="443" --client-id="${target_client_id}" --client-secret="${target_client_secret}" --debug --force
source_dashboard_id=$( jq -c '.id' "$dashboard_file_name" ) echo "DEBUGL: gzr dashboard mv $source_dashboard_id $source_deployed_space_id --host=${source_host} --port=443 --client-id=${source_client_id} --client-secret=${source_client_secret} --debug --force" gzr dashboard mv $source_dashboard_id $source_deployed_space_id --host="${source_host}" --port="443" --client-id="${source_client_id}" --client-secret="${source_client_secret}" --debug --force echo "END OF THE MIGRATE DASHBOARD SCRIPT"
drstrangelooker
commented
1 year ago If you don't use --debug and you use the switch --plain the import will only output the new object's id. So you could do
source_dashboard_id=$( gzr dashboard import "$dashboard_file_name" ${target_space_id} --host="${target_host}" --port="443" --client-id="${target_client_id}" --client-secret="${target_client_secret}" --plain --force)to get the id of the new object.
SivanarayanaReddyTamalampudi
commented
1 year ago when i replace with above script i am getting below error: 13:36:43 Updating layout 1126 13:36:43 key_list update_dashboard_layout_component -> [:dashboard_layout_id, :dashboard_element_id, :row, :column, :width, :height] 13:36:43 Updating dashboard layout component 60183 13:36:43 Updating dashboard layout component 60184 13:36:43 Updating dashboard layout component 60185 13:36:43 Imported dashboard 1126 13:36:43 logout 13:36:47 DEBUGL: gzr dashboard mv Modifying existing dashboard 1126 Button test in folder 1244 13:36:47 1126 1329 --host=xpologisticsdev.cloud.looker.com --port=443 --client-id=3dfCdCXBP9zrxdzn4Q2w --client-secret=*** --debug --force 13:36:48 ERROR: "gzr dashboard mv" was called with arguments ["Modifying", "existing", "dashboard", "1126", "Button", "test", "in", "folder", "1244", "1126", "1329"] 13:36:48 END OF THE MIGRATE DASHBOARD SCRIPT 13:36:48 Usage: "gzr dashboard mv DASHBOARD_ID TARGET_FOLDER_ID" 13:36:48 Process exited with code 0
SivanarayanaReddyTamalampudi
commented
1 year ago 13:36:40 using options ["debug=>true", "host=>xxxxxstaging.cloud.looker.com", "port=>443", "ssl=>true", "verify_ssl=>true", "timeout=>60", "force=>true", "persistent=>false", "client_id=>gfMfp8zZkCfP2HS5zQ7B"]
13:36:40 API current_version 4.0
13:36:40 Supported API versions ["3.0", "3.1", "4.0"]
13:36:40 connecting to ["api_endpoint=>https://xxxxxstaging.cloud.looker.com:443/api/4.0", "connection_options=>{:ssl=>{:verify=>true, :verify_mode=>3}, :request=>{:timeout=>60}}", "user_agent=>Gazer 0.3.2", "client_id=>gfMfp8zZkCfP2HS5zQ7B", "client_secret=>***"]
13:36:40 check for connectivity: true
13:36:40 verify authentication: true
13:36:42 existing_dashboard object {:content_metadata_id=>"4215", :description=>"", :hidden=>false, :query_timezone=>nil, :readonly=>false, :refresh_interval=>nil, :refresh_interval_to_i=>nil, :title=>"Button test", :user_id=>"221", :slug=>"7VUxMyB4s4ay5mFc97fOdK", :preferred_viewer=>"dashboards-next", :alert_sync_with_dashboard_filter_enabled=>false, :background_color=>nil, :created_at=>2023-05-03 17:39:47 +0000, :crossfilter_enabled=>false, :dashboard_elements=>[{:body_text=>nil, :body_text_as_html=>nil, :dashboard_id=>"1126", :edit_uri=>nil, :id=>"60180", :look=>nil, :look_id=>nil, :lookml_link_id=>"", :merge_result_id=>nil, :note_display=>nil, :note_state=>nil, :note_text=>nil, :note_text_as_html=>nil, :query=>nil, :query_id=>nil, :refresh_interval=>nil, :refresh_interval_to_i=>nil, :result_maker_id=>nil, :subtitle_text=>nil, :title=>nil, :title_hidden=>false, :title_text=>nil, :type=>"button", :alert_count=>0, :rich_content_json=>"{\"text\":\"PROD - Datagroups\",\"description\":\"Data Groups\",\"newTab\":true,\"alignment\":\"left\",\"size\":\"medium\",\"style\":\"FILLED\",\"color\":\"#1A73E8\",\"href\":\"https://xxxxxprod.cloud.looker.com/admin/datagroups\"}", :title_text_as_html=>nil, :subtitle_text_as_html=>nil, :extension_id=>nil, :result_maker=>nil, :can=>{:create=>true, :update=>true, :destroy=>true, :see_aggregate_table_lookml=>false, :index=>true, :show=>true, :explore=>false, :run=>false, :show_errors=>true, :find_and_replace=>true}}, {:body_text=>nil, :body_text_as_html=>nil, :dashboard_id=>"1126", :edit_uri=>nil, :id=>"60181", :look=>nil, :look_id=>nil, :lookml_link_id=>"", :merge_result_id=>nil, :note_display=>nil, :note_state=>nil, :note_text=>nil, :note_text_as_html=>nil, :query=>nil, :query_id=>nil, :refresh_interval=>nil, :refresh_interval_to_i=>nil, :result_maker_id=>nil, :subtitle_text=>nil, :title=>nil, :title_hidden=>false, :title_text=>nil, :type=>"button", :alert_count=>0, :rich_content_json=>"{\"text\":\"PROD - PDT\",\"description\":\"PDT's Link\",\"newTab\":true,\"alignment\":\"left\",\"size\":\"medium\",\"style\":\"FILLED\",\"color\":\"#1A73E8\",\"href\":\"https://xxxxxprod.cloud.looker.com/admin/pdts?connection=all_connections&workspace=production&filters=#searched=\"}", :title_text_as_html=>nil, :subtitle_text_as_html=>nil, :extension_id=>nil, :result_maker=>nil, :can=>{:create=>true, :update=>true, :destroy=>true, :see_aggregate_table_lookml=>false, :index=>true, :show=>true, :explore=>false, :run=>false, :show_errors=>true, :find_and_replace=>true}}, {:body_text=>nil, :body_text_as_html=>nil, :dashboard_id=>"1126", :edit_uri=>nil, :id=>"60182", :look=>nil, :look_id=>nil, :lookml_link_id=>"", :merge_result_id=>nil, :note_display=>nil, :note_state=>nil, :note_text=>nil, :note_text_as_html=>nil, :query=>{:id=>"288909", :view=>"lnh_sco_door_plan_profile", :fields=>["lnh_sco_door_plan_profile.profile_name", "lnh_sco_door_plan_profile.plan_sic_cd", "lnh_sco_door_plan_profile.plan_shift_cd", "lnh_region_sic_hierarchy_current.lnh_region", "lnh_sco_door_plan.plan_lane_cnt", "lnh_trailer_close.trlr_pfx_sfx", "lnh_trailer_close.trlr_ld_dest_sic", "loc_ops_hierarchy_flatten.lvl2_nm", "loc_ops_hierarchy_flatten.lvl1_nm"], :pivots=>nil, :fill_fields=>nil, :filters=>nil, :filter_expression=>nil, :sorts=>["lnh_sco_door_plan.plan_lane_cnt desc"], :limit=>"500", :column_limit=>nil, :total=>nil, :row_total=>nil, :subtotals=>nil, :vis_config=>{:show_view_names=>false, :show_row_numbers=>true, :truncate_column_names=>false, :hide_totals=>false, :hide_row_totals=>false, :table_theme=>"white", :limit_displayed_rows=>false, :enable_conditional_formatting=>false, :conditional_formatting_include_totals=>false, :conditional_formatting_include_nulls=>false, :type=>"table", :x_axis_gridlines=>false, :y_axis_gridlines=>true, :show_y_axis_labels=>true, :show_y_axis_ticks=>true, :y_axis_tick_density=>"default", :y_axis_tick_density_custom=>5, :show_x_axis_label=>true, :show_x_axis_ticks=>true, :y_axis_scale_mode=>"linear", :x_axis_reversed=>false, :y_axis_reversed=>false, :plot_size_by_field=>false, :trellis=>"", :stacking=>"", :legend_position=>"center", :point_style=>"none", :show_value_labels=>false, :label_density=>25, :x_axis_scale=>"auto", :y_axis_combined=>true, :ordering=>"none", :show_null_labels=>false, :show_totals_labels=>false, :show_silhouette=>false, :totals_color=>"#808080", :defaults_version=>1, :series_types=>{}, :transpose=>false, :truncate_text=>true, :size_to_fit=>true, :header_text_alignment=>"left", :header_font_size=>12, :rows_font_size=>12, :query_fields=>{:measures=>[{:align=>"right", :can_filter=>true, :category=>"measure", :default_filter_value=>nil, :description=>"Count of total planned lanes", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>true, :label=>"Dock Door Plan Total Planned Lanes", :label_from_parameter=>nil, :label_short=>"Total Planned Lanes", :map_layer=>nil, :name=>"lnh_sco_door_plan.plan_lane_cnt", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"count_distinct", :user_attribute_filter_types=>["number", "advanced_filter_number"], :value_format=>nil, :view=>"lnh_sco_door_plan", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Total Planned Lanes", :measure=>true, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan", :suggest_dimension=>"lnh_sco_door_plan.plan_lane_cnt", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>false, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml?line=49", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan.view.lkml", :sql=>"${door_plan_lane_pk}", :sql_case=>nil, :filters=>nil, :times_used=>0, :sorted=>{:desc=>true, :sort_index=>0}}], :dimensions=>[{:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"Profile Name", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Profile Name", :label_from_parameter=>nil, :label_short=>"Profile Name", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.profile_name", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Profile Name", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.profile_name", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=78", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.PROFILE_NAME ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"The location to which the Door Automation model plan and actual execution rollup", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Plan SIC", :label_from_parameter=>nil, :label_short=>"Plan SIC", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.plan_sic_cd", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Plan SIC", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.plan_sic_cd", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=64", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.SIC_CODE ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"The target shift code for the Door Automation model", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Plan Shift", :label_from_parameter=>nil, :label_short=>"Plan Shift", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.plan_shift_cd", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Plan Shift", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.plan_shift_cd", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=71", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.SHIFT_CD ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"Linehaul Region Code. Service centers rollup to one of the 12 linehaul regions.", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Linehaul Region Linehaul Region", :label_from_parameter=>nil, :label_short=>"Linehaul Region", :map_layer=>nil, :name=>"lnh_region_sic_hierarchy_current.lnh_region", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_region_sic_hierarchy_current", :view_label=>"Linehaul Region", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_region_sic_hierarchy_current", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Linehaul Region", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_region_sic_hierarchy_current", :suggest_dimension=>"lnh_region_sic_hierarchy_current.lnh_region", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml?line=26", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_region_sic_hierarchy_current.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_region_sic_hierarchy_current.view.lkml", :sql=>"${TABLE}.GRP_CD ", :sql_case=>nil, :filters=>nil, :times_used=>0}], :table_calculations=>[], :pivots=>[]}, :pinned_columns=>{:"$$$_rownumbers$$$"=>"left", :"lnh_sco_door_plan_profile.profile_name"=>"left"}, :column_order=>["$$$_rownumbers$$$", "lnh_sco_door_plan_profile.profile_name", "lnh_sco_door_plan_profile.plan_sic_cd", "lnh_sco_door_plan_profile.plan_shift_cd", "lnh_region_sic_hierarchy_current.lnh_region", "lnh_sco_door_plan.plan_lane_cnt"], :hidden_fields=>[], :y_axes=>[]}, :filter_config=>nil, :visible_ui_sections=>nil, :slug=>"k7YhBN8", :client_id=>"lMLy4vvURKEsizY1CKUJGG", :share_url=>"https://xxxxxstaging.cloud.looker.com/x/lMLy4vvURKEsizY1CKUJGG", :expanded_share_url=>"https://xxxxxstaging.cloud.looker.com/explore/Main_Linehaul/lnh_sco_door_plan_profile?fields=lnh_sco_door_plan_profile.profile_name,lnh_sco_door_plan_profile.plan_sic_cd,lnh_sco_door_plan_profile.plan_shift_cd,lnh_region_sic_hierarchy_current.lnh_region,lnh_sco_door_plan.plan_lane_cnt,lnh_trailer_close.trlr_pfx_sfx,lnh_trailer_close.trlr_ld_dest_sic,loc_ops_hierarchy_flatten.lvl2_nm,loc_ops_hierarchy_flatten.lvl1_nm&sorts=lnh_sco_door_plan.plan_lane_cnt+desc&limit=500&vis=%7B%22show_view_names%22%3Afalse%2C%22show_row_numbers%22%3Atrue%2C%22truncate_column_names%22%3Afalse%2C%22hide_totals%22%3Afalse%2C%22hide_row_totals%22%3Afalse%2C%22table_theme%22%3A%22white%22%2C%22limit_displayed_rows%22%3Afalse%2C%22enable_conditional_formatting%22%3Afalse%2C%22conditional_formatting_include_totals%22%3Afalse%2C%22conditional_formatting_include_nulls%22%3Afalse%2C%22type%22%3A%22table%22%2C%22x_axis_gridlines%22%3Afalse%2C%22y_axis_gridlines%22%3Atrue%2C%22show_y_axis_labels%22%3Atrue%2C%22show_y_axis_ticks%22%3Atrue%2C%22y_axis_tick_density%22%3A%22default%22%2C%22y_axis_tick_density_custom%22%3A5%2C%22show_x_axis_label%22%3Atrue%2C%22show_x_axis_ticks%22%3Atrue%2C%22y_axis_scale_mode%22%3A%22linear%22%2C%22x_axis_reversed%22%3Afalse%2C%22y_axis_reversed%22%3Afalse%2C%22plot_size_by_field%22%3Afalse%2C%22trellis%22%3A%22%22%2C%22stacking%22%3A%22%22%2C%22legend_position%22%3A%22center%22%2C%22point_style%22%3A%22none%22%2C%22show_value_labels%22%3Afalse%2C%22label_density%22%3A25%2C%22x_axis_scale%22%3A%22auto%22%2C%22y_axis_combined%22%3Atrue%2C%22ordering%22%3A%22none%22%2C%22show_null_labels%22%3Afalse%2C%22show_totals_labels%22%3Afalse%2C%22show_silhouette%22%3Afalse%2C%22totals_color%22%3A%22%23808080%22%2C%22defaults_version%22%3A1%2C%22series_types%22%3A%7B%7D%2C%22transpose%22%3Afalse%2C%22truncate_text%22%3Atrue%2C%22size_to_fit%22%3Atrue%2C%22header_text_alignment%22%3A%22left%22%2C%22header_font_size%22%3A12%2C%22rows_font_size%22%3A12%2C%22query_fields%22%3A%7B%22measures%22%3A%5B%7B%22align%22%3A%22right%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22measure%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Count+of+total+planned+lanes%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Atrue%2C%22label%22%3A%22Dock+Door+Plan+Total+Planned+Lanes%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Total+Planned+Lanes%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22count_distinct%22%2C%22user_attribute_filter_types%22%3A%5B%22number%22%2C%22advanced_filter_number%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Total+Planned+Lanes%22%2C%22measure%22%3Atrue%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Afalse%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan.view.lkml%3Fline%3D49%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22sql%22%3A%22%24%7Bdoor_plan_lane_pk%7D%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%2C%22sorted%22%3A%7B%22desc%22%3Atrue%2C%22sort_index%22%3A0%7D%7D%5D%2C%22dimensions%22%3A%5B%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Profile+Name%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Profile+Name%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Profile+Name%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Profile+Name%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D78%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.PROFILE_NAME+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+location+to+which+the+Door+Automation+model+plan+and+actual+execution+rollup%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+SIC%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+SIC%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+SIC%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D64%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SIC_CODE+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+target+shift+code+for+the+Door+Automation+model%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+Shift%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+Shift%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+Shift%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D71%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SHIFT_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Linehaul+Region+Code.+Service+centers+rollup+to+one+of+the+12+linehaul+regions.%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Linehaul+Region+Linehaul+Region%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Linehaul+Region%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22view_label%22%3A%22Linehaul+Region%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Linehaul+Region%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22suggest_dimension%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_region_sic_hierarchy_current.view.lkml%3Fline%3D26%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.GRP_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%5D%2C%22table_calculations%22%3A%5B%5D%2C%22pivots%22%3A%5B%5D%7D%2C%22pinned_columns%22%3A%7B%22%24%24%24_row_numbers_%24%24%24%22%3A%22left%22%2C%22lnh_sco_door_plan_profile.profile_name%22%3A%22left%22%7D%2C%22column_order%22%3A%5B%22%24%24%24_row_numbers_%24%24%24%22%2C%22lnh_sco_door_plan_profile.profile_name%22%2C%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22lnh_sco_door_plan.plan_lane_cnt%22%5D%2C%22hidden_fields%22%3A%5B%5D%2C%22y_axes%22%3A%5B%5D%7D&origin=share-expanded", :url=>"/explore/Main_Linehaul/lnh_sco_door_plan_profile?fields=lnh_sco_door_plan_profile.profile_name,lnh_sco_door_plan_profile.plan_sic_cd,lnh_sco_door_plan_profile.plan_shift_cd,lnh_region_sic_hierarchy_current.lnh_region,lnh_sco_door_plan.plan_lane_cnt,lnh_trailer_close.trlr_pfx_sfx,lnh_trailer_close.trlr_ld_dest_sic,loc_ops_hierarchy_flatten.lvl2_nm,loc_ops_hierarchy_flatten.lvl1_nm&sorts=lnh_sco_door_plan.plan_lane_cnt+desc&limit=500&vis=%7B%22show_view_names%22%3Afalse%2C%22show_row_numbers%22%3Atrue%2C%22truncate_column_names%22%3Afalse%2C%22hide_totals%22%3Afalse%2C%22hide_row_totals%22%3Afalse%2C%22table_theme%22%3A%22white%22%2C%22limit_displayed_rows%22%3Afalse%2C%22enable_conditional_formatting%22%3Afalse%2C%22conditional_formatting_include_totals%22%3Afalse%2C%22conditional_formatting_include_nulls%22%3Afalse%2C%22type%22%3A%22table%22%2C%22x_axis_gridlines%22%3Afalse%2C%22y_axis_gridlines%22%3Atrue%2C%22show_y_axis_labels%22%3Atrue%2C%22show_y_axis_ticks%22%3Atrue%2C%22y_axis_tick_density%22%3A%22default%22%2C%22y_axis_tick_density_custom%22%3A5%2C%22show_x_axis_label%22%3Atrue%2C%22show_x_axis_ticks%22%3Atrue%2C%22y_axis_scale_mode%22%3A%22linear%22%2C%22x_axis_reversed%22%3Afalse%2C%22y_axis_reversed%22%3Afalse%2C%22plot_size_by_field%22%3Afalse%2C%22trellis%22%3A%22%22%2C%22stacking%22%3A%22%22%2C%22legend_position%22%3A%22center%22%2C%22point_style%22%3A%22none%22%2C%22show_value_labels%22%3Afalse%2C%22label_density%22%3A25%2C%22x_axis_scale%22%3A%22auto%22%2C%22y_axis_combined%22%3Atrue%2C%22ordering%22%3A%22none%22%2C%22show_null_labels%22%3Afalse%2C%22show_totals_labels%22%3Afalse%2C%22show_silhouette%22%3Afalse%2C%22totals_color%22%3A%22%23808080%22%2C%22defaults_version%22%3A1%2C%22series_types%22%3A%7B%7D%2C%22transpose%22%3Afalse%2C%22truncate_text%22%3Atrue%2C%22size_to_fit%22%3Atrue%2C%22header_text_alignment%22%3A%22left%22%2C%22header_font_size%22%3A12%2C%22rows_font_size%22%3A12%2C%22query_fields%22%3A%7B%22measures%22%3A%5B%7B%22align%22%3A%22right%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22measure%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Count+of+total+planned+lanes%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Atrue%2C%22label%22%3A%22Dock+Door+Plan+Total+Planned+Lanes%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Total+Planned+Lanes%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22count_distinct%22%2C%22user_attribute_filter_types%22%3A%5B%22number%22%2C%22advanced_filter_number%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Total+Planned+Lanes%22%2C%22measure%22%3Atrue%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Afalse%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan.view.lkml%3Fline%3D49%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22sql%22%3A%22%24%7Bdoor_plan_lane_pk%7D%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%2C%22sorted%22%3A%7B%22desc%22%3Atrue%2C%22sort_index%22%3A0%7D%7D%5D%2C%22dimensions%22%3A%5B%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Profile+Name%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Profile+Name%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Profile+Name%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Profile+Name%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D78%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.PROFILE_NAME+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+location+to+which+the+Door+Automation+model+plan+and+actual+execution+rollup%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+SIC%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+SIC%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+SIC%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D64%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SIC_CODE+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+target+shift+code+for+the+Door+Automation+model%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+Shift%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+Shift%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+Shift%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D71%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SHIFT_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Linehaul+Region+Code.+Service+centers+rollup+to+one+of+the+12+linehaul+regions.%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Linehaul+Region+Linehaul+Region%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Linehaul+Region%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22view_label%22%3A%22Linehaul+Region%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Linehaul+Region%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22suggest_dimension%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_region_sic_hierarchy_current.view.lkml%3Fline%3D26%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.GRP_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%5D%2C%22table_calculations%22%3A%5B%5D%2C%22pivots%22%3A%5B%5D%7D%2C%22pinned_columns%22%3A%7B%22%24%24%24_rownumbers%24%24%24%22%3A%22left%22%2C%22lnh_sco_door_plan_profile.profile_name%22%3A%22left%22%7D%2C%22column_order%22%3A%5B%22%24%24%24_rownumbers%24%24%24%22%2C%22lnh_sco_door_plan_profile.profile_name%22%2C%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22lnh_sco_door_plan.plan_lane_cnt%22%5D%2C%22hidden_fields%22%3A%5B%5D%2C%22y_axes%22%3A%5B%5D%7D", :has_table_calculations=>false, :model=>"Main_Linehaul", :dynamic_fields=>nil, :query_timezone=>nil, :quick_calcs=>nil, :analysis_config=>nil, :can=>{:run=>true, :see_results=>true, :explore=>true, :create=>true, :show=>true, :cost_estimate=>true, :index=>true, :see_lookml=>true, :see_aggregate_table_lookml=>true, :see_derived_table_lookml=>true, :see_sql=>true, :save=>true, :generate_drill_links=>true, :download=>true, :download_unlimited=>true, :use_custom_fields=>true, :edit_custom_fields=>true, :edit_table_calculations=>true, :schedule=>true, :render=>true}}, :query_id=>"288909", :refresh_interval=>nil, :refresh_interval_to_i=>nil, :result_maker_id=>"18750", :subtitle_text=>nil, :title=>"Untitled", :title_hidden=>false, :title_text=>nil, :type=>"vis", :alert_count=>0, :rich_content_json=>nil, :title_text_as_html=>nil, :subtitle_text_as_html=>nil, :extension_id=>nil, :result_maker=>{:id=>"18750", :dynamic_fields=>nil, :filterables=>[{:model=>"Main_Linehaul", :view=>"lnh_sco_door_plan_profile", :name=>"", :listen=>[]}], :sorts=>["lnh_sco_door_plan.plan_lane_cnt desc"], :merge_result_id=>nil, :total=>false, :query_id=>"288909", :sql_query_id=>"", :query=>{:id=>"288909", :view=>"lnh_sco_door_plan_profile", :fields=>["lnh_sco_door_plan_profile.profile_name", "lnh_sco_door_plan_profile.plan_sic_cd", "lnh_sco_door_plan_profile.plan_shift_cd", "lnh_region_sic_hierarchy_current.lnh_region", "lnh_sco_door_plan.plan_lane_cnt", "lnh_trailer_close.trlr_pfx_sfx", "lnh_trailer_close.trlr_ld_dest_sic", "loc_ops_hierarchy_flatten.lvl2_nm", "loc_ops_hierarchy_flatten.lvl1_nm"], :pivots=>nil, :fill_fields=>nil, :filters=>nil, :filter_expression=>nil, :sorts=>["lnh_sco_door_plan.plan_lane_cnt desc"], :limit=>"500", :column_limit=>nil, :total=>nil, :row_total=>nil, :subtotals=>nil, :vis_config=>{:show_view_names=>false, :show_row_numbers=>true, :truncate_column_names=>false, :hide_totals=>false, :hide_row_totals=>false, :table_theme=>"white", :limit_displayed_rows=>false, :enable_conditional_formatting=>false, :conditional_formatting_include_totals=>false, :conditional_formatting_include_nulls=>false, :type=>"table", :x_axis_gridlines=>false, :y_axis_gridlines=>true, :show_y_axis_labels=>true, :show_y_axis_ticks=>true, :y_axis_tick_density=>"default", :y_axis_tick_density_custom=>5, :show_x_axis_label=>true, :show_x_axis_ticks=>true, :y_axis_scale_mode=>"linear", :x_axis_reversed=>false, :y_axis_reversed=>false, :plot_size_by_field=>false, :trellis=>"", :stacking=>"", :legend_position=>"center", :point_style=>"none", :show_value_labels=>false, :label_density=>25, :x_axis_scale=>"auto", :y_axis_combined=>true, :ordering=>"none", :show_null_labels=>false, :show_totals_labels=>false, :show_silhouette=>false, :totals_color=>"#808080", :defaults_version=>1, :series_types=>{}, :transpose=>false, :truncate_text=>true, :size_to_fit=>true, :header_text_alignment=>"left", :header_font_size=>12, :rows_font_size=>12, :query_fields=>{:measures=>[{:align=>"right", :can_filter=>true, :category=>"measure", :default_filter_value=>nil, :description=>"Count of total planned lanes", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>true, :label=>"Dock Door Plan Total Planned Lanes", :label_from_parameter=>nil, :label_short=>"Total Planned Lanes", :map_layer=>nil, :name=>"lnh_sco_door_plan.plan_lane_cnt", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"count_distinct", :user_attribute_filter_types=>["number", "advanced_filter_number"], :value_format=>nil, :view=>"lnh_sco_door_plan", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Total Planned Lanes", :measure=>true, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan", :suggest_dimension=>"lnh_sco_door_plan.plan_lane_cnt", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>false, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml?line=49", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan.view.lkml", :sql=>"${door_plan_lane_pk}", :sql_case=>nil, :filters=>nil, :times_used=>0, :sorted=>{:desc=>true, :sort_index=>0}}], :dimensions=>[{:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"Profile Name", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Profile Name", :label_from_parameter=>nil, :label_short=>"Profile Name", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.profile_name", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Profile Name", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.profile_name", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=78", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.PROFILE_NAME ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"The location to which the Door Automation model plan and actual execution rollup", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Plan SIC", :label_from_parameter=>nil, :label_short=>"Plan SIC", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.plan_sic_cd", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Plan SIC", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.plan_sic_cd", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=64", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.SIC_CODE ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"The target shift code for the Door Automation model", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Plan Shift", :label_from_parameter=>nil, :label_short=>"Plan Shift", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.plan_shift_cd", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Plan Shift", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.plan_shift_cd", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=71", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.SHIFT_CD ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"Linehaul Region Code. Service centers rollup to one of the 12 linehaul regions.", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Linehaul Region Linehaul Region", :label_from_parameter=>nil, :label_short=>"Linehaul Region", :map_layer=>nil, :name=>"lnh_region_sic_hierarchy_current.lnh_region", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_region_sic_hierarchy_current", :view_label=>"Linehaul Region", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_region_sic_hierarchy_current", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Linehaul Region", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_region_sic_hierarchy_current", :suggest_dimension=>"lnh_region_sic_hierarchy_current.lnh_region", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml?line=26", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_region_sic_hierarchy_current.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_region_sic_hierarchy_current.view.lkml", :sql=>"${TABLE}.GRP_CD ", :sql_case=>nil, :filters=>nil, :times_used=>0}], :table_calculations=>[], :pivots=>[]}, :pinned_columns=>{:"$$$_rownumbers$$$"=>"left", :"lnh_sco_door_plan_profile.profile_name"=>"left"}, :column_order=>["$$$_rownumbers$$$", "lnh_sco_door_plan_profile.profile_name", "lnh_sco_door_plan_profile.plan_sic_cd", "lnh_sco_door_plan_profile.plan_shift_cd", "lnh_region_sic_hierarchy_current.lnh_region", "lnh_sco_door_plan.plan_lane_cnt"], :hidden_fields=>[], :y_axes=>[]}, :filter_config=>nil, :visible_ui_sections=>nil, :slug=>"k7YhBN8", :client_id=>"lMLy4vvURKEsizY1CKUJGG", :share_url=>"https://xxxxxstaging.cloud.looker.com/x/lMLy4vvURKEsizY1CKUJGG", :expanded_share_url=>"https://xxxxxstaging.cloud.looker.com/explore/Main_Linehaul/lnh_sco_door_plan_profile?fields=lnh_sco_door_plan_profile.profile_name,lnh_sco_door_plan_profile.plan_sic_cd,lnh_sco_door_plan_profile.plan_shift_cd,lnh_region_sic_hierarchy_current.lnh_region,lnh_sco_door_plan.plan_lane_cnt,lnh_trailer_close.trlr_pfx_sfx,lnh_trailer_close.trlr_ld_dest_sic,loc_ops_hierarchy_flatten.lvl2_nm,loc_ops_hierarchy_flatten.lvl1_nm&sorts=lnh_sco_door_plan.plan_lane_cnt+desc&limit=500&vis=%7B%22show_view_names%22%3Afalse%2C%22show_row_numbers%22%3Atrue%2C%22truncate_column_names%22%3Afalse%2C%22hide_totals%22%3Afalse%2C%22hide_row_totals%22%3Afalse%2C%22table_theme%22%3A%22white%22%2C%22limit_displayed_rows%22%3Afalse%2C%22enable_conditional_formatting%22%3Afalse%2C%22conditional_formatting_include_totals%22%3Afalse%2C%22conditional_formatting_include_nulls%22%3Afalse%2C%22type%22%3A%22table%22%2C%22x_axis_gridlines%22%3Afalse%2C%22y_axis_gridlines%22%3Atrue%2C%22show_y_axis_labels%22%3Atrue%2C%22show_y_axis_ticks%22%3Atrue%2C%22y_axis_tick_density%22%3A%22default%22%2C%22y_axis_tick_density_custom%22%3A5%2C%22show_x_axis_label%22%3Atrue%2C%22show_x_axis_ticks%22%3Atrue%2C%22y_axis_scale_mode%22%3A%22linear%22%2C%22x_axis_reversed%22%3Afalse%2C%22y_axis_reversed%22%3Afalse%2C%22plot_size_by_field%22%3Afalse%2C%22trellis%22%3A%22%22%2C%22stacking%22%3A%22%22%2C%22legend_position%22%3A%22center%22%2C%22point_style%22%3A%22none%22%2C%22show_value_labels%22%3Afalse%2C%22label_density%22%3A25%2C%22x_axis_scale%22%3A%22auto%22%2C%22y_axis_combined%22%3Atrue%2C%22ordering%22%3A%22none%22%2C%22show_null_labels%22%3Afalse%2C%22show_totals_labels%22%3Afalse%2C%22show_silhouette%22%3Afalse%2C%22totals_color%22%3A%22%23808080%22%2C%22defaults_version%22%3A1%2C%22series_types%22%3A%7B%7D%2C%22transpose%22%3Afalse%2C%22truncate_text%22%3Atrue%2C%22size_to_fit%22%3Atrue%2C%22header_text_alignment%22%3A%22left%22%2C%22header_font_size%22%3A12%2C%22rows_font_size%22%3A12%2C%22query_fields%22%3A%7B%22measures%22%3A%5B%7B%22align%22%3A%22right%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22measure%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Count+of+total+planned+lanes%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Atrue%2C%22label%22%3A%22Dock+Door+Plan+Total+Planned+Lanes%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Total+Planned+Lanes%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22count_distinct%22%2C%22user_attribute_filter_types%22%3A%5B%22number%22%2C%22advanced_filter_number%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Total+Planned+Lanes%22%2C%22measure%22%3Atrue%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Afalse%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan.view.lkml%3Fline%3D49%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22sql%22%3A%22%24%7Bdoor_plan_lane_pk%7D%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%2C%22sorted%22%3A%7B%22desc%22%3Atrue%2C%22sort_index%22%3A0%7D%7D%5D%2C%22dimensions%22%3A%5B%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Profile+Name%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Profile+Name%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Profile+Name%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Profile+Name%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D78%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.PROFILE_NAME+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+location+to+which+the+Door+Automation+model+plan+and+actual+execution+rollup%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+SIC%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+SIC%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+SIC%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D64%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SIC_CODE+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+target+shift+code+for+the+Door+Automation+model%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+Shift%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+Shift%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+Shift%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D71%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SHIFT_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Linehaul+Region+Code.+Service+centers+rollup+to+one+of+the+12+linehaul+regions.%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Linehaul+Region+Linehaul+Region%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Linehaul+Region%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22view_label%22%3A%22Linehaul+Region%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Linehaul+Region%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22suggest_dimension%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_region_sic_hierarchy_current.view.lkml%3Fline%3D26%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.GRP_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%5D%2C%22table_calculations%22%3A%5B%5D%2C%22pivots%22%3A%5B%5D%7D%2C%22pinned_columns%22%3A%7B%22%24%24%24_row_numbers_%24%24%24%22%3A%22left%22%2C%22lnh_sco_door_plan_profile.profile_name%22%3A%22left%22%7D%2C%22column_order%22%3A%5B%22%24%24%24_row_numbers_%24%24%24%22%2C%22lnh_sco_door_plan_profile.profile_name%22%2C%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22lnh_sco_door_plan.plan_lane_cnt%22%5D%2C%22hidden_fields%22%3A%5B%5D%2C%22y_axes%22%3A%5B%5D%7D&origin=share-expanded", :url=>"/explore/Main_Linehaul/lnh_sco_door_plan_profile?fields=lnh_sco_door_plan_profile.profile_name,lnh_sco_door_plan_profile.plan_sic_cd,lnh_sco_door_plan_profile.plan_shift_cd,lnh_region_sic_hierarchy_current.lnh_region,lnh_sco_door_plan.plan_lane_cnt,lnh_trailer_close.trlr_pfx_sfx,lnh_trailer_close.trlr_ld_dest_sic,loc_ops_hierarchy_flatten.lvl2_nm,loc_ops_hierarchy_flatten.lvl1_nm&sorts=lnh_sco_door_plan.plan_lane_cnt+desc&limit=500&vis=%7B%22show_view_names%22%3Afalse%2C%22show_row_numbers%22%3Atrue%2C%22truncate_column_names%22%3Afalse%2C%22hide_totals%22%3Afalse%2C%22hide_row_totals%22%3Afalse%2C%22table_theme%22%3A%22white%22%2C%22limit_displayed_rows%22%3Afalse%2C%22enable_conditional_formatting%22%3Afalse%2C%22conditional_formatting_include_totals%22%3Afalse%2C%22conditional_formatting_include_nulls%22%3Afalse%2C%22type%22%3A%22table%22%2C%22x_axis_gridlines%22%3Afalse%2C%22y_axis_gridlines%22%3Atrue%2C%22show_y_axis_labels%22%3Atrue%2C%22show_y_axis_ticks%22%3Atrue%2C%22y_axis_tick_density%22%3A%22default%22%2C%22y_axis_tick_density_custom%22%3A5%2C%22show_x_axis_label%22%3Atrue%2C%22show_x_axis_ticks%22%3Atrue%2C%22y_axis_scale_mode%22%3A%22linear%22%2C%22x_axis_reversed%22%3Afalse%2C%22y_axis_reversed%22%3Afalse%2C%22plot_size_by_field%22%3Afalse%2C%22trellis%22%3A%22%22%2C%22stacking%22%3A%22%22%2C%22legend_position%22%3A%22center%22%2C%22point_style%22%3A%22none%22%2C%22show_value_labels%22%3Afalse%2C%22label_density%22%3A25%2C%22x_axis_scale%22%3A%22auto%22%2C%22y_axis_combined%22%3Atrue%2C%22ordering%22%3A%22none%22%2C%22show_null_labels%22%3Afalse%2C%22show_totals_labels%22%3Afalse%2C%22show_silhouette%22%3Afalse%2C%22totals_color%22%3A%22%23808080%22%2C%22defaults_version%22%3A1%2C%22series_types%22%3A%7B%7D%2C%22transpose%22%3Afalse%2C%22truncate_text%22%3Atrue%2C%22size_to_fit%22%3Atrue%2C%22header_text_alignment%22%3A%22left%22%2C%22header_font_size%22%3A12%2C%22rows_font_size%22%3A12%2C%22query_fields%22%3A%7B%22measures%22%3A%5B%7B%22align%22%3A%22right%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22measure%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Count+of+total+planned+lanes%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Atrue%2C%22label%22%3A%22Dock+Door+Plan+Total+Planned+Lanes%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Total+Planned+Lanes%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22count_distinct%22%2C%22user_attribute_filter_types%22%3A%5B%22number%22%2C%22advanced_filter_number%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Total+Planned+Lanes%22%2C%22measure%22%3Atrue%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan.plan_lane_cnt%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Afalse%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan.view.lkml%3Fline%3D49%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml%22%2C%22sql%22%3A%22%24%7Bdoor_plan_lane_pk%7D%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%2C%22sorted%22%3A%7B%22desc%22%3Atrue%2C%22sort_index%22%3A0%7D%7D%5D%2C%22dimensions%22%3A%5B%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Profile+Name%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Profile+Name%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Profile+Name%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Profile+Name%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.profile_name%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D78%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.PROFILE_NAME+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+location+to+which+the+Door+Automation+model+plan+and+actual+execution+rollup%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+SIC%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+SIC%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+SIC%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D64%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SIC_CODE+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22The+target+shift+code+for+the+Door+Automation+model%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Dock+Door+Plan+Plan+Shift%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Plan+Shift%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_sco_door_plan_profile%22%2C%22view_label%22%3A%22Dock+Door+Plan%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_sco_door_plan_profile%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Plan+Shift%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggest_dimension%22%3A%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_sco_door_plan_profile.view.lkml%3Fline%3D71%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.SHIFT_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%2C%7B%22align%22%3A%22left%22%2C%22can_filter%22%3Atrue%2C%22category%22%3A%22dimension%22%2C%22default_filter_value%22%3Anull%2C%22description%22%3A%22Linehaul+Region+Code.+Service+centers+rollup+to+one+of+the+12+linehaul+regions.%22%2C%22enumerations%22%3Anull%2C%22field_group_label%22%3Anull%2C%22fill_style%22%3Anull%2C%22fiscal_month_offset%22%3A0%2C%22has_allowed_values%22%3Afalse%2C%22hidden%22%3Afalse%2C%22is_filter%22%3Afalse%2C%22is_numeric%22%3Afalse%2C%22label%22%3A%22Linehaul+Region+Linehaul+Region%22%2C%22label_from_parameter%22%3Anull%2C%22label_short%22%3A%22Linehaul+Region%22%2C%22map_layer%22%3Anull%2C%22name%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22strict_value_format%22%3Afalse%2C%22requires_refresh_on_sort%22%3Afalse%2C%22sortable%22%3Atrue%2C%22suggestions%22%3Anull%2C%22tags%22%3A%5B%5D%2C%22type%22%3A%22string%22%2C%22user_attribute_filter_types%22%3A%5B%22string%22%2C%22advanced_filter_string%22%5D%2C%22value_format%22%3Anull%2C%22view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22view_label%22%3A%22Linehaul+Region%22%2C%22dynamic%22%3Afalse%2C%22week_start_day%22%3A%22sunday%22%2C%22original_view%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22dimension_group%22%3Anull%2C%22error%22%3Anull%2C%22field_group_variant%22%3A%22Linehaul+Region%22%2C%22measure%22%3Afalse%2C%22parameter%22%3Afalse%2C%22primary_key%22%3Afalse%2C%22project_name%22%3A%22xpo_ltl_bi%22%2C%22scope%22%3A%22lnh_region_sic_hierarchy_current%22%2C%22suggest_dimension%22%3A%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22suggest_explore%22%3A%22lnh_sco_door_plan_profile%22%2C%22suggestable%22%3Atrue%2C%22is_fiscal%22%3Afalse%2C%22is_timeframe%22%3Afalse%2C%22can_time_filter%22%3Afalse%2C%22time_interval%22%3Anull%2C%22lookml_link%22%3A%22%2Fprojects%2Fxpo_ltl_bi%2Ffiles%2Flinehaul%252FDerived_Table_Views%252Flnh_region_sic_hierarchy_current.view.lkml%3Fline%3D26%22%2C%22permanent%22%3Anull%2C%22source_file%22%3A%22linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22source_file_path%22%3A%22xpo_ltl_bi%2Flinehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml%22%2C%22sql%22%3A%22%24%7BTABLE%7D.GRP_CD+%22%2C%22sql_case%22%3Anull%2C%22filters%22%3Anull%2C%22times_used%22%3A0%7D%5D%2C%22table_calculations%22%3A%5B%5D%2C%22pivots%22%3A%5B%5D%7D%2C%22pinned_columns%22%3A%7B%22%24%24%24_rownumbers%24%24%24%22%3A%22left%22%2C%22lnh_sco_door_plan_profile.profile_name%22%3A%22left%22%7D%2C%22column_order%22%3A%5B%22%24%24%24_rownumbers%24%24%24%22%2C%22lnh_sco_door_plan_profile.profile_name%22%2C%22lnh_sco_door_plan_profile.plan_sic_cd%22%2C%22lnh_sco_door_plan_profile.plan_shift_cd%22%2C%22lnh_region_sic_hierarchy_current.lnh_region%22%2C%22lnh_sco_door_plan.plan_lane_cnt%22%5D%2C%22hidden_fields%22%3A%5B%5D%2C%22y_axes%22%3A%5B%5D%7D", :has_table_calculations=>false, :model=>"Main_Linehaul", :dynamic_fields=>nil, :query_timezone=>nil, :quick_calcs=>nil, :analysis_config=>nil, :can=>{:run=>true, :see_results=>true, :explore=>true, :create=>true, :show=>true, :cost_estimate=>true, :index=>true, :see_lookml=>true, :see_aggregate_table_lookml=>true, :see_derived_table_lookml=>true, :see_sql=>true, :save=>true, :generate_drill_links=>true, :download=>true, :download_unlimited=>true, :use_custom_fields=>true, :edit_custom_fields=>true, :edit_table_calculations=>true, :schedule=>true, :render=>true}}, :vis_config=>{:show_view_names=>false, :show_row_numbers=>true, :truncate_column_names=>false, :hide_totals=>false, :hide_row_totals=>false, :table_theme=>"white", :limit_displayed_rows=>false, :enable_conditional_formatting=>false, :conditional_formatting_include_totals=>false, :conditional_formatting_include_nulls=>false, :type=>"table", :x_axis_gridlines=>false, :y_axis_gridlines=>true, :show_y_axis_labels=>true, :show_y_axis_ticks=>true, :y_axis_tick_density=>"default", :y_axis_tick_density_custom=>5, :show_x_axis_label=>true, :show_x_axis_ticks=>true, :y_axis_scale_mode=>"linear", :x_axis_reversed=>false, :y_axis_reversed=>false, :plot_size_by_field=>false, :trellis=>"", :stacking=>"", :legend_position=>"center", :point_style=>"none", :show_value_labels=>false, :label_density=>25, :x_axis_scale=>"auto", :y_axis_combined=>true, :ordering=>"none", :show_null_labels=>false, :show_totals_labels=>false, :show_silhouette=>false, :totals_color=>"#808080", :defaults_version=>1, :series_types=>{}, :transpose=>false, :truncate_text=>true, :size_to_fit=>true, :header_text_alignment=>"left", :header_font_size=>12, :rows_font_size=>12, :query_fields=>{:measures=>[{:align=>"right", :can_filter=>true, :category=>"measure", :default_filter_value=>nil, :description=>"Count of total planned lanes", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>true, :label=>"Dock Door Plan Total Planned Lanes", :label_from_parameter=>nil, :label_short=>"Total Planned Lanes", :map_layer=>nil, :name=>"lnh_sco_door_plan.plan_lane_cnt", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"count_distinct", :user_attribute_filter_types=>["number", "advanced_filter_number"], :value_format=>nil, :view=>"lnh_sco_door_plan", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Total Planned Lanes", :measure=>true, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan", :suggest_dimension=>"lnh_sco_door_plan.plan_lane_cnt", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>false, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan.view.lkml?line=49", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan.view.lkml", :sql=>"${door_plan_lane_pk}", :sql_case=>nil, :filters=>nil, :times_used=>0, :sorted=>{:desc=>true, :sort_index=>0}}], :dimensions=>[{:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"Profile Name", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Profile Name", :label_from_parameter=>nil, :label_short=>"Profile Name", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.profile_name", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Profile Name", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.profile_name", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=78", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.PROFILE_NAME ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"The location to which the Door Automation model plan and actual execution rollup", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Plan SIC", :label_from_parameter=>nil, :label_short=>"Plan SIC", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.plan_sic_cd", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Plan SIC", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.plan_sic_cd", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=64", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.SIC_CODE ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"The target shift code for the Door Automation model", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Dock Door Plan Plan Shift", :label_from_parameter=>nil, :label_short=>"Plan Shift", :map_layer=>nil, :name=>"lnh_sco_door_plan_profile.plan_shift_cd", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_sco_door_plan_profile", :view_label=>"Dock Door Plan", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_sco_door_plan_profile", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Plan Shift", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_sco_door_plan_profile", :suggest_dimension=>"lnh_sco_door_plan_profile.plan_shift_cd", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_sco_door_plan_profile.view.lkml?line=71", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_sco_door_plan_profile.view.lkml", :sql=>"${TABLE}.SHIFT_CD ", :sql_case=>nil, :filters=>nil, :times_used=>0}, {:align=>"left", :can_filter=>true, :category=>"dimension", :default_filter_value=>nil, :description=>"Linehaul Region Code. Service centers rollup to one of the 12 linehaul regions.", :enumerations=>nil, :field_group_label=>nil, :fill_style=>nil, :fiscal_month_offset=>0, :has_allowed_values=>false, :hidden=>false, :is_filter=>false, :is_numeric=>false, :label=>"Linehaul Region Linehaul Region", :label_from_parameter=>nil, :label_short=>"Linehaul Region", :map_layer=>nil, :name=>"lnh_region_sic_hierarchy_current.lnh_region", :strict_value_format=>false, :requires_refresh_on_sort=>false, :sortable=>true, :suggestions=>nil, :tags=>[], :type=>"string", :user_attribute_filter_types=>["string", "advanced_filter_string"], :value_format=>nil, :view=>"lnh_region_sic_hierarchy_current", :view_label=>"Linehaul Region", :dynamic=>false, :week_start_day=>"sunday", :original_view=>"lnh_region_sic_hierarchy_current", :dimension_group=>nil, :error=>nil, :field_group_variant=>"Linehaul Region", :measure=>false, :parameter=>false, :primary_key=>false, :project_name=>"xpo_ltl_bi", :scope=>"lnh_region_sic_hierarchy_current", :suggest_dimension=>"lnh_region_sic_hierarchy_current.lnh_region", :suggest_explore=>"lnh_sco_door_plan_profile", :suggestable=>true, :is_fiscal=>false, :is_timeframe=>false, :can_time_filter=>false, :time_interval=>nil, :lookml_link=>"/projects/xpo_ltl_bi/files/linehaul%2FDerived_Table_Views%2Flnh_region_sic_hierarchy_current.view.lkml?line=26", :permanent=>nil, :source_file=>"linehaul/Derived_Table_Views/lnh_region_sic_hierarchy_current.view.lkml", :source_file_path=>"xpo_ltl_bi/linehaul/Derived_Table_Views/lnh_region_sic_hierarchy_current.view.lkml", :sql=>"${TABLE}.GRP_CD ", :sql_case=>nil, :filters=>nil, :times_used=>0}], :table_calculations=>[], :pivots=>[]}, :pinned_columns=>{:"$$$_rownumbers$$$"=>"left", :"lnh_sco_door_plan_profile.profile_name"=>"left"}, :column_order=>["$$$_rownumbers$$$", "lnh_sco_door_plan_profile.profile_name", "lnh_sco_door_plan_profile.plan_sic_cd", "lnh_sco_door_plan_profile.plan_shift_cd", "lnh_region_sic_hierarchy_current.lnh_region", "lnh_sco_door_plan.plan_lane_cnt"], :hidden_fields=>[], :y_axes=>[]}}, :can=>{:create=>true, :update=>true, :destroy=>true, :see_aggregate_table_lookml=>true, :index=>true, :show=>true, :explore=>true, :run=>false, :show_errors=>true, :find_and_replace=>true}}], :dashboard_filters=>[], :dashboard_layouts=>[{:id=>"1126", :dashboard_id=>"1126", :type=>"newspaper", :active=>true, :column_width=>nil, :width=>nil, :deleted=>true, :dashboard_title=>"Button test", :dashboard_layout_components=>[{:id=>"60180", :dashboard_layout_id=>"1126", :dashboard_element_id=>"60180", :row=>0, :column=>0, :width=>2, :height=>1, :deleted=>true, :element_title=>"", :element_title_hidden=>false, :vis_type=>"", :can=>{:index=>true, :show=>true, :create=>true, :update=>true, :destroy=>true}}, {:id=>"60181", :dashboard_layout_id=>"1126", :dashboard_element_id=>"60181", :row=>0, :column=>2, :width=>2, :height=>1, :deleted=>true, :element_title=>"", :element_title_hidden=>false, :vis_type=>"", :can=>{:index=>true, :show=>true, :create=>true, :update=>true, :destroy=>true}}, {:id=>"60182", :dashboard_layout_id=>"1126", :dashboard_element_id=>"60182", :row=>1, :column=>0, :width=>8, :height=>6, :deleted=>true, :element_title=>"Untitled", :element_title_hidden=>false, :vis_type=>"", :can=>{:index=>true, :show=>true, :create=>true, :update=>true, :destroy=>true}}], :can=>{:create=>true, :update=>true, :destroy=>true, :index=>true, :show=>true}}], :deleted_at=>2023-05-03 20:26:58 +0000, :deleter_id=>"3", :edit_uri=>nil, :enable_viz_full_screen=>true, :favorite_count=>0, :filters_bar_collapsed=>false, :filters_location_top=>true, :last_accessed_at=>2023-05-03 18:33:06 +0000, :updated_at=>2023-05-03 18:48:06 +0000, :last_updater_id=>"221", :last_updater_name=>"TeamCityJobs Staging", :user_name=>"TeamCityJobs Staging", :load_configuration=>"cache_run", :lookml_link_id=>nil, :show_filters_bar=>nil, :show_title=>nil, :text_tile_text_color=>nil, :tile_background_color=>nil, :tile_text_color=>nil, :title_color=>nil, :view_count=>1, :url=>"/dashboards/1126", :folder=>{:name=>"Admin Reports - UAT", :parent_id=>"433", :id=>"1244", :content_metadata_id=>"2965", :created_at=>2021-09-13 12:01:58 +0000, :creator_id=>"3", :external_id=>"", :is_embed=>false, :is_embed_shared_root=>false, :is_embed_users_root=>false, :is_personal=>false, :is_personal_descendant=>false, :is_shared_root=>false, :is_users_root=>false, :child_count=>0, :can=>{:index=>true, :show=>true, :create=>true, :see_admin_spaces=>true, :save_shared_space_as_embed_user=>true, :destroy=>true, :update=>true, :move_content=>true, :edit_content=>true}}, :folder_id=>"1244", :content_favorite_id=>nil, :id=>"1126", :model=>nil, :deleted=>true, :last_viewed_at=>nil, :appearance=>nil, :can=>{:download=>true, :see_aggregate_table_lookml=>true, :index=>true, :show=>true, :copy=>true, :run=>true, :create=>true, :move=>true, :update=>true, :destroy=>true, :recover=>true, :see_lookml=>true, :schedule=>true, :render=>true}}
13:36:42 Modifying existing dashboard 1126 Button test in folder 1244
13:36:42 key_list update_dashboard -> [:description, :hidden, :query_timezone, :refresh_interval, :title, :slug, :preferred_viewer, :alert_sync_with_dashboard_filter_enabled, :background_color, :crossfilter_enabled, :deleted, :enable_viz_full_screen, :filters_bar_collapsed, :filters_location_top, :load_configuration, :lookml_link_id, :show_filters_bar, :show_title, :folder_id, :text_tile_text_color, :tile_background_color, :tile_text_color, :title_color, :appearance]
13:36:42 dashboard object "[[\"content_metadata_id\",\"4215\"],[\"description\",\"\"],[\"hidden\",false],[\"query_timezone\",null],[\"readonly\",false],[\"refresh_interval\",null],[\"refresh_interval_to_i\",null],[\"title\",\"Button test\"],[\"user_id\",\"221\"],[\"slug\",\"7VUxMyB4s4ay5mFc97fOdK\"],[\"preferred_viewer\",\"dashboards-next\"],[\"alert_sync_with_dashboard_filter_enabled\",false],[\"background_color\",null],[\"created_at\",\"2023-05-03 17:39:47 +0000\"],[\"crossfilter_enabled\",false],[\"dashboard_elements\",[]],[\"dashboard_filters\",[]],[\"dashboard_layouts\",[\"#
SivanarayanaReddyTamalampudi
commented
1 year ago Below is the script which i have modified as per your suggestion i got above output,
1) from the below script i can be able to import to another instance.after import i am not able to move it to same instance in different folder.
example from deploy folder to deployed folder in same instance.
echo "DEBUGL: Passed parameters are $dashboard_file_name $source_deployed_space_id $source_client_id $source_client_secret $source_host $target_space_id $target_client_id $target_client_secret $target_host"
echo "DEBUGL: gzr dashboard import $dashboard_file_name ${target_space_id} --host=${target_host} --port=443 --client-id=${target_client_id} --client-secret=${target_client_secret} --debug --force"
gzr dashboard import "$dashboard_file_name" ${target_space_id} --host="${target_host}" --port="443" --client-id="${target_client_id}" --client-secret="${target_client_secret}" --debug --force
source_dashboard_id=$( gzr dashboard import "$dashboard_file_name" ${target_space_id} --host="${target_host}" --port="443" --client-id="${target_client_id}" --client-secret="${target_client_secret}" --plain --force)
echo "DEBUGL: $source_dashboard_id echo "DEBUGL: gzr dashboard mv $source_dashboard_id $source_deployed_space_id --host=${source_host} --port=443 --client-id=${source_client_id} --client-secret=${source_client_secret} --debug --force"
gzr dashboard mv $source_dashboard_id $source_deployed_space_id --host="${source_host}" --port="443" --client-id="${source_client_id}" --client-secret="${source_client_secret}" --debug --force echo "END OF THE MIGRATE DASHBOARD SCRIPT"
drstrangelooker
commented
1 year ago It looks like you are doing the import twice. But that should work.
11:48:03 Step 5/8: migrate-dashboards-for-staging (Command Line) 11:48:03 Starting: /opt/buildagent/temp/agentTmp/custom_script5303514414657382621 11:48:03 in directory: /opt/buildagent/work/113bb1902924fa58/Admin Reports - UAT Deploy 11:48:03 total 120 11:48:03 -rw-r--r-- 1 root root 115952 May 3 19:48 Dashboard_2279_Button test.json 11:48:03 -rw-r--r-- 1 root root 658 May 3 19:47 Folder_1328_Admin Reports - UAT Deploy.json 11:48:03 Migrate Dashboard json files to staging Admin Reports - UAT Deploy \n 11:48:03 DEBUGL: Passed parameters are ./Dashboard_2279_Button test.json 1329 3dfCdCXBP9zrxdzn4Q2w xpologisticsdev.cloud.looker.com 1244 gfMfp8zZkCfP2HS5zQ7B xpologisticsstaging.cloud.looker.com 11:48:03 DEBUGL: gzr dashboard import ./Dashboard_2279_Button test.json 1244 --host=xxxxxxx.cloud.looker.com --port=443 --client-id=xxxxxxx --client-secret= --debug --force 11:48:06 options: {"debug"=>true, "host"=>"xxxxxxxxx.cloud.looker.com", "port"=>"443", "ssl"=>true, "verify_ssl"=>true, "timeout"=>60, "force"=>true, "persistent"=>false, "client_id"=>"gfMfp8zZkCfP2HS5zQ7B", "client_secret"=>""} 11:48:06 using options ["debug=>true", "host=>xxxxxxxx.cloud.looker.com", "port=>443", "ssl=>true", "verify_ssl=>true", "timeout=>60", "force=>true", "persistent=>false", "client_id=>gfMfp8zZkCfP2HS5zQ7B"] 11:48:06 API current_version 4.0 11:48:06 Supported API versions ["3.0", "3.1", "4.0"] 11:48:06 connecting to ["api_endpoint=>https://xxxxxxx.cloud.looker.com:443/api/4.0", "connection_options=>{:ssl=>{:verify=>true, :verify_mode=>3}, :request=>{:timeout=>60}}", "user_agent=>Gazer 0.3.2", "client_id=>xxxxxxxxx", "client_secret=>*****"] 11:48:06 check for connectivity: true 11:48:06 verify authentication: true 11:48:09 Updating layout 1126 11:48:09 key_list update_dashboard_layout_component -> [:dashboard_layout_id, :dashboard_element_id, :row, :column, :width, :height] 11:48:09 Updating dashboard layout component 60180 11:48:09 Updating dashboard layout component 60181 11:48:09 Updating dashboard layout component 60182 11:48:09 Imported dashboard 1126 11:48:09 logout
11:48:09 DEBUGL: gzr dashboard mv "2279" 1329 --host=xxxxxxxx.cloud.looker.com --port=443 --client-id=3dfCdCXBP9zrxdzn4Q2w --client-secret=*** --debug --force 11:48:10 options: {"debug"=>true, "host"=>"xxxxxxx.cloud.looker.com", "port"=>"443", "ssl"=>true, "verify_ssl"=>true, "timeout"=>60, "force"=>true, "persistent"=>false, "client_id"=>"3dfCdCXBP9zrxdzn4Q2w", "client_secret"=>"*"} 11:48:10 using options ["debug=>true", "host=>xxxxx.cloud.looker.com", "port=>443", "ssl=>true", "verify_ssl=>true", "timeout=>60", "force=>true", "persistent=>false", "client_id=>3dfCdCXBP9zrxdzn4Q2w"] 11:48:10 API current_version 4.0 11:48:10 Supported API versions ["3.0", "3.1", "4.0"] 11:48:10 connecting to ["api_endpoint=>https://xxxxxx.cloud.looker.com:443/api/4.0", "connection_options=>{:ssl=>{:verify=>true, :verify_mode=>3}, :request=>{:timeout=>60}}", "user_agent=>Gazer 0.3.2", "client_id=>3dfCdCXBP9zrxdzn4Q2w", "client_secret=>***"] 11:48:10 check for connectivity: true 11:48:10 verify authentication: true 11:48:10 Error querying dashboard("2279") 11:48:10 GET https://xxxxx.cloud.looker.com/api/4.0/dashboards/%222279%22: 404 - The resource you're looking for could not be found
11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/looker-sdk-0.1.4/lib/looker-sdk/response/raise_error.rb:37:in'
11:48:10 logout
11:48:10 ERROR: The resource you're looking for could not be found
11:48:10 END OF THE MIGRATE DASHBOARD SCRIPT
11:48:10 Process exited with code 0
on_complete' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/faraday-1.10.3/lib/faraday/middleware.rb:19:inblock in call' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/faraday-1.10.3/lib/faraday/response.rb:61:inon_complete' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/faraday-1.10.3/lib/faraday/middleware.rb:18:incall' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/faraday-1.10.3/lib/faraday/rack_builder.rb:154:inbuild_response' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/faraday-1.10.3/lib/faraday/connection.rb:516:inrun_request' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/faraday-1.10.3/lib/faraday/connection.rb:202:inget' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/sawyer-0.9.2/lib/sawyer/agent.rb:99:incall' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/looker-sdk-0.1.4/lib/looker-sdk/client.rb:316:inrequest' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/looker-sdk-0.1.4/lib/looker-sdk/client.rb:99:inget' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/looker-sdk-0.1.4/lib/looker-sdk/client/dynamic.rb:146:ininvoke_remote' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/looker-sdk-0.1.4/lib/looker-sdk/client/dynamic.rb:107:inmethod_missing' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/gazer-0.3.2/lib/gzr/modules/dashboard.rb:32:inquery_dashboard' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/gazer-0.3.2/lib/gzr/commands/dashboard/mv.rb:44:inblock in execute' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/gazer-0.3.2/lib/gzr/modules/session.rb:244:inwith_session' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/gazer-0.3.2/lib/gzr/commands/dashboard/mv.rb:42:inexecute' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/gazer-0.3.2/lib/gzr/commands/dashboard.rb:42:inmv' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/command.rb:27:inrun' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:ininvoke_command' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor.rb:392:indispatch' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/invocation.rb:116:ininvoke' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor.rb:243:inblock in subcommand' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/command.rb:27:inrun' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:ininvoke_command' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor.rb:392:indispatch' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/base.rb:485:instart' 11:48:10 /usr/local/lib/ruby/gems/2.7.0/gems/gazer-0.3.2/exe/gzr:36:in<top (required)>' 11:48:10 /usr/local/bin/gzr:23:inload' 11:48:10 /usr/local/bin/gzr:23:in `