Using PRD, we will open a report we created in earlier chapters and then publish it in Pentaho BA Server. We will configure the connection data required by Pentaho BA Server and then configure the data related to the publication. Finally, we will use PUC to run the report we have published.
13_Adding_Subreports.prpt
.Reporting
folder).Here we should complete the required information as follows:
http://localhost:8080/pentaho
. This is the base URL where Pentaho BA Server is listening.30
.Pentaho BA-Server 5.0
.admin
. This is the Pentaho BA Server user that has permissions to publish content.password
. This is the admin
user's password.Next, click on OK to continue.
Here we should complete the options as follows:
To publish the report, we click on OK.
If the publication was successful, we will see the following message:
If we want to run the published report now, we choose the option Yes; but what we want to do now is see this report from PUC, so we will choose the option No.
http://localhost:8080/pentaho
admin
(whose password is password
).We used PRD to open the report 13_Adding_Subreports.prpt
and publish it. We configured the connection data for Pentaho BA Server; among them, we configured the URL and the authentication credentials. Then we specified the solutions folder where the report was saved and established a default value for the output type. Finally, we accessed PUC using our preferred web browser and executed the published report.
As you can see, the report looks better when executed in PUC than when it is executed in PRD. The selector area is more stylized and can even be hidden.
Also, the solutions structure that Pentaho BA Server offers, that is, the folders and files, gives users great familiarity with the environment and drastically reduces their resistance to change.
To run the report, first we had to find it (/public/Reporting
), which means we needed to know its exact location. Suppose a user with little technological experience needs to run a given report. What information should we give him or her? The login URL, the steps to follow to see the Browse Files perspective, a brief explanation on how to use the Browsing and Files panels, and finally, where the report in question is located. It seems like a lot, doesn't it?
But there is a solution to this problem. We can send the user a URL through which he/she only has to log in to see the report.
Doing this is very easy:
http://localhost:8080/pentaho/api/repos/:public:Reporting:13_Adding_Subreports.prpt/viewer?
Now suppose that the user needs the report to show the information for the country Egypt
by default. The URL we should send is as follows:
http://localhost:8080/pentaho/api/repos/:public:Reporting:13_Adding_Subreports.prpt/viewer?SelectCountry=29
The option of sending just the URL to reference and access a report is an enormous facilitation to distribution. It avoids unnecessary delays in looking for a particular report and facilitates access to information.
One of the options that Pentaho 5.0 offers is the possibility of scheduling PRD reports. When scheduling a report, Pentaho BA Server precalculates the report data and saves a copy in the chosen format (HTML, PDF, and so on) so we do not have to wait for the data to load to see the report.
To create a schedule for a report, follow these basic steps:
Now the following wizard will open:
13_Adding_Subreportes_Egypt
./public/
Reporting.The page will look like the following screenshot:
Now click on Next > to go to the next step in the wizard. The page will look like the following screenshot:
To continue, click on Next >. The following page will open:
To see the schedules, choose the Schedules perspective. The page will look like the following screenshot:
Once the schedule has been executed, we can see the precalculated reports. We can also choose a schedule and click on to run it now.The precalculated reports are generated in the specified folder. In this case, if we go to the Browse Files perspective, we will see the following screenshot:
We have seen how to publish reports in Pentaho BA Server using the PRD UI. Now we will see how to import reports from PUC. This is a new characteristic in Pentaho 5.0.
The first thing to do is select the solutions folder where the report will be imported. Then, click on the option Upload... as shown in the following screenshot:
Finally, find and select the desired report using the Browse... button, verify the Advanced Options option, and click on OK as shown in the following screenshot:
We propose a series of tasks for you to carry out as follows:
01_Hello_World.prpt
, 03_Adding_Relational_DS.prpt
, and 05_Adding_Groups.prpt
07_Adding_Parameters.prpt
, 09_Using_Formulas.prpt
, and 11_Adding_Graphics.prpt
07_Adding_Parameters.prpt
in which the rating PG
, the year 2005
, and the month May
are selected by default09_Using_Formulas.prpt
so that it is executed every day at 7:00 in the morningQ1. State whether the following statements are true or false:
[PUC_HOME]/tomcat/jdbc.