{"id":1228,"date":"2016-12-30T17:18:22","date_gmt":"2016-12-30T11:48:22","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1228"},"modified":"2016-12-30T17:18:22","modified_gmt":"2016-12-30T11:48:22","slug":"what-happens-when-rdbms-structure-and-ssas-db-structure-are-not-same","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1228","title":{"rendered":"What happens when RDBMS structure and SSAS DB structure are not same?"},"content":{"rendered":"<p>Not all training session are easy with simple error. There are times when typical issue are seen, here we will discuss one such issue recently seen in\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">Mumbai MSBI premise training<\/a> while doing SSAS lab.<\/p>\n<p><b>Issue:<\/b><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg\" rel=\"attachment wp-att-1229\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1229\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg\" alt=\"1\" width=\"628\" height=\"306\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9-300x146.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>The error says that the duplicate attribute key has been found in Country &amp; Product table. This error has encountered because the Country table and Product table does not have any primary keys in RDBMS structure while in SSAS project we have designed our database where we have given primary key to both Country &amp; Product Table.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-8.jpg\" rel=\"attachment wp-att-1230\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1230\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-8.jpg\" alt=\"2\" width=\"628\" height=\"302\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-8.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-8-300x144.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-8.jpg\" rel=\"attachment wp-att-1231\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1231\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-8.jpg\" alt=\"3\" width=\"628\" height=\"186\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-8.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-8-300x89.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>Here we do not see the primary key in the RDBMS.<\/p>\n<p><b>Solution:<\/b><\/p>\n<p>For solving this error first of all we will delete the Country table and Product table from our Data Source view which we have created.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-6.jpg\" rel=\"attachment wp-att-1232\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1232\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-6.jpg\" alt=\"4\" width=\"628\" height=\"207\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-6.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-6-300x99.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>After deleting the tables this is how our Data Source View will look like,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-5.jpg\" rel=\"attachment wp-att-1233\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1233\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-5.jpg\" alt=\"5\" width=\"294\" height=\"205\" \/><\/a><\/p>\n<p>Now go to Country table in our RDBMS and write this query which will give the desired output without any duplicate attribute.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-3.jpg\" rel=\"attachment wp-att-1234\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1234\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-3.jpg\" alt=\"6\" width=\"364\" height=\"333\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-3.jpg 364w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-3-300x274.jpg 300w\" sizes=\"(max-width: 364px) 100vw, 364px\" \/><\/a><\/p>\n<p>Now copy the query and do the following steps,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-3.jpg\" rel=\"attachment wp-att-1235\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1235\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-3.jpg\" alt=\"7\" width=\"504\" height=\"271\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-3.jpg 504w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-3-300x161.jpg 300w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/8-1.jpg\" rel=\"attachment wp-att-1236\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1236\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/8-1.jpg\" alt=\"8\" width=\"578\" height=\"560\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/8-1.jpg 578w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/8-1-300x291.jpg 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/a><\/p>\n<p>Paste the query and the table will be created. In the same way do for Product table,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/9.jpg\" rel=\"attachment wp-att-1237\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1237\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/9.jpg\" alt=\"9\" width=\"357\" height=\"337\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/9.jpg 357w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/9-300x283.jpg 300w\" sizes=\"(max-width: 357px) 100vw, 357px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/10.jpg\" rel=\"attachment wp-att-1238\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1238\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/10.jpg\" alt=\"10\" width=\"504\" height=\"271\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/10.jpg 504w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/10-300x161.jpg 300w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/11.jpg\" rel=\"attachment wp-att-1239\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1239\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/11.jpg\" alt=\"11\" width=\"628\" height=\"617\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/11.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/11-300x295.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>Then set the primary key to both the table and map the relation,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/12.jpg\" rel=\"attachment wp-att-1240\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1240\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/12.jpg\" alt=\"12\" width=\"403\" height=\"179\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/12.jpg 403w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/12-300x133.jpg 300w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/13.jpg\" rel=\"attachment wp-att-1241\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1241\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/13.jpg\" alt=\"13\" width=\"502\" height=\"305\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/13.jpg 502w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/13-300x182.jpg 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/a><\/p>\n<p>After that we will delete the Cube &amp; dimensions and recreate it again (not advised in the production mode).<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/14.jpg\" rel=\"attachment wp-att-1242\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1242\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/14.jpg\" alt=\"14\" width=\"627\" height=\"249\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/14.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/14-300x119.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>Now process this Cube and then do the modifications in all the dimensions by inserting the Name field as we want the analysis to be done by using names and not Id\u2019s.<\/p>\n<p>After doing changes in our Dimensions, again process the Cube and the error are solved.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/15.jpg\" rel=\"attachment wp-att-1243\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1243\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/15.jpg\" alt=\"15\" width=\"627\" height=\"401\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/15.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/15-300x192.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/16.jpg\" rel=\"attachment wp-att-1244\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1244\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/16.jpg\" alt=\"16\" width=\"575\" height=\"181\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/16.jpg 575w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/16-300x94.jpg 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/a><\/p>\n<p>Here we can see the Analysis done by name and not Id\u2019s.<\/p>\n<p>More the error and issue faced during practice\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI classroom sessions<br \/>\n<\/a>becomes interesting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Not all training session are easy with simple error. There are times when typical issue are seen, here we will discuss one such issue recently seen in\u00a0Mumbai MSBI premise training while doing SSAS lab. Issue: The error says that the &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1228\">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":[121,14,134,136,137],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What happens when RDBMS structure and SSAS DB structure are not same? - 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=1228\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What happens when RDBMS structure and SSAS DB structure are not same? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"Not all training session are easy with simple error. There are times when typical issue are seen, here we will discuss one such issue recently seen in\u00a0Mumbai MSBI premise training while doing SSAS lab. Issue: The error says that the &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1228\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-30T11:48:22+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.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=\"1 minute\" \/>\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=1228#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1228#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1228\",\"name\":\"What happens when RDBMS structure and SSAS DB structure are not same? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1228#primaryimage\"},\"datePublished\":\"2016-12-30T11:48:22+00:00\",\"dateModified\":\"2016-12-30T11:48:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1228#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1228\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1228#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What happens when RDBMS structure and SSAS DB structure are not same?\"}]},{\"@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":"What happens when RDBMS structure and SSAS DB structure are not same? - 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=1228","og_locale":"en_US","og_type":"article","og_title":"What happens when RDBMS structure and SSAS DB structure are not same? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"Not all training session are easy with simple error. There are times when typical issue are seen, here we will discuss one such issue recently seen in\u00a0Mumbai MSBI premise training while doing SSAS lab. Issue: The error says that the &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1228","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2016-12-30T11:48:22+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"1 minute"},"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=1228#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-9.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1228#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1228","name":"What happens when RDBMS structure and SSAS DB structure are not same? - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1228#primaryimage"},"datePublished":"2016-12-30T11:48:22+00:00","dateModified":"2016-12-30T11:48:22+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1228#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1228"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1228#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"What happens when RDBMS structure and SSAS DB structure are not same?"}]},{"@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\/1228"}],"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=1228"}],"version-history":[{"count":2,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1228\/revisions"}],"predecessor-version":[{"id":1246,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1228\/revisions\/1246"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}