{"id":20671,"date":"2026-07-15T08:42:17","date_gmt":"2026-07-15T08:42:17","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20671"},"modified":"2026-10-22T05:45:47","modified_gmt":"2026-10-22T05:45:47","slug":"how-to-use-recalculate-cube-process-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-use-recalculate-cube-process-in-idempiere\/","title":{"rendered":"How to use Recalculate Cube process in iDempiere"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Introduction<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Recalculate Cube is a background process window in iDempiere that rebuilds summarized accounting facts stored in the Fact_Acct_Summary table based on the dimensions defined in a Report Cube.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It runs from the Performance Analysis module whenever Report Cube definitions change or accounting data grows, and it can be launched manually or scheduled as a job.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Accurate cube summaries keep performance reports, dashboards, and OLAP-style analysis fast and consistent with the underlying Fact_Acct transactions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow Diagram<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"228\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/ReCalculate-Cube.drawio-1024x228.png\" alt=\"TenthPlanet-iDempiere-Process-RecalculateCube-ProcessFlow\" class=\"wp-image-20672\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/ReCalculate-Cube.drawio-1024x228.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/ReCalculate-Cube.drawio-300x67.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/ReCalculate-Cube.drawio-768x171.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/ReCalculate-Cube.drawio-1536x343.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/ReCalculate-Cube.drawio.png 1802w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Only active Report Cube definitions are processed during recalculation.<\/li>\n\n\n\n<li>Full rebuild clears existing summary records before regenerating them.<\/li>\n\n\n\n<li>Force option recalculates records even when no changes are detected.<\/li>\n\n\n\n<li>Run as Job executes recalculation asynchronously without blocking the session.<\/li>\n\n\n\n<li>Recalculation is scoped to the client of the logged-in user.<\/li>\n\n\n\n<li>Leaving Report Cube blank processes all active cubes for the client.<\/li>\n\n\n\n<li>Summary data in Fact_Acct_Summary reflects only the last successful recalculation.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisite<\/strong>s<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Report Cube definition configured in the Performance Analysis module.<\/li>\n\n\n\n<li>Accounting facts already posted to the Fact_Acct table.<\/li>\n\n\n\n<li>Report Cube dimensions and measures configured correctly.<\/li>\n\n\n\n<li>User role has access to the Recalculate Cube process and Report Cube window.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Menu \u2192 Performance Analysis and Accounting \u2192 Financial Reporting \u2192 Recalculate Cube<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"368\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-1-1024x368.png\" alt=\"\" class=\"wp-image-20673\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-1-1024x368.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-1-300x108.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-1-768x276.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-1-1536x552.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-1-2048x736.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After opening the window, users see a Report Cube selector along with Full rebuild, Force, and Run as Job checkboxes, plus OK and Cancel buttons at the bottom.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"368\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-2-1024x368.png\" alt=\"\" class=\"wp-image-20674\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-2-1024x368.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-2-300x108.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-2-768x276.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-2-1536x552.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-2-2048x736.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Select the Report Cube<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Choosing the Report Cube determines which summary definition is being rebuilt. Leaving it blank recalculates every active cube for the client.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open the Report Cube dropdown and select the cube to recalculate, or leave it empty to process all active cubes for the current client.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"417\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-3-1024x417.png\" alt=\"\" class=\"wp-image-20675\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-3-1024x417.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-3-300x122.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-3-768x313.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-3-1536x626.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-3-2048x834.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Report Cube<\/td><td>Sales Performance Cube<\/td><td>Report cube definition whose summary facts will be rebuilt<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Decide on Full Rebuild<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Full rebuild is required after structural changes to a cube, such as new dimensions or measures, since old summary rows no longer match the definition.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check Full rebuild only when the cube structure changed or summary data looks incorrect; leave it unchecked for routine incremental updates.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Full rebuild<\/td><td>Unchecked<\/td><td>Clears existing Fact_Acct_Summary rows before regenerating them<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Enable Force if Needed<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Force overrides the system&#8217;s internal check that skips cubes it considers already up to date, useful when summary data is suspected to be out of sync.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check Force when totals look stale despite no reported errors, such as after a manual correction to accounting facts.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"417\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-4-1024x417.png\" alt=\"\" class=\"wp-image-20676\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-4-1024x417.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-4-300x122.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-4-768x313.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-4-1536x626.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-4-2048x834.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Force<\/td><td>Checked<\/td><td>Forces recalculation even if the system detects no pending changes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Choose Run as Job for Large Datasets<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Large cubes can take significant time to rebuild; running as a background job prevents the user session from timing out during processing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check Run as Job for large or multi-organization cubes so the process executes in the background instead of holding the browser session.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Run as Job<\/td><td>UnChecked<\/td><td>Submits the recalculation as an asynchronous background job<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Note:<\/strong> Running large or multi-organization Report Cubes without Run as Job may cause the browser session to time out before the process finishes.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Execute the Process<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Submitting the process starts the recalculation and returns a completion log summarizing the cubes processed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click OK to run the process, or Cancel to close without recalculating. Review the process log for confirmation once it completes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"417\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-5-1024x417.png\" alt=\"\" class=\"wp-image-20677\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-5-1024x417.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-5-300x122.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-5-768x313.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-5-1536x626.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Process-RecalculateCube-5-2048x834.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Process times out on large cubes<\/td><td>Synchronous execution on high Fact_Acct_Summary volume<\/td><td>Enable Run as Job to process in the background<\/td><\/tr><tr><td>Summary data appears outdated<\/td><td>Full rebuild not selected after a cube definition change<\/td><td>Rerun the process with Full rebuild enabled<\/td><\/tr><tr><td>No Report Cube listed in dropdown<\/td><td>No active Report Cube record exists<\/td><td>Create and activate a Report Cube definition first<\/td><\/tr><tr><td>Recalculation processes zero records<\/td><td>Cube dimensions do not match posted Fact_Acct data<\/td><td>Review the cube&#8217;s dimension and measure configuration<\/td><\/tr><tr><td>Recalculation does not affect other clients<\/td><td>Process is scoped only to the logged-in client<\/td><td>Log in under the target client and rerun the process<\/td><\/tr><tr><td>Duplicate or inconsistent summary rows<\/td><td>Repeated runs without Full rebuild after structural changes<\/td><td>Run Full rebuild to clear and regenerate cleanly<\/td><\/tr><tr><td>Background job never appears to complete<\/td><td>Process Scheduler or job queue is not active<\/td><td>Verify the Process Scheduler is running and retry<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configure additional Report Cube definitions for other reporting dimensions.<\/li>\n\n\n\n<li>Schedule Recalculate Cube as a periodic Process Scheduler job.<\/li>\n\n\n\n<li>Review Performance Analysis dashboards to confirm updated cube data.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"epyt-video-wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_42237\"  width=\"800\" height=\"450\"  data-origwidth=\"800\" data-origheight=\"450\"  data-relstop=\"1\" src=\"https:\/\/www.youtube.com\/embed\/SPhEcr1Y0KQ\">https:\/\/www.youtube.com\/watch?enablejsapi=1&autoplay=0&cc_load_policy=0&cc_lang_pref=&iv_load_policy=1&loop=0&rel=0&fs=1&playsinline=0&autohide=2&theme=dark&color=red&controls=1&disablekb=0&\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Recalculate Cube is a background process window in iDempiere that rebuilds summarized accounting facts stored in the Fact_Acct_Summary table [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20671","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20671"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20671\/revisions"}],"predecessor-version":[{"id":29883,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20671\/revisions\/29883"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}