Viewing Inconsistency Reports in Microsoft Excel

All four types of inconsistency reports are saved by default at the user profile temp location, unless the user has defined otherwise.
The reports are saved under the default name InconsistencyReport_PL_JANSEN.xlsm.
Note: To view graphs and charts in the summary inconsistency report, you must enable all macros in Microsoft Excel. To enable macros, click File > Options > Trust Center > Trust Center Settings > Macro Settings > Enable all macros.
 
Figure 1: Sample reports run at area level with sample data (area 211), showing all tags per class in each sheet
 
 
  • Click "2" at the top of the sheet to expand the full list
               
     
    Result: Inconsistencies are highlighted in yellow.
     
  • Filter the inconsistencies per class  by color (yellow) to see all of them in a single view.
       
     
Not published properties from certain domains are left blank and rest of the domain tags if consistent is reported consistent.
Note: Non-availability of a tag property in a domain doesn't report the tag inconsistent if the available values are matching.