{"id":3918,"date":"2023-05-22T13:06:36","date_gmt":"2023-05-22T13:06:36","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=3918"},"modified":"2023-05-22T13:11:43","modified_gmt":"2023-05-22T13:11:43","slug":"planning-analytics-and-object-permanence-2","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/","title":{"rendered":"Planning Analytics and Object Permanence"},"content":{"rendered":"<p><strong>Planning Analytics and Object Permanence<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong><u>Object Permanence <\/u><\/strong>is \u201cthe understanding that objects continue to exist even when they cannot be sensed; a fundamental concept studied in the field of developmental psychology, the subfield of psychology that addresses the development of young children&#8217;s social and mental capacities\u201d (wikipedia.org).<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Does <\/strong><strong>How does this relate to Planning Analytics?<\/strong><\/p>\n<p>In every Planning Analytics model\u2019s lifespan, new objects are continually added, and typically existing objects are not always decommissioned. This means that the total number of objects increases while some objects continue to consume valuable resources while not adding value\u00a0 (since they are not or seldom used).\u00a0 In other words, you\u2019ll have <em>objects continuing to exist while not<\/em> \u201csensed\u201d (not used and therefore not adding value to the model) \u2013 not very economical.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Taking a baseline <\/strong><\/p>\n<p>To remedy this situation, start by establishing a baseline. A <strong>baseline<\/strong> is an initial measurement of a condition that is taken at a specific point in time to be used for comparison over time looking for variations. In our case, we want to establish some baseline facts such as the <u>total memory footprint <\/u>of the model and perhaps the time it takes for the <u>server to start up<\/u> (without the aid of <a href=\"https:\/\/www.ibm.com\/docs\/en\/planning-analytics\/2.0.0?topic=configuration-persistent-feeders\">persistent feeders<\/a>). These data points (and others) can be useful as \u201cmeasurable results\u201d to gauge the effect of any object decommissioning you do.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Identify the Usual Suspects<\/strong><\/p>\n<p>In <em>horticulture<\/em> there exists the practice of regularly pruning plants so as to stimulate new growth as well as maintain the health of the plant. You may refer to what is known as the \u201c 1\/3 pruning rule\u201d which involves cutting about 1\/3 of wood during any pruning activity. This moderate pruning practice is a balanced approach to thinning out shrubs to stimulate new growth. The plant loses a good number of stems, usually in the top section, allowing more light and air to enter the inside of the plant.<\/p>\n<p>&nbsp;<\/p>\n<p>While I don\u2019t advise looking to remove 1\/3 of your planning analytics model objects, I <em>would<\/em> recommend being aggressive with your cleanup (backups first of course!). To that point, I suggest beginning by creating a \u201cprofile\u201d of your model to guide your pruning, including:<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>The total number of cubes (including \u201c}\u201d control cubes) in the model \u2013 then sort them by purpose: input, calculation, reporting, support or control. Do you have a \u201chigher count\u201d of a certain type of cube?<\/li>\n<li>What are the largest cubes within the model and what is the average cube size? What is the highest number of dimensions (in any single cube)? Are there a number of cube sizes above the model\u2019s average? There is an optimal number of dimensions any cube should have and going above that number may affect performance.<\/li>\n<li>The total number of dimensions (including \u201c}\u201d control dimensions) in the model<\/li>\n<li>What is the largest number of elements (in a single dimension) and what is the average dimension size? Could a larger dimension be aggregated with detail data available in an alternative cube and available as a drill-through?<\/li>\n<li>The total number of processes (including \u201c}\u201d control processes) in the model and what is the \u201ccube to process\u201d ratio? Processes have a way of multiplying as requirements change and are especially difficult to sort if naming conventions have not been followed or have changed over time.<\/li>\n<\/ul>\n<p><strong>Make it an Obsession<\/strong><\/p>\n<p>A common belief is that all \u201cobsessions\u201d proceed through four stages in the same order: cue, craving, response, and reward. In a planning analytics example, you might consider the following:<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>The <strong>cue<\/strong> \u2013 perhaps a date on a calendar (an end of quarter?) or a memory consumption threshold. This causes you to notice the need for a \u201ccleanup\u201d.<\/li>\n<li>The <strong>craving<\/strong> \u2013 this should be an agreed upon objective, such as an <em>optimal memory footprint<\/em> or acceptable <em>server restart time<\/em>; \u201cwe want a healthy, sustainable planning analytics model\u201d.<\/li>\n<li>The <strong>response<\/strong> \u2013 an actionable plan (setting a baseline, reviewing model statistics and pruning and\/or decommissioning objects).<\/li>\n<li>And the <strong>reward<\/strong> \u2013 this is your happy, healthy and sustainable planning analytics model!<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>I would highly recommend adopting a process (and yes, even making it an obsession) of routinely inspecting each planning analytics model for objects that can be reduced in size or \u201cpruned\u201d completely out of the model. This practice will support server stability, promote faster startup times as well as (potentially) \u00a0improve server performance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Planning Analytics and Object Permanence \u00a0 Object Permanence is \u201cthe understanding that objects continue to exist even when they cannot be sensed; a fundamental concept studied in the field of developmental psychology, the subfield of psychology that addresses the development of young children&#8217;s social and mental capacities\u201d (wikipedia.org). &nbsp; Does How does this relate to&hellip;<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[77,78,79,76,36],"class_list":["post-3918","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-ibm","tag-object-permanence","tag-objects","tag-pa","tag-planning-analytics"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Planning Analytics and Object Permanence - 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\/planning-analytics-and-object-permanence-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Planning Analytics and Object Permanence - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Planning Analytics and Object Permanence \u00a0 Object Permanence is \u201cthe understanding that objects continue to exist even when they cannot be sensed; a fundamental concept studied in the field of developmental psychology, the subfield of psychology that addresses the development of young children&#8217;s social and mental capacities\u201d (wikipedia.org). &nbsp; Does How does this relate to&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-22T13:06:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-22T13:11:43+00:00\" \/>\n<meta name=\"author\" content=\"Patrick Quirke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Patrick Quirke\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/\"},\"author\":{\"name\":\"Patrick Quirke\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/51bf83d531948247370683787d0f46ff\"},\"headline\":\"Planning Analytics and Object Permanence\",\"datePublished\":\"2023-05-22T13:06:36+00:00\",\"dateModified\":\"2023-05-22T13:11:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/\"},\"wordCount\":734,\"commentCount\":0,\"keywords\":[\"IBM\",\"Object Permanence\",\"Objects\",\"PA\",\"Planning Analytics\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/\",\"name\":\"Planning Analytics and Object Permanence - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"datePublished\":\"2023-05-22T13:06:36+00:00\",\"dateModified\":\"2023-05-22T13:11:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/51bf83d531948247370683787d0f46ff\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-object-permanence-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Planning Analytics and Object Permanence\"}]},{\"@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\\\/51bf83d531948247370683787d0f46ff\",\"name\":\"Patrick Quirke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g\",\"caption\":\"Patrick Quirke\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/pquirke\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Planning Analytics and Object Permanence - 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\/planning-analytics-and-object-permanence-2\/","og_locale":"en_US","og_type":"article","og_title":"Planning Analytics and Object Permanence - QueBIT","og_description":"Planning Analytics and Object Permanence \u00a0 Object Permanence is \u201cthe understanding that objects continue to exist even when they cannot be sensed; a fundamental concept studied in the field of developmental psychology, the subfield of psychology that addresses the development of young children&#8217;s social and mental capacities\u201d (wikipedia.org). &nbsp; Does How does this relate to&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/","og_site_name":"QueBIT","article_published_time":"2023-05-22T13:06:36+00:00","article_modified_time":"2023-05-22T13:11:43+00:00","author":"Patrick Quirke","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Patrick Quirke","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/"},"author":{"name":"Patrick Quirke","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/51bf83d531948247370683787d0f46ff"},"headline":"Planning Analytics and Object Permanence","datePublished":"2023-05-22T13:06:36+00:00","dateModified":"2023-05-22T13:11:43+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/"},"wordCount":734,"commentCount":0,"keywords":["IBM","Object Permanence","Objects","PA","Planning Analytics"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/","url":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/","name":"Planning Analytics and Object Permanence - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"datePublished":"2023-05-22T13:06:36+00:00","dateModified":"2023-05-22T13:11:43+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/51bf83d531948247370683787d0f46ff"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-object-permanence-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"Planning Analytics and Object Permanence"}]},{"@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\/51bf83d531948247370683787d0f46ff","name":"Patrick Quirke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g","caption":"Patrick Quirke"},"sameAs":["https:\/\/quebit.com\/askquebit\/"],"url":"https:\/\/quebit.com\/askquebit\/author\/pquirke\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3918","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3918"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3918\/revisions"}],"predecessor-version":[{"id":3933,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3918\/revisions\/3933"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}