{"id":3521,"date":"2023-04-12T15:37:08","date_gmt":"2023-04-12T15:37:08","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/"},"modified":"2026-01-22T17:34:45","modified_gmt":"2026-01-22T17:34:45","slug":"workday-adaptive-planning-derived-dimensions","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/","title":{"rendered":"How do I use derived dimensions in Workday Adaptive Planning?"},"content":{"rendered":"

Among the many new features presented in the 2020R2 release is the concept of derived dimension values.\u00a0 This applies only to Modeled Sheets with no splits and grants planners the flexibility to make dimension values conditional upon other dimension values for each record.<\/p>\n

\"\"<\/p>\n

So how does it work?<\/strong> Navigate to Dimensions in Model Management, select the desired dimension to be derived and check off the new setting Use mapping criteria to set dimension value on modeled sheets<\/em>.\u00a0 Add up to six dimension that will be used to determine the derived dimension value.<\/p>\n

Initial mapping setup is simple, just like all other manual inputs in Workday Adaptive Planning an input template is available for download to Excel.\u00a0 Once a dimension is marked as a derived dimension a More Actions arrow appears next to the Import dimension structure icon in the top ribbon, providing the option to Import Dimension Mapping.<\/em><\/p>\n

\"\"Combinations of dimension values used to derive another dimension value are version and level specific.\u00a0 This allows for maximum flexibility and what if scenarios.\u00a0 Maintaining these mappings can be done by generating printable views and reimporting, or by directly updating them on a dashboard.\u00a0 Dashboards now have a chart option called Dimension Mapping<\/em>.<\/p>\n

\"\"<\/p>\n

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

Among the many new features presented in the 2020R2 release is the concept of derived dimension values.\u00a0 This applies only to Modeled Sheets with no splits and grants planners the flexibility to make dimension values conditional upon other dimension values for each record. So how does it work? Navigate to Dimensions in Model Management, select…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[23],"tags":[43,69,62],"class_list":["post-3521","post","type-post","status-publish","format-standard","hentry","category-workday-adaptive-planning","tag-administration","tag-workday-adaptive-planning","tag-workday-adaptive-planning-administration"],"acf":[],"yoast_head":"\nHow do I use derived dimensions in Workday Adaptive Planning? - QueBIT<\/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:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I use derived dimensions in Workday Adaptive Planning? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Among the many new features presented in the 2020R2 release is the concept of derived dimension values.\u00a0 This applies only to Modeled Sheets with no splits and grants planners the flexibility to make dimension values conditional upon other dimension values for each record. So how does it work? Navigate to Dimensions in Model Management, select…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:37:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-22T17:34:45+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How do I use derived dimensions in Workday Adaptive Planning?\",\"datePublished\":\"2023-04-12T15:37:08+00:00\",\"dateModified\":\"2026-01-22T17:34:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/\"},\"wordCount\":212,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/dd1-239x300.png\",\"keywords\":[\"Administration\",\"Workday Adaptive Planning\",\"Workday Adaptive Planning Administration\"],\"articleSection\":[\"Workday Adaptive Planning\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/\",\"name\":\"How do I use derived dimensions in Workday Adaptive Planning? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/dd1-239x300.png\",\"datePublished\":\"2023-04-12T15:37:08+00:00\",\"dateModified\":\"2026-01-22T17:34:45+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/dd1-239x300.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/dd1-239x300.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/workday-adaptive-planning-derived-dimensions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I use derived dimensions in Workday Adaptive Planning?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How do I use derived dimensions in Workday Adaptive Planning? - QueBIT","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:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/","og_locale":"en_US","og_type":"article","og_title":"How do I use derived dimensions in Workday Adaptive Planning? - QueBIT","og_description":"Among the many new features presented in the 2020R2 release is the concept of derived dimension values.\u00a0 This applies only to Modeled Sheets with no splits and grants planners the flexibility to make dimension values conditional upon other dimension values for each record. So how does it work? Navigate to Dimensions in Model Management, select…","og_url":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:37:08+00:00","article_modified_time":"2026-01-22T17:34:45+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How do I use derived dimensions in Workday Adaptive Planning?","datePublished":"2023-04-12T15:37:08+00:00","dateModified":"2026-01-22T17:34:45+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/"},"wordCount":212,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/10\/dd1-239x300.png","keywords":["Administration","Workday Adaptive Planning","Workday Adaptive Planning Administration"],"articleSection":["Workday Adaptive Planning"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/","url":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/","name":"How do I use derived dimensions in Workday Adaptive Planning? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/10\/dd1-239x300.png","datePublished":"2023-04-12T15:37:08+00:00","dateModified":"2026-01-22T17:34:45+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/10\/dd1-239x300.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/10\/dd1-239x300.png"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/workday-adaptive-planning-derived-dimensions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How do I use derived dimensions in Workday Adaptive Planning?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3521"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3521\/revisions"}],"predecessor-version":[{"id":5132,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3521\/revisions\/5132"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}