Generate a database report

A database report provides a printable summary of the design and configuration of a database.

Click the Phocas menu button >Administration > Databases.
Select the database row and click More > Report. The report opens in a new browser tab.

The following information displays in the report:

Section	Description

Section	Description
Database Info	Basic information about the database, including its physical SQL Server name and the internal ID that Phocas uses for referencing the database externally. To directly link to a database from elsewhere, you just append this ID to the URL: http://localhost/Query/Database/{ID}
Defined Periods	A list of the defined periods in the database, with its period type and period range.
Dimensions	A list of the dimensions in the database, and the number of records in each as well as all of the properties they contain.
Streams	A list of the streams in the database, with their min and max transaction dates.
Measures	A list of the measures in the database.

You can collapse/expand the sections using the minus/plus buttons next to the section headings.

You can print the report using your browser's standard Print function.