Specifying a data source for reports
Improve your system performance by changing the default database, from which reports obtain data, to a custom database. By creating and designating a separate database as the source of your reports, you reduce the time that is required to run reports.
The custom database uses database tables to retrieve class data.- Enable Pega Platform to access your database by creating a database
table:
- In the navigation pane of Dev Studio, click Records.
- Expand the SysAdmin category, and then click Database Table.
- In the upper-right corner of the window, click Create.
- In the Create Database Table tab, enter the short description for the table, specify the class to which the database table belongs, and then click Create and open.
- In the new database table rule form, provide the details for your database table, and then click Save.
- Change the database from which your reports obtain data:
- In the navigation pane of Dev Studio, click Records.
- Expand the Reports category, and then click Report Definition.
- In the list of report definitions, click the report definition for which you want
to edit the source.
- On the report definition rule form, click the Data Access tab.
- In the General data access settings section, in the Reporting database list, select Prefer reporting data source if defined.
- In the upper-right corner of the window, click Save.
- Disabling usage of a reports database
You can disable a report from obtaining data from a reports database, even if the Prefer reporting data source if defined option is selected on the report definition rule form.
Previous topic Customizing usage reports Next topic Disabling usage of a reports database