{"id":3381,"date":"2023-04-12T15:32:53","date_gmt":"2023-04-12T15:32:53","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/"},"modified":"2026-01-16T16:57:53","modified_gmt":"2026-01-16T16:57:53","slug":"maintaining-paw-hierarchies-with-turbointegrator","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/","title":{"rendered":"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)?"},"content":{"rendered":"<p>In a previous article, we reviewed how to manually create Planning Analytics Workspace (PAW) hierarchies based on attributes. This allows you to create \u201cvirtual dimensions\u201d based on these attributes that can be used for further analysis\u2026but what happens when the attribute values change?<\/p>\n<p>Today, we\u2019ll show you how to use TurboIntegrator (TI) to maintain your hierarchies, so that you can be sure that you are always looking at the most updated information, even when attribute values change.<\/p>\n<p>We\u2019ll use four of the new hierarchy-related TI functions in this exercise:<\/p>\n<p>1. HierarchyExists (to check if the hierarchy exists)<br \/>\n2. HierarchyDestroy (to destroy it if it exists)<br \/>\n3. CreateHierarchyFromAttribute (to create the hierarchy based on an attribute)<br \/>\n4. HierarchySortOrder (to sort the hierarchy)<\/p>\n<p>We can create a generic process using parameters for the dimension and hierarchy that can be used to update any hierarchy in our model. We\u2019ll use the following code in the Prolog procedure of our process for this example:<\/p>\n<pre># Delete Hierarchy if it Exists\r\nIF(HierarchyExists(pDim,pHier)=1);\r\nHierarchyDestroy(pDim,pHier);\r\nEndIF;\r\n\r\n# Create Hierarchy from Attribute\r\nCreateHierarchyByAttribute(pDim,pHier,'Unassigned '|pHier,'All '|pHier);\r\n\r\n# Sort the Hierarchy\r\nHierarchySortOrder( pDim, pHier, 'ByName', 'Ascending', 'ByHierarchy', 'Ascending' );<\/pre>\n<p>Watch the short video below to see how it\u2019s done and stay tuned for more articles on this powerful new feature in PAW!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-538 size-full\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/HierarchyTI-1.gif\" alt=\"\" width=\"1920\" height=\"1080\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a previous article, we reviewed how to manually create Planning Analytics Workspace (PAW) hierarchies based on attributes. This allows you to create \u201cvirtual dimensions\u201d based on these attributes that can be used for further analysis\u2026but what happens when the attribute values change? Today, we\u2019ll show you how to use TurboIntegrator (TI) to maintain your&hellip;<\/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":[24],"tags":[43,36,49],"class_list":["post-3381","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-administration","tag-planning-analytics","tag-planning-analytics-administration"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)? - 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\/maintaining-paw-hierarchies-with-turbointegrator\/\" \/>\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 TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"In a previous article, we reviewed how to manually create Planning Analytics Workspace (PAW) hierarchies based on attributes. This allows you to create \u201cvirtual dimensions\u201d based on these attributes that can be used for further analysis\u2026but what happens when the attribute values change? Today, we\u2019ll show you how to use TurboIntegrator (TI) to maintain your&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T16:57:53+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\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)?\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T16:57:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/\"},\"wordCount\":200,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/HierarchyTI-1.gif\",\"keywords\":[\"Administration\",\"Planning Analytics\",\"Planning Analytics Administration\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/\",\"name\":\"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/HierarchyTI-1.gif\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T16:57:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/HierarchyTI-1.gif\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/HierarchyTI-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/maintaining-paw-hierarchies-with-turbointegrator\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)?\"}]},{\"@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 TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)? - 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\/maintaining-paw-hierarchies-with-turbointegrator\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)? - QueBIT","og_description":"In a previous article, we reviewed how to manually create Planning Analytics Workspace (PAW) hierarchies based on attributes. This allows you to create \u201cvirtual dimensions\u201d based on these attributes that can be used for further analysis\u2026but what happens when the attribute values change? Today, we\u2019ll show you how to use TurboIntegrator (TI) to maintain your&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:53+00:00","article_modified_time":"2026-01-16T16:57:53+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\/maintaining-paw-hierarchies-with-turbointegrator\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)?","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T16:57:53+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/"},"wordCount":200,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/HierarchyTI-1.gif","keywords":["Administration","Planning Analytics","Planning Analytics Administration"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/","url":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/","name":"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/HierarchyTI-1.gif","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T16:57:53+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/HierarchyTI-1.gif","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/HierarchyTI-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/maintaining-paw-hierarchies-with-turbointegrator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)?"}]},{"@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\/3381","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=3381"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3381\/revisions"}],"predecessor-version":[{"id":5001,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3381\/revisions\/5001"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}