qs_create_report.adoc

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.

   

   Figure 1. Data source wizard

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

   

   Figure 2. Data source wizard

6. Define Joins for selected tables:

   

   Figure 3. Data source wizard

7. Customize the dimensions hierarchy:

   

   Figure 4. Data source model editor

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

   

   Figure 5. Export data source

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:

   

   Figure 6. Create query

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

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