Is there a Report Designer report I can run that reports on the average row size that appears in Volumetrics in erwin DM?

Description:

Is there a Report Designer report I can run that reports on the average row size that appears in Volumetrics in erwin DM?  Also, is it doable using ODBC query?

Solution:

The 'Average Row Size' is calculated and is not stored in the metadata, so cannot be queried, either using ODBC or Report Designer.  There is an option in the Volumetrics Editor and the Report tab to 'Save as CSV' Button, as below:

To define a Volumetrics report

1. Click Volumetrics on the Tools menu - the Volumetrics dialog opens.

2. Click the Report tab and select from the following options:

  Physical Objects

  Select to display the Volumetric Report grouped by physical storage object.

  Database Objects

  Select to display the Volumetric Report grouped by database object.

  Tables

  Select to display the Volumetric Report grouped by table.

  Initial

  Select to display the Volumetric Report using initial table row size.

  Projections

  Select to display a Volumetric Report using projected table values. The projection uses the Grow By          estimates in the Settings tab.

  Select or type the projected number of months in the Months field (available only when you click            Projections).

3. Save as CSV

Select to save the calculated data as an external CSV file. You are prompted to save the file, which you open using a spreadsheet or database application that supports CSV files.

4. Click OK.

The report executes. You can view the object size calculations in the Physical Objects list.