3.3.2. Create Data Source and Analysis Report Manually

Create Data Source

  1. Click New Data Source.

  2. Select the Source Type: Database Table(s).

  3. Select the new BIDemo connection in the list of available connections.

  4. Select Reporting and Analysis as the aim of this data source.

    pentaho console

  5. Select the dimensions and the fact tables we have created in Spoon: "PENTAHO_DIM_CUSTOMER", "PENTAHO_DIM_PRODUCT", "PENTAHO_FACT_ORDER_LINE":

    pentaho console 2

  6. Define Joins for selected tables:

    pentaho console 3

  7. Customize the dimensions hierarchy:

    pentaho console 5

  8. Save the data source. Select it in the list of available datasources and export the created analysis for the further use:

    pentaho console 4
Create Analysis Report

  1. Click New → Saiku Analytics → Create a new query. Select BiDemo cube and fill measure, columns, and rows as on the screen:

    bi pentaho 5

  2. Save report in the directory /home/admin with the name ProductsByTypeAndLocation.

Now you can open the Pentaho report in the CUBA application.