How to Prepare and Present Big Data in BIRT

Step-by-Step Guide

1. 1

   Step 1: Ensure BIRT is installed in the IRI Workbench plug-in for Eclipse.

   If it is, go-to step
   5.
   
   If not
   - , In the Work with field click on add the repository named Kepler from http://download.eclipse.org/releases/kepler. ,,, Then from the IRI Workbench Window menu, select Open Perspective
   -> Other
   -> Report Design. ,, filter, sort, join, aggregate, reformat, mask) and table/file target(s) layout(s).
   
   The two most common ways to do this are with a text editor or an automatic job-building wizard in the IRI Workbench GUI in Eclipse Specify all your source and target metadata and transformations in SortCL as explained in Step
   1.
   
   However, you must define your first target as /OUTFILE=stdout for BIRT to ingest this IRI Data Source at reporting time.
   
   You can still specify additional output files, tables and procedures in subsequent target layouts. , For example, any /SUMMARY field has to be defined with its /FIELD format so that the aggregate values are passed into the BIRT as annotated in the image above. ,,,, Click Finish. , Select SortCL (.scl) file at the top.
   
   Add and arrange the available fields needed for the report. , You can also add calculations, customized reports or graphs as required. , A visualization might look like this
2. 2

   Step 2: Select Install New Software from the help menu.

3. 3

   Step 3: Select 'Business Intelligence

4. 4

   Step 4: Reporting and Charting' from the list of available software.

5. 5

   Step 5: Complete the installation and Restart the IRI Workbench.

6. 6

   Step 6: Switch to the Report Design perspective.

7. 7

   Step 7: Expose the IRI project

8. 8

   Step 8: data source and remote systems explorers by clicking on Window -> Show View -> Other

9. 9

   Step 9: Create an IRI CoSort SortCL job script to define your table/file source(s)

10. 10

    Step 10: manipulations (e.g.

11. 11

    Step 11: Ensure all the /OUTFILE fields destined for BIRT also specify supporting fields.

12. 12

    Step 12: To visualize the results in BIRT

13. 13

    Step 13: click File - > New - > Report from the top menu

14. 14

    Step 14: Follow the instructions in the wizard to design the BIRT report.

15. 15

    Step 15: Make sure that you save your new template or move your existing template into the same folder with the SortCL script

16. 16

    Step 16: so the data gets prepared and fed to BIRT via ODA at run-time.

17. 17

    Step 17: Click Data and select New data source -> IRI Data Source and click Next to select the folder containing your report template and the SortCL job script.

18. 18

    Step 18: To define the data preparation for your report

19. 19

    Step 19: click Data -> New Data Set and select IRI Data Source

20. 20

    Step 20: then click Next.

21. 21

    Step 21: Use the palette to modify labels

22. 22

    Step 22: fields

23. 23

    Step 23: and their positions.

24. 24

    Step 24: During report-creation time

25. 25

    Step 25: SortCL and BIRT will run simultaneously to integrate the data and display the information.

Detailed Guide

About the Author