User manual BUSINESS OBJECTS METADATA MANAGEMENT XI 3.1 12.1.0

[. . . ] SAP BusinessObjects Metadata Management User's Guide SAP® BusinessObjectsTM Metadata Management XI 3. 1 (12. 1. 0) Copyright © 2009 SAP® BusinessObjectsTM. SAP BusinessObjects and its logos, BusinessObjects, Crystal Reports®, SAP BusinessObjects Rapid MartTM, SAP BusinessObjects Data InsightTM, SAP BusinessObjects Desktop IntelligenceTM, SAP BusinessObjects Rapid Marts®, SAP BusinessObjects Watchlist SecurityTM, SAP BusinessObjects Web Intelligence®, and Xcelsius® are trademarks or registered trademarks of Business Objects, an SAP company and/or affiliated companies in the United States and/or other countries. SAP® is a registered trademark of SAP AG in Germany and/or other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Click the down arrow next to "Action" in the top menu tool bar and select Manage Utilities. To view the status of the utility run, select the utility configuration name and click Action > History. 188 SAP BusinessObjects Metadata Management User's Guide Administration Metadata Management administration overview 6 a. To see the progress of the computation run, click the icon for View the database log in the top menu bar of the "Utility History" page. The "Schedule Status" column can contain the following values: · Failed · Running · Success c. The "Log File" column contains a Download link that you can click to view the log file after the lineage report utility completes. To close the "Utility History" page, click the X in the upper right corner. On the "Utility Configurations" page, click the Refresh icon to update the "Last Run" column for the utility configuration. Viewing and editing repository information To view SAP BusinessObjects Metadata Management repository connection information, such as database type and server name, you must have Full Control access level on the Metadata Management folder. To edit the database user and password for the repository, you must be part of the Administrator group. If the database type of the repository is an Oracle RAC database, you can change the connection string if you are part of the Administrator group. Access and login to the Central Management Console (CMC) if you have not already done so. Select Applications from the navigation list at the top of the CMC Home page. In the "Applications Name" list, select Metadata Management. Click the down arrow next to Action in the top menu tool bar and select Configure Repository. The connection information for the Metadata Management repository was defined at installation time. For most of the database types, you can only view the connection information here. If the database type is Oracle RAC, you can modify the connection string here if you want to add another server or tune parameters for failover. SAP BusinessObjects Metadata Management User's Guide 189 6 Administration Metadata Management administration overview 5. You can change the user name and password for the Metadata Management repository. Caution: You must have the appropriate credentials to access the Metadata Management database. After you change the user name and password, you must restart the Web Application Server and CMS. Related Topics · Accessing Metadata Management for administrative tasks on page 119 Exporting objects to XML SAP BusinessObjects Metadata Management provides an XML export utility, MMObjectExporter. bat, which allows you to export repository objects to an XML file. The utility is installed on the machine on which you installed this product. You specify its output by using required and optional command line arguments. To export objects to XML 1. From a command prompt, navigate to the SAP Business Objects installation directory's subdirectory location MetadataManagement\MM\bin. Invoke the XML export utility by typing and running the command MMObjectExporter with the appropriate arguments from the following table. 190 SAP BusinessObjects Metadata Management User's Guide Administration Metadata Management administration overview 6 Option configuration Description (Required) Represents the id number of the integrator source configuration to be exported. [. . . ] If synonyms or aliases exist in a relational database source, the Metadata Explorer shows it as an object type on the source page. The following sample ODS source page shows the Schemas object type has an instance ODS that contains synonyms: Synonyms (2). Note: SAP BusinessObjects Metadata Management displays synonyms for tables and views only. Synonyms for other objects (such as functions and procedures) do not display in the Metadata Management Explorer. For a synonym of a synonym on a table or view, Metadata Management displays two synonyms for the table or view. Click Synonyms (2) to display more information about the two synonyms. [. . . ]