Create a printable Excel report

Teamcenter can create a printable Excel report containing the results of an accountability check. If you have write access to the target structure, Teamcenter stores the Excel file as a dataset on the top-level item revision of the target structure. If you do not have write access, Teamcenter stores the Excel file in the Newstuff folder.

Procedure

1. Open the Accountability Check dialog box.

2. Select all necessary options to create the accountability report.

3. Click the Reporting tab and select Report the selected check criteria.

4. Select Printable report.

5. Assign a name for the new dataset.

If a dataset of this name and type already exists in the item revision, Teamcenter opens a dialog box where you can change the name or replace the dataset with the new one. You can change this behavior in the TC_CRF_overwrite_existing_dataset_content preference. If this preference is set to 1 (true), Teamcenter does not remove the dataset but replaces the content.

6. Click OK.

Results

Teamcenter creates a report containing:

• General information such as the date and time of the check and the user ID and name.

• Compare options.

• Context data such as the source top level item, the target top level item, incremental change, and revision and variant rules.

• Accountability check results such as the source name, target name, match status, and all the checked properties. Multiple matched objects and missing source objects are displayed in separate sections.

Teamcenter adds the Excel file to a dataset attached to the target structure.

Note

If you use the MEAccountabilityCheckEnableNetEffectivity preference to report net effectivity mismatches, the Excel report also reports those mismatches.