{"id":3497,"date":"2023-04-12T15:33:27","date_gmt":"2023-04-12T15:33:27","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/"},"modified":"2026-01-16T15:51:03","modified_gmt":"2026-01-16T15:51:03","slug":"planning-analytics-and-transaction-log-management","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/","title":{"rendered":"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance?"},"content":{"rendered":"<p><strong>Planning Analytics and Transaction Log Management <\/strong><\/p>\n<p>If you are responsible for administrating IBM Planning Analytics, then the <a href=\"https:\/\/www.ibm.com\/docs\/en\/planning-analytics\/2.0.0?topic=logs-transactions-log\">transaction log<\/a> most likely has been queried regularly in an attempt to identify data changes (for example date and time of a change and name of the client that made the change) and \u2013 most Likely &#8211; the transaction log queries took hours to run, caused intermittent locking, and most of the time even yielded no results!<\/p>\n<p>If that is the case, then implementing a method of managing Planning Analytics server transaction logs is highly recommended.<\/p>\n<p>The objectives of transaction log management should be to:<\/p>\n<ul>\n<li>Limit transaction record creation to only specific cubes and only during relevant timespans<\/li>\n<li>Reduce the volume of the transactions logs by purging irrelevant data and expiring logs<\/li>\n<li>Consider performing transactional log searching external to Planning Analytics<\/li>\n<li>Explore configuring the transactional log search behavior<\/li>\n<\/ul>\n<p><strong>Limit Transaction Record Creation<\/strong><\/p>\n<p>Transaction logging can be enabled and disabled for specific cubes by setting the LOGGING column in the }CubeProperties cube. Transaction logging is typically needed for cube transactions on only selected cubes and during the periods of manual user data entry. Logging should never be enabled during a bulk upload or update. Typically logging should not be enabled on server control cubes or global support cubes accessed only by an administrator. The goal is to \u201ctightly manage\u201d <em>which<\/em> cubes have logging enabled and <em>when<\/em> transaction logging occurs on those cubes. One approach is to disable logging for ALL cubes within the instance and enable and disable logging on relevant cubes as part of an \u201copen (or closed) for user input\u201d set up by an administrator.\u00a0 When deciding on a logging strategy, if you are not using transactions for recovery, being more aggressive about disabling transactional logging makes sense.<\/p>\n<p><strong>Reduce the volume of the Transactions Logs<\/strong><\/p>\n<p>Invalid transaction records can be generated during normal server activity and these invalid records will impact log searches. Generated invalid records should be identified, reviewed, and cleared (from the log files).<\/p>\n<p>In addition,\u00a0 if transaction logging enablement is being properly managed then the overall number of transactions being logged will be much less, reducing volume, if not, then there will be transactions saved on events that you have no interest in. Transactions are also created for a variety of events (other than individual\u00a0 user data changes), such as the \u201cCubeSerialized\u201d event (when a SaveData occurs) or when TurboIntegrator processes are run to modify data, resulting in additional transaction volume.<\/p>\n<p>Having a scheduled process set up to parse or \u201cfilter\u201d out transactions based upon need or other specific requirements can vastly improve the efficiency and value of this data. Lastly, a process should be in place to \u201cexpire\u201d transaction log files which have passed relevancy.<\/p>\n<p><strong>Consider External Transactional Log Searching <\/strong><\/p>\n<p>Downloading and\/or searching transaction logs as an administrator from within Planning Analytics may be slow and cause overall server performance degradation. In addition, the interface isn\u2019t particularly flexible.<\/p>\n<p>Another viable option for searching transactional log data is to utilize an external log searching tool such Splunk or Datadog or more informal \u201cbuild your own\u201d choices such as PowerShell or GREP. Finally, if you are properly managing your transaction log data, this data could be imported and reported on using a Planning Analytics cube and Planning Analytics Workspace.<\/p>\n<p><strong>Explore Configuring the Transactional Log Search<\/strong><\/p>\n<p>In newer versions of Planning Analytics, transactional log search behavior \u2013 such as changing the number of logs to search and the number of invalid logs that are allowed before a search stops &#8211; can be configured to change defaults. Some experimentation with log search behaviors may be required to get an optimal process and you\u2019ll need to get IBM support involved to make these types of changes.<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>Even if you don\u2019t plan to use transactions to restore previous values, transaction log data \u2013 like any data \u2013 needs care and feeding and if properly \u201ccared for\u201d you can use transaction log data to identify trends, understand what drives a particular type of data change within an area of a model, satisfy audit or compliance\u00a0 requirements, offer insight to the status of a workflow and of course use it to determine licensing requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Planning Analytics and Transaction Log Management If you are responsible for administrating IBM Planning Analytics, then the transaction log most likely has been queried regularly in an attempt to identify data changes (for example date and time of a change and name of the client that made the change) and \u2013 most Likely &#8211; the&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-3497","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 Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance? - 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-transaction-log-management\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Planning Analytics and Transaction Log Management If you are responsible for administrating IBM Planning Analytics, then the transaction log most likely has been queried regularly in an attempt to identify data changes (for example date and time of a change and name of the client that made the change) and \u2013 most Likely &#8211; the&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:33:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T15:51:03+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=\"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-transaction-log-management\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance?\",\"datePublished\":\"2023-04-12T15:33:27+00:00\",\"dateModified\":\"2026-01-16T15:51:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/\"},\"wordCount\":716,\"commentCount\":0,\"keywords\":[\"Administration\",\"Planning Analytics\",\"Planning Analytics Administration\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/\",\"name\":\"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"datePublished\":\"2023-04-12T15:33:27+00:00\",\"dateModified\":\"2026-01-16T15:51:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/planning-analytics-and-transaction-log-management\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance?\"}]},{\"@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 Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance? - 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-transaction-log-management\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance? - QueBIT","og_description":"Planning Analytics and Transaction Log Management If you are responsible for administrating IBM Planning Analytics, then the transaction log most likely has been queried regularly in an attempt to identify data changes (for example date and time of a change and name of the client that made the change) and \u2013 most Likely &#8211; the&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:33:27+00:00","article_modified_time":"2026-01-16T15:51:03+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance?","datePublished":"2023-04-12T15:33:27+00:00","dateModified":"2026-01-16T15:51:03+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/"},"wordCount":716,"commentCount":0,"keywords":["Administration","Planning Analytics","Planning Analytics Administration"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/","url":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/","name":"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"datePublished":"2023-04-12T15:33:27+00:00","dateModified":"2026-01-16T15:51:03+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/planning-analytics-and-transaction-log-management\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Manage Transaction Logs in IBM Planning Analytics to Control Logging Volume and Improve Performance?"}]},{"@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\/3497","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=3497"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3497\/revisions"}],"predecessor-version":[{"id":4978,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3497\/revisions\/4978"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}