Create a New Cube Report

Alchemex

Home > Analysis Module > Tutorials > Create a New Cube Report

Create a New Cube Report

Using the Sage Accpac Intelligence Report Manager module, create a new Cube Report by linking it to your own .cub file which you have just created.

  1. Within the Sage Accpac Intelligence Report Manager right click on the folder chosen to hold your cube reports, select Add Report.

  2. You will be prompted to select a type of report, select Cube Report.

  3.  Click on OK.

  4. Enter a name of the report and then click OK

  5. You will be prompted to select a data Container (Cube) for your report, select the container named Sales Demo Cube which you created earlier and click on OK

  6. You will notice the Customer Report is now created in your OLAP Cube Reports folder and you will also see new tabs in the Report Manager referring to the properties of your Cube Reports.

    The tabs on properties window in the Sage Accpac Intelligence Report Manager are different for Cube Reports as opposed to Standard Reports or Union reports.  You will notice that Page, Row, Column and Measure tabs replace the original columns, filters and parameter tabs.

     

  7. Select the Cube Page tab. Click Add on the right hand side of the screen.

  8. The Customer dimension defined within the Analysis Module will now be available for selection.

  9. Click on OK

  10. Select the Cube Row tab.

  11. Click  Add on the right hand side of the screen.  This will define the information shown horizontally.

  12. The Date Dimension defined within the Analysis Module will now be available for selection

  13. Click on OK.

  14. Select the Cube Column tab. Click  Add on the right hand side of the screen. This will define what information will be shown vertically.  For this example we have no data as we are totalling the sales values within the report. Click OK

  15. Select the Cube Measure tab. Click Add on the right hand side of the screen. This will define which measures to report on based on the measures set up within the Analysis Module.

  16. The TotalSale measure defined within the Analysis Module will now be available for selection.

  17.  Click on OK..

  18. Right click on the report name click on the Run button , or right click and select Run.

  19. The user is able to drill down to interrogate the data by double clicking the year fields. A specific customer can also be selected by using the drop down menu at the top of the report.