install_default_report_designs

Creates the default report designs contained in the default_report_design.xml file as part of the Teamcenter installation process. Other report designs can be imported into the database by adding them to the default_report_design.xml file and rerunning the utility. Syntax install_default_report_designs [-u=user-id {-p=password | -pf=password-file} -g=group] -file=xml-file-list -design_name=report-design-name -create_new [-update_all | -update_query | -update_pff | -update_formatter [-v] [-h] Arguments -u Specifies the user ID. This is generally a user with administration privileges. Note If Security Services single sign-on (SSO) is enabled for your server, the -u and -p arguments are authenticated externally through SSO rather than being authenticated against the Teamcenter database. If you do not supply these arguments, the utility attempts to join an existing SSO session. If no session is found, you are prompted to enter a user ID and password. -p Specifies the password. This argument is mutually exclusive with the -pf argument. -pf Specifies the password file. For more information about managing password files, see Manage password files. This argument is mutually exclusive with the -p argument. -g Specifies the group associated with the user. If used without a value, the user's default group is assumed. -file Specifies the name of the XML file containing report design definitions. -design_name Specifies the name of the report design. -create_new Creates new objects. This cannot be used with update modes. -update_all Updates all existing objects (query, pff, and formatter). -update_query Updates existing query objects. -update_pff Updates existing pff objects. -update_formatter Updates existing formatter objects. -v Displays detailed status information. -h Displays help for this utility. Environment As specified in Setting up a Teamcenter command-line environment. Files As specified in Log files produced by Teamcenter. Restrictions None. Return Values Return value upon success 0 Return value upon failure >1, –1 Examples To create default report enter the following command on a single line: Copy install_default_report_designs -u=user_name -p=user_name -g=dba -file=$TC_DATA\report_writer\default_report_designs.xml XML File Format The format required for the XML file is as follows. XML file format Copy Admin - Objects By Status This report returns objects of a specified type released to a specified status. Admin - Objects By Status This query was created to support the Admin - Objects By Status Report. WorkspaceObject SELECT qid FROM WorkspaceObject WHERE "object_type" = "${Type = ItemRevision}" AND "release_status_list.name" = "${Release Status = }" QRY_DOMAIN_LOCAL Admin - Objects By Status This PFF was created to support the Admin - Objects By Status Report. WorkspaceObject WorkspaceObject.object_name;Object Name, WorkspaceObject.object_type;Object Type, WorkspaceObject.release_status_list.name;Release Status, WorkspaceObject.date_released;Date Released, WorkspaceObject.owning_user.user_id;User Name, WorkspaceObject.owning_group.name;Group Name default_xml_template.xsl XMLReportFormatter default_excel_template.xlt ExcelReportFormatter