{"id":3365,"date":"2023-04-12T15:32:48","date_gmt":"2023-04-12T15:32:48","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/"},"modified":"2026-01-20T15:18:04","modified_gmt":"2026-01-20T15:18:04","slug":"writing-c-level-rules","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/","title":{"rendered":"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior?"},"content":{"rendered":"<p>TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-446 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules.jpg\" alt=\"\" width=\"944\" height=\"222\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We can use business rules to pull the last month in the quarter and prevent the natural consolidation. The rule will leverage the \u201cLast Period\u201d attribute that is automatically created and populated when a dimension is customized as a time dimension in PAW.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-445 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules2.jpg\" alt=\"\" width=\"408\" height=\"568\" \/><\/p>\n<p>The rule is shown in the animated GIF below. The PAW rule editor has a handy autocomplete feature that can be enabled by typing SHIFT + SPACE \u2013 that is how the DB statement is automagically populated for our rule.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-443\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/C-level-rule.gif\" alt=\"\" width=\"1852\" height=\"472\" \/><\/p>\n<p>The result is exactly what we are looking for \u2013 the value in Q2 2018 is equal to Jun 2018.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-444\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules3.jpg\" alt=\"\" width=\"927\" height=\"230\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level. &nbsp; We can use business rules to pull the last month in the quarter&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":[35,36,52],"class_list":["post-3365","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-development","tag-planning-analytics","tag-planning-analytics-development"],"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 Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior? - 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\/writing-c-level-rules\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level. &nbsp; We can use business rules to pull the last month in the quarter&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T15:18:04+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\\\/writing-c-level-rules\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior?\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2026-01-20T15:18:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/\"},\"wordCount\":154,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Crules.jpg\",\"keywords\":[\"Development\",\"Planning Analytics\",\"Planning Analytics Development\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/\",\"name\":\"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Crules.jpg\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2026-01-20T15:18:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Crules.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Crules.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/writing-c-level-rules\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior?\"}]},{\"@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 Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior? - 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\/writing-c-level-rules\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior? - QueBIT","og_description":"TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level. &nbsp; We can use business rules to pull the last month in the quarter&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:48+00:00","article_modified_time":"2026-01-20T15:18:04+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\/writing-c-level-rules\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior?","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2026-01-20T15:18:04+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/"},"wordCount":154,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules.jpg","keywords":["Development","Planning Analytics","Planning Analytics Development"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/","url":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/","name":"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules.jpg","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2026-01-20T15:18:04+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Crules.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/writing-c-level-rules\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior?"}]},{"@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\/3365","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=3365"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3365\/revisions"}],"predecessor-version":[{"id":5039,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3365\/revisions\/5039"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}