Types of Reports › Report on Model Objects

Report on Model Objects

You can report on modeling objects using the object names and property names. The list of object names is available in the file MartServer\WEB-INF\Metadata\EMX_ObjectTypecodeList.csv. The list of property names is available in the file MartServer\WEB-INF\Metadata\EMX_PropertyTypecodeList.csv.

Follow these steps:

1. Edit the reports.xml file and include the report definition for the Model objects and their properties that you want to report on.
2. Edit the reports_schema.xml file and include the schema definition for the report. You can also generate the schema definition using a tool of your choice and include it in the reports_schema.xml file.

The following report definition script reports on the Object table that includes Entity and Attributes:

<report>

    	<Name>Entity Attributes</Name>

        <Object_Type>

        	<Name>Entity</Name>

            <Report_Output>

                <Property>

                    <Type>Name</Type>

    		    <Type>Physical_Name</Type>

    		    <Type>Catalog_Name</Type>

		    <Type>Catalog_Path</Type>

		</Property>

            </Report_Output>

            <Object_Type>

                <Name>Attribute</Name>

                <Report_Output>

                    <Property>

                        <Type>Name</Type>

                        <Type>Physical_Name</Type>

                        <Type>Logical_Data_Type</Type>

                        <Type>Physical_Data_Type</Type>

                    </Property>

                </Report_Output>

            </Object_Type>

       </Object_Type>

    </report>

The list of Type tags or valid column values are listed below.