Creating your first Sample Report for the BIA Reporting Application
- Select <Curam BI Content> project.
- Go to File, new, Report and if creating an overpayment sample report save the report to here <Curam_DIR>\BIContent\components\core\birt.
- Verify that the library is still available in the Resource View (from the previous steps).
- Go to the Outline View->libraries->right click and select use library, select the "CEFLibrary" from the Shared Resources\resources\library folder in the popup.
- Go to the Resource Explorer, expand "CEFLibrary" in Shared Resources\resources\library and complete the following:
- Data Sources ->CuramDB, right click and select add to report.
- Select CuramDM if creating a datamart report.
- Select Data Sources and if no current data source exists, right click and choose new data source. Edit the new/current data source to point to your local source database, i.e right click on datasource, click edit and set the following values:
- Driver Class: com.ibm.dbe.jcc.DB2Driver (v3.57)
- Driver URL: jdbc:db2://silverstreak:50000/curam
- Username: db2admin
- Password: ********
- The settings within this panel will be used for the Eclipse embedded preview mode only. Test your connection.
- Create a new data set using the data source configured in the previous step, paste in the SQL as an example select casetypecode as status, count (casetypecode) as casecount from caseheader group by casetypecode. If you are unable to view all entities this is due to the fact that BIRT puts a cap on the number of tables displayed when creating a dataset. Please see Troubleshooting Guide for steps to change this setting.
- Add a chart to the report we recommend that you copy and paste in a chart from one of the reports in the Cúram BIRT Viewer Samples project. Ensure the chart uses the newly created data set. Chart styling will be enforced through CSS in future versions of the Cúram BIRT Viewer.
- In order to test your report via the application pages, copy the report to be executed from the Cúram BIRT Viewer:
- If your Cúram BIRT Viewer is already configured (see 4.1 Configuring the Cúram BIRT Viewer), then execute the following command from the <Curam_DIR>/BIContent directory to make your reports available to the Cúram BIRT Viewer - appbuild client.birt.
- Run your report from the Cúram BIRT Viewers test window or view from the application page:
- http://localhost:9080/CuramBIRTViewer/