{"id":5820,"date":"2022-02-09T22:32:51","date_gmt":"2022-02-09T22:32:51","guid":{"rendered":"http:\/\/forquestsolutions.com\/?p=5820"},"modified":"2026-03-18T18:05:10","modified_gmt":"2026-03-18T18:05:10","slug":"distance-calculation","status":"publish","type":"post","link":"https:\/\/forquestsolutions.com\/staging\/7345\/distance-calculation\/","title":{"rendered":"Planning Analytics Distance Calculation"},"content":{"rendered":"

Straight-Line Distance Calculation<\/h1>\n

Straight-line distance otherwise known as how the crow flies is the simplest way of measuring distance between two destinations. However, this distance can be calculated using different formulas based on a variety of assumptions.
<\/strong><\/p>\n

Pythagorean Theorem:<\/strong>
Distance = SQRT((X2 – X1)^2 + (Y2 – Y1)^2)
Where X1, Y1 and X2, Y2 are the Cartesian coordinates of your destinations.<\/p>\n

You can only use this equation when your coordinates are projected geographical coordinates and the distance between the two destinations is less than 12 miles (20 kilometers).<\/p>\n

\"IBM
\"IBM<\/p>\n

    \n
  1. Below are the steps to create a zip to zip calculator in IBM Planning Analytics.<\/li>\n<\/ol>\n

    Step 1: Create 2 dimensions in Planning Analytics (From Zip and To Zip)<\/p>\n

    Step 2: Create latitude and longitude numeric attributes on both dimensions.<\/p>\n

    Step 3: Populate the US zip code elements in both dimensions<\/p>\n

    Step 4: Populate the latitude and longitude attributes on both dimensions.<\/p>\n

    Step 5:\u00a0 Create a Measure dimension for your cube and call it “Distance Measure”<\/p>\n

    Step 6:\u00a0 Create a cube called Distance<\/p>\n

    Step 7: Create a cube business rule on the Distance cube<\/p>\n

    Step 8:\u00a0 Add the following rules to the cube and save the rule<\/p>\n

      \n
    • [‘Miles’] = N: SQRT((69*(ATTRN(‘FromZip’,!FromZip,’Latitude’) – ATTRN(‘ToZip’,!ToZip,’Latitude’)))^2 + (53*(ATTRN(‘FromZip’,!FromZip,’Longitude’)-ATTRN(‘ToZip’,!ToZip,’Longitude’)))^2);<\/li>\n<\/ul>\n
        \n
      • [‘Kilometers’] = N: [‘Miles’] * 1.60934;<\/li>\n<\/ul>\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        Straight-Line Distance Calculation<\/p>\n","protected":false},"author":16,"featured_media":5821,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[27],"tags":[71,70],"class_list":["post-5820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-planning-analytics","tag-calculations","tag-distance"],"_links":{"self":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/5820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/comments?post=5820"}],"version-history":[{"count":8,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/5820\/revisions"}],"predecessor-version":[{"id":9468,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/5820\/revisions\/9468"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media\/5821"}],"wp:attachment":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media?parent=5820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/categories?post=5820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/tags?post=5820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}