Metadata mappings for bridge imports from SAP BusinessObjects

Content

To import metadata from SAP BusinessObjects, you use the SAP BusinessObjects Repository bridge in InfoSphere Metadata Asset Manager. The repository bridge invokes additional bridges that import from the following tools, depending on your SAP BusinessObjects installation:

• BusinessObjects Designer
• BusinessObjects Crystal Reports
• BusinessObjects Desktop Intelligence
• BusinessObjects Web Intelligence
• BusinessObjects Information Design Tool

• Name of the object in BusinessObjects, or the type of information that is mapped. When the first column of the table refers to information rather than to an object type, the information is enclosed in brackets.
• Display name of the object in InfoSphere Information Server.
• Internal name of the object in InfoSphere Information Server. The internal name is sometimes required for command-line tasks.
• Which interfaces in InfoSphere Information Server display the object. The following abbreviations are used in the Where displayed column to indicate the interface:

MW
InfoSphere Metadata Workbench
SA
The staging area of InfoSphere Metadata Asset Manager
RM
The Repository Management tab of InfoSphere Metadata Asset Manager
BG
InfoSphere Business Glossary. Indicates assets that can be assigned to terms.

BusinessObjects object type [or other information]	Display name in InfoSphere Information Server	Internal name in InfoSphere Information Server	Where displayed in InfoSphere Information Server
System	BI server	BIServer	SA, RM, MW
Folder	BI folder	BIFolder	SA, RM, MW
Universe	BI model	OLAPModel	SA, RM, MW, BG
Crystal Reports document Desktop Intelligence document Web Intelligence document	BI report	ReportDef	SA, RM, MW, BG

BusinessObjects object type [or other information]	Display name in InfoSphere Information Server	Internal name in InfoSphere Information Server	Where displayed in InfoSphere Information Server	Mapping notes
Universe	BI model	OLAPModel	SA, RM, MW, BG
Class (data classes)	BI collection	OLAPCollection	SA, RM, MW, BG	Collection type attribute is set to FACT if the source class contains measures, otherwise set to REGULAR.
Object	BI collection member	OLAPMember	SA, RM, MW, BG	Type is set to MEASURE if the instance is from a Measure class. Set to REGULAR if it is from a DimensionAttribute class.
Join	BI join BI join reference	OLAPJoin OLAPJoinRef	SA: As child of BI model	Two BI join references are created for each BI join.
Filter	BI filter	OLAPFilter	SA, MW: As child of BI model
Default hierarchy Custom hierarchy	BI hierarchy BI hierarchy member BI hierarchy association BI level BI level element	OLAPHierarchy OLAPHierarchyMember OLAPHierarchyAssociation OLAPLevel OLAPLevelElement	BI hierarchy, BI hierarchy member: SA, MW BI hierarchy association: SA BI level: SA, as child of BI model; MW as child of BI hierarchy BI level element: SA	BI level elements are created from the relationships between the hierarchy members objects.
Owner	Database schema	DataSchema	SA, RM, MW, BG
Table	Database table	DataCollection	SA, RM, MW, BG
Column	Database column	DataField	SA, RM, MW, BG
Key	Candidate key Key component	CandidateKey KeyComponent	SA, RM, MW, BG	Key components are derived from columns that are referenced by the key.
[Object list of values]		ValueRule	Not displayed
Alias table	Alias	Alias	SA: Displayed in preview. MW: Displayed as property of database table.
Alias column	Database column	DataField	SA, RM, MW, BG
[Class lineage] NOTE: Not imported or required for lineage at V11.3.	BI collection source	OLAPDataCollectionSource	SA	Derived from the SELECT and WHERE clauses for classes. Connects the BI collections to the underlying database tables.
[Object lineage] NOTE: Not imported or required for lineage at V11.3.	BI collection member source	OLAPMemberSource	SA	Derived from the SELECT and WHERE clauses for objects. Connects the BI collection members to the underlying database columns.

BusinessObjects object type [or other information]	Display name in InfoSphere Information Server	Internal name in InfoSphere Information Server	Where displayed in InfoSphere Information Server	Mapping notes
Report Subreport	BI report	ReportDef	SA, RM, MW, BG	Both report and subreport in Crystal Reports become BI report in the metadata repository.
ReportFields	BI report query	ReportDataSet	SA, RM MW, BG: Displayed as BI query	The query or formula that is associated with a section of a report.
ReportField (data contents)	BI report query item	ReportDataItem	SA, RM MW, BG: Displayed as BI query member	Represents the data contents of fields in the report.
ReportField (display headings)	BI report field BI report drill-through NOTE: At V11.3, BI report field is not displayed, and BI report drill-through is displayed as a property of BI report.	ReportField ReportDrillThrough	BI report field: SA, RM, MW, BG BI report drill-through: SA: displayed as child of BI report field; MW: information displayed in "References BI Report" property of BI report field.	BI report field represents the display headings in the report. BI report drill-through objects are created for the report fields that reference other reports.
Report Subreport Report footer area Report header area Crosstab Chart Report text Report detail area ReportPage header area ReportPage footer area Report Group Area	BI Report section NOTE: This asset is not displayed at V11.3	ReportGroup	SA, RM: Displayed as child of BI Report MW, BG: Displayed as property of BI report field	The type of BI report section (for example, Report header) is indicated by the Group type property of the asset.
QueryTable column Object	BI collection member	OLAPMember	SA, RM, MW, BG
Report filter	BI filter	OLAPFilter	SA, MW: Displayed as child of BI model
TableLink	BI join BI join reference	OLAPJoin OLAPJoinRef	SA: Displayed as children of BI models	Two BI join references are created for each TableLink.
Universe	BI model	OLAPModel	SA, RM, MW, BG	For reports that are sourced from universes.
Class QueryTable	BI collection	OLAPCollection	SA, RM, MW, BG
Alias table	Alias	Alias	SA: Displayed in preview. MW: Displayed as property of database table.
Alias column	Database column	DataField	SA, RM, MW, BG
[QueryTable lineage] NOTE: Not imported or required for lineage at V11.3.	BI report query source	ReportDataSetSource	SA
[QueryTable column lineage] NOTE: Not imported or required for lineage at V11.3.	BI report query item source	ReportDataItemSource	SA

