{"id":1434,"date":"2017-01-23T13:47:52","date_gmt":"2017-01-23T08:17:52","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1434"},"modified":"2017-01-23T13:47:52","modified_gmt":"2017-01-23T08:17:52","slug":"intermediate-relationship-between-fact-and-dimension","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1434","title":{"rendered":"Intermediate relationship between Fact and Dimension"},"content":{"rendered":"<p><b>Error:<\/b><\/p>\n<p>The error occurred while defining an intermediate relationship between Fact and Dimension.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg\" rel=\"attachment wp-att-1435\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1435\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg\" alt=\"1\" width=\"627\" height=\"287\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13-300x137.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>The error says that it cannot find the attribute key \u201cArea Id\u201d. Now in a referenced relationship a dimension table is not directly connected to the Fact table but it is connected via an intermediate table. So for getting the data with the usage of that referenced dimension table and Fact table we go to our Cube where we have \u201cDimension Usage\u201d tab where we can define relationships between Fact &amp; Dimension.<\/p>\n<p>Now there are many kinds of relationships like 1 to many, many to 1, many to many, referenced, etc. So here in the below image we see that we have taken referenced relationship and the respected fields like \u201cReference Dimension\u201d, \u201cIntermediate Dimension Relationship\u201d. Also there are two other fields which defines that through which attribute the reference and intermediate dimension are connected, in this case we want it through \u201cAreaId\u201d. But in the below image we see that for Intermediate dimension attribute it is showing only CountryId.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-13.jpg\" rel=\"attachment wp-att-1436\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1436\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-13.jpg\" alt=\"2\" width=\"628\" height=\"366\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-13.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-13-300x175.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>And due to this reason the error has occurred. This error is faced by every student during <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training at Mumbai<\/a> when intermediate relationship is established in SSAS.<\/p>\n<p><b>Solution:<\/b><\/p>\n<p>The solution to this error is when we create a Dimension for Area and also changed the Dimension Country table in our Data Source View. So now we only have to add the AreaId attribute to our Country Dimension.<\/p>\n<p>This is our Data Source View.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-12.jpg\" rel=\"attachment wp-att-1437\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1437\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-12.jpg\" alt=\"3\" width=\"627\" height=\"423\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-12.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-12-300x202.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>This is our Country Dimension \u201cDimCountry\u201d.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-12.jpg\" rel=\"attachment wp-att-1438\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1438\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-12.jpg\" alt=\"4\" width=\"628\" height=\"187\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-12.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-12-300x89.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>After doing this Save the dimension and then go check the Cube and see whether our dimension has changed or not.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-10.jpg\" rel=\"attachment wp-att-1439\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1439\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-10.jpg\" alt=\"5\" width=\"180\" height=\"388\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-10.jpg 180w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-10-139x300.jpg 139w\" sizes=\"(max-width: 180px) 100vw, 180px\" \/><\/a><\/p>\n<p>Then go to Dimension Usage tab and define the relationship.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-7.jpg\" rel=\"attachment wp-att-1440\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1440\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-7.jpg\" alt=\"6\" width=\"628\" height=\"276\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-7.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-7-300x132.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>Here as in above image we will select \u201cAreaId\u201d for Intermediate dimension attribute. As soon as we do this, do Ctrl S and then process the cube.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-5.jpg\" rel=\"attachment wp-att-1441\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1441\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-5.jpg\" alt=\"7\" width=\"627\" height=\"364\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-5.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-5-300x174.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>And finally at the end you will see CUBE process status at bottom which is executed successfully.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: The error occurred while defining an intermediate relationship between Fact and Dimension. The error says that it cannot find the attribute key \u201cArea Id\u201d. Now in a referenced relationship a dimension table is not directly connected to the Fact &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1434\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[106],"tags":[169,14,109,108,120,105],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Intermediate relationship between Fact and Dimension - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stepbystepschools.net\/?p=1434\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intermediate relationship between Fact and Dimension - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"Error: The error occurred while defining an intermediate relationship between Fact and Dimension. The error says that it cannot find the attribute key \u201cArea Id\u201d. Now in a referenced relationship a dimension table is not directly connected to the Fact &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1434\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-23T08:17:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"StepByStepSchoolsSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1434#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1434#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1434\",\"name\":\"Intermediate relationship between Fact and Dimension - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1434#primaryimage\"},\"datePublished\":\"2017-01-23T08:17:52+00:00\",\"dateModified\":\"2017-01-23T08:17:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1434#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1434\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1434#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intermediate relationship between Fact and Dimension\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\",\"name\":\"StepByStepSchoolsSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"caption\":\"StepByStepSchoolsSupport\"},\"url\":\"https:\/\/www.stepbystepschools.net\/?author=40\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intermediate relationship between Fact and Dimension - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stepbystepschools.net\/?p=1434","og_locale":"en_US","og_type":"article","og_title":"Intermediate relationship between Fact and Dimension - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"Error: The error occurred while defining an intermediate relationship between Fact and Dimension. The error says that it cannot find the attribute key \u201cArea Id\u201d. Now in a referenced relationship a dimension table is not directly connected to the Fact &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1434","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2017-01-23T08:17:52+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/?p=1434#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-13.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1434#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1434","name":"Intermediate relationship between Fact and Dimension - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1434#primaryimage"},"datePublished":"2017-01-23T08:17:52+00:00","dateModified":"2017-01-23T08:17:52+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1434#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1434"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1434#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Intermediate relationship between Fact and Dimension"}]},{"@type":"Person","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655","name":"StepByStepSchoolsSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","caption":"StepByStepSchoolsSupport"},"url":"https:\/\/www.stepbystepschools.net\/?author=40"}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1434"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1434"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1434\/revisions"}],"predecessor-version":[{"id":1442,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1434\/revisions\/1442"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}