{"id":33352,"date":"2021-01-20T12:06:20","date_gmt":"2021-01-20T12:06:20","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=33352"},"modified":"2021-01-20T12:06:21","modified_gmt":"2021-01-20T12:06:21","slug":"overview-of-role-playing-dimension","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/","title":{"rendered":"Overview of Role-Playing Dimension"},"content":{"rendered":"\n<p>You may define a\u00a0role-playing dimension\u00a0as a dimension used to filter related facts differently. Moreover, in a data warehouse, the accepted design approach is used to define a single date dimension table. Moreover, at query time, the &#8220;role&#8221; of the date dimension is being established by the fact column you use to join the tables. <\/p>\n\n\n\n<p>We may imitate the design by creating multiple relationships between two tables, in a Power BI model. Moreover, while this design is possible to achieve, it&#8217;s equally essential to understand that there can only be one active relationship between two Power BI model tables. Further, all other relationships must be set to inactive mode. <\/p>\n\n\n\n<p>However, the only way to use an inactive relationship is to define a DAX expression that uses the\u00a0USERELATIONSHIP function. But, this work can be tedious, especially when the reseller table defines many measures. It also creates\u00a0<strong>Fields<\/strong>\u00a0pane clutter, with an overabundance of measures. <\/p>\n\n\n\n<p>Some of the limitations in a role-playing dimension <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly,  when report authors are dependent on summarizing columns, rather than defining measures, they can&#8217;t achieve summarization for the inactive relationships without writing a report-level measure. <\/li><li>Secondly, report-level measures can only be defined when authoring reports in Power BI Desktop.<\/li><li>Thirdly, with only one active relationship path between date and reseller sales, it is not suggested to simultaneously filter reseller sales by different types of dates. <\/li><\/ul>\n\n\n\n<p>For overcoming these shortcomings, one of the most commonly used Power BI modeling technique is to create a dimension-type table for each role-playing instance. In general, you can create additional dimension tables as\u00a0calculated tables, using DAX. By using calculated tables, the model can contain a\u00a0<strong>Date<\/strong>\u00a0table, a\u00a0<strong>Ship Date<\/strong>\u00a0table and a\u00a0<strong>Delivery Date<\/strong>\u00a0table, each with a single and active relationship to their respective reseller sales table columns.<\/p>\n\n\n\n<p>However, the design approach doesn&#8217;t require you to define multiple measures for different date roles, plus it permits simultaneous filtering by different date roles. However, the use of design approach leads to duplication of the date dimension table resulting in an increased model storage size. In general, dimension-type tables store fewer rows relative to fact-type tables.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Best design practices when creating model dimension-type tables for each role<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, ensure that the column names are self-describing. <\/li><li>Secondly, when required, ensure table descriptions provide feedback to report authors (through\u00a0<strong>Fields<\/strong>\u00a0pane tooltips) about how filter propagation is configured. <\/li><li>Further, it is important when the model contains a generically named table, like\u00a0<strong>Date<\/strong>, which is used to filter many fact-type tables. <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>You may define a\u00a0role-playing dimension\u00a0as a dimension used to filter related facts differently. Moreover, in a data warehouse, the accepted design approach is used to define a single date dimension table. Moreover, at query time, the &#8220;role&#8221; of the date dimension is being established by the fact column you use to join the tables. We&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[3955,3954,4123],"class_list":["post-33352","page","type-page","status-publish","hentry","category-microsoft-azure","tag-microsoft-exam-da-100-exam-questions","tag-microsoft-exam-da-100-free-practice-test","tag-role-playing-dimension"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Overview of Role-Playing Dimension - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn about role-playing dimension with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\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.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Overview of Role-Playing Dimension - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn about role-playing dimension with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-20T12:06:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/\",\"name\":\"Overview of Role-Playing Dimension - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-20T12:06:20+00:00\",\"dateModified\":\"2021-01-20T12:06:21+00:00\",\"description\":\"Learn about role-playing dimension with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overview of Role-Playing Dimension\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overview of Role-Playing Dimension - Testprep Training Tutorials","description":"Learn about role-playing dimension with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","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.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/","og_locale":"en_US","og_type":"article","og_title":"Overview of Role-Playing Dimension - Testprep Training Tutorials","og_description":"Learn about role-playing dimension with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-20T12:06:21+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/","name":"Overview of Role-Playing Dimension - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-20T12:06:20+00:00","dateModified":"2021-01-20T12:06:21+00:00","description":"Learn about role-playing dimension with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Overview of Role-Playing Dimension"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=33352"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33352\/revisions"}],"predecessor-version":[{"id":33359,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33352\/revisions\/33359"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=33352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=33352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=33352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}