BusinessObjects object type [or other information]	Display name in InfoSphere Information Server	Internal name in InfoSphere Information Server	Where displayed in InfoSphere Information Server	Mapping notes
Universe	BI model	OLAPModel	SA, RM, MW, BG
Class	BI collection	OLAPCollection	SA, RM, MW, BG
Universe object	BI collection member	OLAPMember	SA, RM, MW, BG
Universe filter	BI filter	OLAPFilter	SA, MW: Displayed as child of BI model
Document	BI report	ReportDef	SA, RM, MW, BG
DataProvider Query	BI report query	ReportDataSet	SA, RM, MW, BG	Each DataProvider object is imported as a BI report query. Each of its queries is also imported as a lower-level BI report query.
DataProvider column Query column Formula Variable Constant	BI report query item	ReportDataItem	SA, RM MW, BG: Displayed as BI query member
Cell	BI report field BI report drill-through NOTE: At V11.3, BI report field is not displayed, and BI report drill-through is displayed as a property of BI report.	ReportField ReportDrillThrough	BI report field: SA, RM, MW, BG BI report drill-through: SA: displayed as child of BI report field; MW: information displayed in "References BI Report" property of BI report field.	BI report field represents the display headings in the report. BI report drill-through objects are created for the report fields that reference other reports.
Report Report main section Report footer Report header Crosstab Chart Section Text cell	BI Report section NOTE: This asset is not displayed at V11.3	ReportGroup	SA, RM: Displayed as child of BI Report MW, BG: Displayed as property of BI report field	The type of BI report section (for example, Report header) is indicated by the Group type property of the asset.
[DataProvider query lineage] NOTE: Not imported or required for lineage at V11.3.	BI report query source	ReportDataSetSource	SA
[DataProvider query lineage] NOTE: Not imported or required for lineage at V11.3.	BI report query item source	ReportDataItemSource	SA

BusinessObjects object type [or other information]	Display name in InfoSphere Information Server	Internal name in InfoSphere Information Server	Where displayed in InfoSphere Information Server	Mapping notes
Universe	BI model		SA, RM, MW, BG
Class	BI collection	ClassOLAPCollection	SA, RM, MW, BG
Universe object	BI collection member	OLAPMember	SA, RM, MW, BG
Universe filter	BI filter	OLAPFilter	SA, MW: Displayed as child of BI model
Hierarchy	BI hierarchy	OLAPHierarchy	SA, MW	BI level elements are created from the relationships between the hierarchy elements and objects.
Hierarchy element	BI hierarchy member BI hierarchy association BI level BI level element	OLAPHierarchyMember OLAPHierarchyAssociation OLAPLevel OLAPLevelElement	BI hierarchy member: SA, MW BI hierarchy association: SA BI level: SA, as child of BI model; MW as child of BI hierarchy BI level element: SA
Document	BI report	ReportDef	SA, RM, MW, BG
DataProvider query	BI report query	ReportDataSet	SA, RM, MW, BG	Each DataProvider object is imported as a BI report query. Each of its queries is also imported as a lower-level BI report query.
DataProvider column Query column Report expression	BI report query item	ReportDataItem	SA, RM MW, BG: Displayed as BI query member
Formula cell	BI report field BI report drill-through NOTE: At V11.3, BI report field is not displayed, and BI report drill-through is displayed as a property of BI report.	ReportField ReportDrillThrough	BI report field: SA, RM, MW, BG BI report drill-through: SA: displayed as child of BI report field; MW: information displayed in "References BI Report" property of BI report field.	BI report field represents the display headings in the report. BI report drill-through objects are created for the report fields that reference other reports.
Report Report body, Report footer Report header Crosstab Chart Section Form Table Text cell	BI Report section NOTE: This asset is not displayed at V11.3	ReportGroup	SA, RM: Displayed as child of BI Report MW, BG: Displayed as property of BI report field	The type of BI report section (for example, Report header) is indicated by the Group type property of the asset.
[DataProvider query lineage] NOTE: Not imported or required for lineage at V11.3.	BI report query source	ReportDataSetSource	SA
[DataProvider query column lineage] NOTE: Not imported or required for lineage at V11.3.	BI report query item source	ReportDataItemSource	SA