Data Visualization GEri - SpagoBIDavide Zerbetto, Nunzia MarottaEngineering Data Visualization GE Manager, Data Visualization GE Course Creator - FIWAREdavide.zerbetto@eng.it ,nunzia.marotta@eng.it

Birt Report Designer

TOPIC OF THE COURSE: In this course we will see how to assign parameters to any analytical document, such as Report with Birt, Qbe, Olap, etc.

Parametric Report

To accomplish the task one needs to build up:

● the LOV which stands for List Of Values. It means to develop the set of values that the parameter can assume;

● the Analytical driver which manages the connection between the end-user, the document and the LOV.

In the following there will be more explanations about these two concepts.

SpagoBI allows you to define a LOV in multiple ways …

➢ Statically➢ Querying a database➢ Using a script➢ Calling an external object

Each record in a LOV can be composed of multiple attributes (ex. Customers): [A.Catherine, 4559 Julpum Loop, Beaverton,USA], [A.Joyce, 3761 Cancroft, San Gabriel,USA]). One of these attributes represents the actual value. The others are just descriptive.

Click on the Profiling button and select Lovs Management from the contextual menu.

Start a new Lov using the button at the right corner of the page.

Fill in the mandatory fields (marked with the *) and choose in which way you want to implement the LOV. As an example we will choose the “Query statement” one.

Insert the query in the Query definition box and test it using the specific comand

When the LOV works fine you have to define some meta-information

Select the column that must be shown to the user

Select the value to be sent to the report

Then finally save it and go on with the next step: create a new Analytical Driver.

An analytical driver is an autonomous entity that models a business concept in order to use it as a discriminating criterion in the global data context, according to the different end-users’ roles.It works as a variable that can take its runtime value from different LOVs. The actually used LOV and, therefore, the actual range of possible values, depend on the role of the user that uses the analytical driver itself.Designing an Analytical Driver means answering the following questions:

Start a new Analytical Driver using the button at the right corner of the page

You'll be asked to fill in the mandantory fields marked with *. Observe that you can choose for the Type between Date, String or Number.

SpagoBI display Date Widget.

SpagoBI send data as Integer to the Report

SpagoBI send data as String to the Report

REMEMBER TO SAVE and keep on filling in

You'll be asked to fill in the mandantory fields marked with *. Observe that you can choose for the Type between Date, String or Number.

REMEMBER TO SAVE and keep on filling in

➔ Select Functional if analysis data will be drived by the current AD

➔ Select Temporal if this AD depends on the time and it can be conveniently computed by the Scheduler by means of a formula

IT'S IMPORTANT TO

➢ Fill in the mandatory fields.

➢ Associate the corresponding LOV to the AD .

➢ Attribute Roles to the AD.

We stress that one can add distinct operational methods to an AD and relate them to different roles. This way the same AD displays different values with a certain data visualization accordingly to the end-users' roles.

Relate Analytical Driver and document

Edit the document (using document detail )

At the bottom of the page select New from the dedicated section Document Analytical Driver Detail.

➢ Fill in the mandatory fields and add the AD clicking on the icon at the end of the row.

➢ Insert in the Url Name box the exact name of the parameter used in your report/qbe/olap/whatever….

USE THE GREEN TICK TO SELECT THE

AD

To sum up:

Edit the document ( using document detail )

Select New and fill in the mandatory boxes

Add Driver at the bottom of the form.

REMEBER TO SAVE AS SOON AS YOU THINK YOU'RE DONE WITH THE INSERTION

Remember the URL NAME value must be identical to the report

parameter name

Repeat the procedure and assign as many parameters as the report is configured

Open your document and check parameters. Click on the Execute button to run your statistic.

Thanks!Thanks!