User manual BUSINESS OBJECTS MEDATA MANAGER 11.7.1 FOR WINDOWS

[. . . ] BusinessObjects Metadata Manager User's Guide BusinessObjects Metadata Manager 11. 7. 1 Windows Copyright © 2007 Business Objects. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 6, 247, 008; 6, 289, 352; 6, 490, 593; 6, 578, 027; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998 and 7, 139, 766. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Xcelsius, Crystal Decisions, Intelligent Question, Desktop Intelligence, Crystal Enterprise, Crystal Analysis, Web Intelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects in the United States and/or other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Navigate to an object for which you want to enter values for the custom attributes. BusinessObjects Metadata Manager User's Guide 97 4 Metadata Manager Explorer Custom attributes 2. Type or select the values for the attributes to configure and click OK. Metadata Manager adds the custom attribute to the list of attributes for that object. Custom attributes appear in italic text on the Overview tab for the object and in object pop-up boxes in relationships views. Related Topics · · Adding, defining, and associating custom attributes on page 94 Entering values for multiple attributes for an object type on page 99 98 BusinessObjects Metadata Manager User's Guide Metadata Manager Explorer Custom attributes 4 Entering values for multiple attributes for an object type You can enter values for multiple attributes for an object type using the object worksheet. Navigate to the object type for which you want to configure attributes. Type or select the values in each cell for the attributes to configure including annotations and custom attributes. Metadata Manager saves the value when you navigate away from the cell (when you press Tab or Enter or click in another cell). Example: The following example shows the custom attributes Top Secret, Usage Rating, and Data Steward being set for four reports. The bottom of the worksheet indicates the user who last modified a custom attribute or annotation. BusinessObjects Metadata Manager User's Guide 99 4 Metadata Manager Explorer Custom attributes Related Topics · · · Adding, defining, and associating custom attributes on page 94 Entering a value for a custom attribute for an object on page 97 Customizing the object worksheet display on page 100 Customizing the object worksheet display You can customize the display of the object worksheet in one of two ways: · Click Customize to display the Show/Hide/Order dialog box. To show or hide columns, select or clear the check boxes and click OK. To move a column up or down (corresponds to left or right respectively on the object worksheet), select (highlight) a column name and click Up or Down, then click OK. · Each worksheet column has a drop-down menu that lets you hide the column. Click Customize to open the Show/Hide/Order dialog box to display hidden columns. 100 BusinessObjects Metadata Manager User's Guide Metadata Manager Explorer Exporting relational objects 4 Example: The following example clears the check boxes in front of columns Keywords and CMS Server to hide them on the worksheet. Exporting relational objects Metadata Manager provides you with the ability to export relational objects from an ETL, relational database, or data modeling source in the Metadata Manager repository to one of the following files: · A general-purpose Common Warehouse Modeling (CWM) XML file that includes all relational object types. You can select the following objects to export to a general-purpose CWM XML file: · · · Database Catalog Schema BusinessObjects Metadata Manager User's Guide 101 4 Metadata Manager Explorer Exporting relational objects · · · · Table View Procedure A CWM XML file that contains a subset of the relational objects that you import into BusinessObjects Enterprise to create a universe. You can select the following objects to export to a CWM XML file that will be used to create a universe: · · Database - Metadata Manager exports a relational database as a catalog. All of the selected schemas, tables, and views must belong to the same catalog. Schema Table View - Metadata Manager exports a view as a table. · · · Note: In an RDBMS system, a Server Instance corresponds to a Database and a Database corresponds to a Catalog. The following table lists the relational objects and metadata that Metadata Manager exports for each object. Relational object type Catalog Schema Exported metadata Attributes such as name Attributes such as name Attributes such as name If Same As relationship exists: · Annotation Table · · Business name Business description 102 BusinessObjects Metadata Manager User's Guide Metadata Manager Explorer Exporting relational objects 4 Relational object type Exported metadata Attributes such as name If Same As relationship exists: · Annotation View · · Business name Business description Attributes such as name, data type, length If Same As relationship exists: · Annotation · · Business name Business description If column is a primary key: · Column · Constraint reference based on primary key order in columns If column is a foreign key: If the target table is included in the export and the target columns are part of the primary key, Metadata Manager exports the foreign key If lineage information exists and export is for universe creation: · Path from server instance, database, schema, table Procedure parameter Attributes such as name, data type and parameter type (in, out, inout, return) Note: When you export an object, Metadata Manager also exports all objects contained within the object you specify. For example, if you export a table, Metadata Manager exports the table and all of the columns it contains. Similarly, if you export a schema, Metadata Manager exports the schema and all of the tables (and their columns) contained within the schema. This section includes the following topics: BusinessObjects Metadata Manager User's Guide 103 4 Metadata Manager Explorer Exporting relational objects · · · Selecting objects to export on page 104 Exporting objects to a general-purpose CWM XML file on page 105 Exporting objects to create a universe on page 110 Selecting objects to export To select objects to export, you add them to the Object Tray. For example, suppose you want to export the DBO schema, a fact table and it's dimension tables in a data warehouse. An Object Tray icon with a check mark appears next to the schema name. [. . . ] The following sample ODS source page shows the Schemas object type has an instance ODS that contains synonyms: Synonyms (2). Note: Metadata Manager displays synonyms for tables and views only. Synonyms for other objects (such as functions and procedures) do not display in the Metadata Manager Explorer. For a synonym of a synonym on a table or view, Metadata Manager displays two synonyms for the table or view. 228 BusinessObjects Metadata Manager User's Guide Relational Database metadata Viewing relationships in a database source 8 Click Synonyms (2) to display more information about the two synonyms. The following Explorer pages shows that the synonyms contain views. BusinessObjects Metadata Manager User's Guide 229 8 Relational Database metadata Viewing relationships in a database source Click the name of one of these synonyms to display information about the view. For example, click PATH_VIEW to display the Explorer page for this view. [. . . ]