{"id":3499,"date":"2023-04-12T15:37:04","date_gmt":"2023-04-12T15:37:04","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/"},"modified":"2026-01-22T17:44:59","modified_gmt":"2026-01-22T17:44:59","slug":"maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/","title":{"rendered":"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME?"},"content":{"rendered":"

As with most technologies, there are usually multiple ways to accomplish the same task.\u00a0 When performing dimension and\/or attribute maintenance, the first step is to quantify the number of changes that need to be made.\u00a0 If you have 1 or 2 minor changes, then updating the structures manually might be a good way to go.\u00a0 However, if your list is more substantial, you may want to consider using the IMPORT method.<\/p>\n

Within the Modeling menu, there are two separate links for Dimensions and Dimension Attributes, each containing their own methods for manually maintaining or importing elements and structures.\u00a0 But, why not save some time and maintain them BOTH in one fell swoop?<\/p>\n

In this article, we will demonstrate how you can do just that by maintaining and importing your Dimension and associated \u201ctagged\u201d Attributes in a single template.<\/p>\n

*Note: This example assumes that you are working with a LIST type dimension and that the ATTRIBUTE has already been created.<\/em><\/span><\/p>\n

\n

In Adaptive Planning<\/a>, you can TAG your dimension elements with Attributes, allowing you to produce alternate hierarchies to categorize your data, and add filters to your cube sheets, reports and charts.<\/p>\n

In this example, we will be looking at the STATE <\/strong>dimension and the SALES REGION<\/strong> attributes.<\/p>\n

From the main menu, navigate to MODELING<\/strong><\/p>\n

\"\"<\/p>\n

Select Dimension Attributes<\/p>\n

\"\"<\/p>\n

Ensure that the check box to automatically create values is checked.\u00a0 For example, lets assume that the only two Sales Region attribute Values<\/strong> we currently have setup are \u201cSoutheast\u201d and \u201cWest\u201d.\u00a0 By checking this box, you can assign other regions like \u201cNortheast\u201d and \u201cCentral\u201d in your import file and they will automatically be added to the attribute structure AND assigned as dimension tags upon import.<\/p>\n

\"\"<\/p>\n

Next, from the Modeling menu, select DIMENSIONS<\/strong><\/p>\n

\"\"<\/p>\n

To be sure you are starting with the most recent existing structures, you should generate a printable view<\/strong>, which will download all<\/u> Dimension structures and their associated settings and Attributes.<\/p>\n

\"\"<\/p>\n

The printable view should look something like this.\u00a0 Notice the Sales Region column.\u00a0 It appears that someone (oops, it was me) made a mistake during the last import and accidentally copied the \u201cSoutheast\u201d region value to multiple states in error.<\/p>\n

You have a few options.<\/p>\n

    \n
  1. Correct the attribute tags manually (yawn).<\/li>\n
  2. You can simply fix it directly on the Printable View template, and re-import\/update the values. (yay!)
    \n\"\"<\/li>\n
  3. You can download a Dimension template and fix it there. (another yay!)<\/li>\n<\/ol>\n

    I\u2019ll choose option 3 to illustrate how to populate the dimension import template.<\/p>\n

    From the Dimensions screen, select IMPORT DIMENSION STRUCTURE<\/strong><\/p>\n

    Download the IMPORT<\/strong> template<\/p>\n

    \"\"<\/p>\n

    Open the template and note the INSTRUCTIONS<\/strong> tab for detailed instructions.<\/p>\n

    \"\"<\/p>\n

    On the DIMENSIONS<\/strong> tab, you can maintain both<\/strong> Dimension values and settings, as well as Attributes.\u00a0 In this case, we just want to correct our attributes assignments.\u00a0 To do this, FIRST insert the attribute column at the end and label it as the name of the Attribute you want to maintain, \u201cSales Region<\/strong>\u201d.\u00a0 NEXT, populate the template with the information obtained from the Printable View (Dimension Name, Dimension Value and Sales Region, etc.).\u00a0 FINALLY, correct the Attributes as necessary.<\/p>\n

    \"\"<\/p>\n

    From the Dimensions screen, click IMPORT DIMENSION STRUCTURE<\/strong> and CHOOSE FILE to select the Dimensions.xlsx template. \u00a0\u00a0Be sure to select the appropriate Import operation (select UPDATE in this case since we are not adding new dimension elements).\u00a0\u00a0\u00a0 Click UPLOAD.<\/strong><\/p>\n

    \"\"<\/p>\n

    Verify that the dimension elements were TAGGED with the appropriate new or corrected ATTRIBUTE Values, either by generating another Printable View, or by going to the DIMENSIONS screen.\u00a0 Notice the STATE ATTRIBUTES at the bottom right of the Dimensions screen.<\/p>\n

    \"\"<\/p>\n

    And, Voila!\u00a0 You\u2019re done!<\/p>\n

    We hope you found this article helpful. Don\u2019t hesitate to \u201cAsk QueBIT\u201d if you have additional questions or feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"

    As with most technologies, there are usually multiple ways to accomplish the same task.\u00a0 When performing dimension and\/or attribute maintenance, the first step is to quantify the number of changes that need to be made.\u00a0 If you have 1 or 2 minor changes, then updating the structures manually might be a good way to go.\u00a0…<\/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":[35,69,54],"class_list":["post-3499","post","type-post","status-publish","format-standard","hentry","category-workday-adaptive-planning","tag-development","tag-workday-adaptive-planning","tag-workday-adaptive-planning-development"],"acf":[],"yoast_head":"\nHow do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME? - 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\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"As with most technologies, there are usually multiple ways to accomplish the same task.\u00a0 When performing dimension and\/or attribute maintenance, the first step is to quantify the number of changes that need to be made.\u00a0 If you have 1 or 2 minor changes, then updating the structures manually might be a good way to go.\u00a0…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:37:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-22T17:44:59+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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME?\",\"datePublished\":\"2023-04-12T15:37:04+00:00\",\"dateModified\":\"2026-01-22T17:44:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/\"},\"wordCount\":632,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Modeling-1-min.jpg\",\"keywords\":[\"Development\",\"Workday Adaptive Planning\",\"Workday Adaptive Planning Development\"],\"articleSection\":[\"Workday Adaptive Planning\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/\",\"name\":\"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Modeling-1-min.jpg\",\"datePublished\":\"2023-04-12T15:37:04+00:00\",\"dateModified\":\"2026-01-22T17:44:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Modeling-1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/Modeling-1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME?\"}]},{\"@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 maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME? - 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\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/","og_locale":"en_US","og_type":"article","og_title":"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME? - QueBIT","og_description":"As with most technologies, there are usually multiple ways to accomplish the same task.\u00a0 When performing dimension and\/or attribute maintenance, the first step is to quantify the number of changes that need to be made.\u00a0 If you have 1 or 2 minor changes, then updating the structures manually might be a good way to go.\u00a0…","og_url":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:37:04+00:00","article_modified_time":"2026-01-22T17:44:59+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME?","datePublished":"2023-04-12T15:37:04+00:00","dateModified":"2026-01-22T17:44:59+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/"},"wordCount":632,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/06\/Modeling-1-min.jpg","keywords":["Development","Workday Adaptive Planning","Workday Adaptive Planning Development"],"articleSection":["Workday Adaptive Planning"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/","url":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/","name":"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/06\/Modeling-1-min.jpg","datePublished":"2023-04-12T15:37:04+00:00","dateModified":"2026-01-22T17:44:59+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/06\/Modeling-1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/06\/Modeling-1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/maintain-your-dimensions-and-attributes-at-the-same-time-to-save-time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How do I maintain your DIMENSIONS and ATTRIBUTES at the SAME TIME to SAVE TIME?"}]},{"@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\/3499","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=3499"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3499\/revisions"}],"predecessor-version":[{"id":5141,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3499\/revisions\/5141"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}