{"id":20630,"date":"2026-07-14T11:55:22","date_gmt":"2026-07-14T11:55:22","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20630"},"modified":"2026-08-13T04:42:35","modified_gmt":"2026-08-13T04:42:35","slug":"how-to-configure-report-cube-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-report-cube-in-idempiere\/","title":{"rendered":"How to Configure Report Cube in iDempiere"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

The Report Cube window in iDempiere defines a multidimensional data cube used within Performance Analysis Rules for OLAP-style reporting.<\/p>\n\n\n\n

It is used by finance and reporting teams to pre-aggregate transactional and accounting data across dimensions such as Product, Business Partner, and Sales Region.<\/p>\n\n\n\n

Report cubes speed up performance analysis reports and dashboards by reducing the need to query large volumes of Fact Accounting data directly.<\/p>\n\n\n\n

Process Flow Diagram<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Accounting-ReportCube-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Active report cubes are available for use in Performance Analysis Rule reporting.<\/li>\n\n\n\n
  • Calendar assignment defines the fiscal periods used for report cube recalculation.<\/li>\n\n\n\n
  • Only checked dimension checkboxes are included in the cube’s aggregated data.<\/li>\n\n\n\n
  • Report cube name must be unique within the Tenant and Organization.<\/li>\n\n\n\n
  • Last Recalculated date updates only after the recalculation process runs.<\/li>\n\n\n\n
  • Inactive report cubes are excluded from reporting selection lists.<\/li>\n\n\n\n
  • Report cubes follow standard Tenant and Organization data security rules.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Tenant and Organization configured.<\/li>\n\n\n\n
    • Calendar configured under General Rules.<\/li>\n\n\n\n
    • Accounting dimensions (Product, Business Partner, Activity, Project) set up as applicable.<\/li>\n\n\n\n
    • Role has window access to Report Cube.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Performance Analysis and Accounting \u2192 Financial Reporting \u2192 Report Cube<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Accounting-ReportCube-1\"<\/figure>\n\n\n\n
      Opening the window displays the Report Cube list. Selecting or creating a record opens the detail form showing Tenant, Organization, Name, Description, Calendar, Active flag, dimension checkboxes, and the Last Recalculated timestamp.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Accounting-ReportCube-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Create a New Report Cube Record<\/strong><\/h3>\n\n\n\n
      Establishes the base record that stores cube settings before dimensions and calendar are assigned.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click the New icon on the toolbar. Enter a unique Name and optional Description to identify the report cube for reporting users.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Name<\/td>Test<\/td>Identifies the report cube in reporting selections<\/td><\/tr>
      Description<\/td>(blank)<\/td>Provides additional context about the cube’s purpose<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Assign Tenant and Organization<\/strong><\/h3>\n\n\n\n
      Determines the data scope and security context for the report cube.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Confirm the Tenant field and select the Organization that owns this report cube. These values control who can access the cube.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Tenant<\/td>POTS<\/td>Defines the client-level ownership of the cube<\/td><\/tr>
      Organization<\/td>CDC<\/td>Defines the organizational scope for the cube<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Assign Calendar<\/strong><\/h3>\n\n\n\n
      The calendar determines which fiscal year and period structure the cube uses during recalculation.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Select a Calendar from the dropdown. This must match the calendar used by the related accounting schema for accurate period-based aggregation.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Calendar<\/td>POTS Calendar<\/td>Defines fiscal periods used for cube recalculation<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Select Dimensions<\/strong><\/h3>\n\n\n\n
      Dimensions define how transactional data is grouped and summarized within the cube.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Check the dimension boxes needed for reporting, such as Product, Business Partner, Sales Region, Activity, Project Phase, Project Task, Sub Acct, or GL Budget.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Product Dimension<\/td>Unchecked<\/td>Includes Product-level grouping in the cube<\/td><\/tr>
      Business Partner Dimension<\/td>Unchecked<\/td>Includes Business Partner-level grouping<\/td><\/tr>
      Sales Region Dimension<\/td>Unchecked<\/td>Includes Sales Region grouping<\/td><\/tr>
      Activity Dimension<\/td>Unchecked<\/td>Includes Activity-based grouping<\/td><\/tr>
      Project Phase Dimension<\/td>Unchecked<\/td>Includes Project Phase grouping<\/td><\/tr>
      Project Task Dimension<\/td>Unchecked<\/td>Includes Project Task grouping<\/td><\/tr>
      Sub Acct Dimension<\/td>Unchecked<\/td>Includes Sub Account grouping<\/td><\/tr>
      GL Budget Dimension<\/td>Unchecked<\/td>Includes GL Budget comparison data<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Only active report cubes are available for selection in Performance Analysis Rules.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Check the Active checkbox, then Save the record. Deactivating later removes the cube from reporting selection lists.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Active<\/td>Checked<\/td>Controls cube availability in reporting<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 6: Recalculate the Report Cube<\/strong><\/h3>\n\n\n\n
      The cube must be recalculated to populate aggregated data before it can be used in reports.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Save the record, then run the Recalculate process. The Last Recalculated field updates with the completion date and time.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Last Recalculated<\/td>07\/13\/2026 12:11:23 PM<\/td>Shows when the cube data was last refreshed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-Accounting-ReportCube-3\"<\/figure>\n\n\n\n
      Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
      Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr>
      Report Cube missing from selection lists<\/td>Active checkbox unchecked<\/td>Check Active and save the record<\/td><\/tr>
      Calendar dropdown is empty<\/td>No Calendar configured for the Organization<\/td>Configure a Calendar under General Rules<\/td><\/tr>
      Last Recalculated date not updating<\/td>Recalculation process not executed<\/td>Run the Recalculate process manually<\/td><\/tr>
      Duplicate Name error on save<\/td>Name already exists in the Tenant<\/td>Enter a unique report cube Name<\/td><\/tr>
      Selected dimension missing from report output<\/td>Dimension saved but cube not recalculated<\/td>Save changes then recalculate the cube<\/td><\/tr>
      Report cube performance is slow<\/td>Too many dimensions selected on large datasets<\/td>Limit dimensions to those needed for reporting<\/td><\/tr>
      Window not visible in menu<\/td>Role lacks access to the Report Cube window<\/td>Grant window access through Role Window Access<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Configure a Performance Analysis Rule that references this Report Cube.<\/li>\n\n\n\n
      • Review GL reporting or dashboard content that uses cube data.<\/li>\n\n\n\n
      • Set up additional Report Cube records for other analysis needs.<\/li>\n<\/ul>\n\n\n\n
        <\/p>\n","protected":false},"excerpt":{"rendered":"
        Introduction The Report Cube window in iDempiere defines a multidimensional data cube used within Performance Analysis Rules for OLAP-style reporting. […]<\/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-20630","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\/20630","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=20630"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20630\/revisions"}],"predecessor-version":[{"id":20635,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20630\/revisions\/20635"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}