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 |
|---|---|
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.