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. [. . . ] Select Applications from the navigation list at the top of the CMC Home page. Select Metadata Management in the "Applications Name" list. Click the down arrow next to "Action" in the top menu tool bar and select Manage Utilities. A list of utility configurations appear. Select the recreate index utility that you want to run. In the top menu tool bar, click Action > Run Now. 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. [. . . ] 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. The following Explorer pages shows that the synonyms contain views. 402 SAP BusinessObjects Metadata Management User's Guide Relational Database Metadata Viewing relationships in a database source 13 Click the name of one of these synonyms to display information about the view. The Overview tab shows the following information: · · · · Schema name Database name SQL SELECT statement that the CREATE VIEW statement contains The Columns section lists a line for each column with its name, data type and other attributes The following example shows the "Overview" tab for PATH_VIEW. Click the "Same As" tab to display the synonyms that are the same as the view. SAP BusinessObjects Metadata Management User's Guide 403 13 Relational Database Metadata Viewing relationships in a database source Viewing primary key and foreign key relationships If a column is a primary key or a foreign key, the SAP BusinessObjects Metadata Management Explorer shows that relationship in the Related To tab. [. . . ]