Metadata mappings for bridge imports from SAP BusinessObjects

Learn how models, reports and other objects that are imported from SAP BusinessObjects are displayed in InfoSphere® Information Server.

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
The tables in this topic explain the metadata mappings for each bridge, including the following information:
  • Name of the object type 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.
  • Which interfaces in InfoSphere Information Server display the object. The following abbreviations are used in the Where displayed column to indicate the interface:
    SA

    The staging area of InfoSphere Metadata Asset Manager

    RM

    The Repository Management tab of InfoSphere Metadata Asset Manager

    IGC
    InfoSphere Information Governance Catalog, an interactive, web-based tool that enables users to create, manage, share and use trusted business knowledge
Table 1. Objects imported into the metadata repository by the SAP BusinessObjects Repository bridge
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, IGC
Folder BI folder BIFolder SA, RM, IGC
Universe BI model OLAPModel SA, RM, IGC
Crystal Reports document

Desktop Intelligence document

Web Intelligence document

 BI report ReportDef SA, RM, IGC
Table 2. Objects imported into the metadata repository by the SAP BusinessObjects Universe bridge
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, IGC  
Class (data classes) BI collection OLAPCollection SA, RM, IGC Collection type attribute is set to FACT if the source class contains measures, otherwise set to REGULAR.
Object BI collection member OLAPMember SA, RM, IGC 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, IGC: 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, IGC

BI hierarchy association: SA

BI level: SA, as child of BI model; IGC 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, IGC  
Table Database table DataCollection SA, RM, IGC  
Column Database column DataField SA, RM, IGC  
Key Candidate key

Key component

 CandidateKey

KeyComponent

 SA, RM, IGC 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. IGC: Displayed as property of database table.  
Alias column Database column DataField SA, RM, IGC  
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 objects. Connects the BI collection members to the underlying database columns.
[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.
Table 3. Objects imported into the metadata repository by the SAP BusinessObjects Crystal Reports bridge
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, IGC Both report and subreport in Crystal Reports become BI report in the metadata repository.
ReportFields BI report query ReportDataSet SA, RM

IGC: 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

IGC: 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, IGC

BI report drill-through: SA: displayed as child of BI report field; IGC: 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

IGC: 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, IGC  
Report filter BI filter OLAPFilter SA, IGC: 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, IGC For reports that are sourced from universes.
Class

QueryTable

 BI collection OLAPCollection SA, RM, IGC  
Alias table Alias Alias SA: Displayed in preview. IGC: Displayed as property of database table.  
Alias column Database column DataField SA, RM, IGC  
[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  
Table 4. Objects imported into the metadata repository by the SAP BusinessObjects Desktop Intelligence bridge
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, IGC  
Class BI collection OLAPCollection SA, RM, IGC  
Universe object BI collection member OLAPMember SA, RM, IGC  
Universe filter BI filter OLAPFilter SA, IGC: Displayed as child of BI model  
Document BI report ReportDef SA, RM, IGC  
DataProvider Query BI report query ReportDataSet SA, RM, IGC 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

IGC: 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 drill-through: SA: displayed as child of BI report field; IGC: information displayed in "References BI Report" property of BI report field.

BI report field: SA, RM, IGC 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

IGC: 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  
Table 5. Objects imported into the metadata repository by the SAP BusinessObjects Web Intelligence bridge
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, IGC  
Class BI collection ClassOLAPCollection SA, RM, IGC  
Universe object BI collection member OLAPMember SA, RM, IGC  
Universe filter BI filter OLAPFilter SA, IGC: Displayed as child of BI model  
Hierarchy BI hierarchy OLAPHierarchy SA, IGC 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, IGC

BI hierarchy association: SA

BI level: SA, as child of BI model; IGC as child of BI hierarchy

BI level element: SA

  
Document BI report ReportDef SA, RM, IGC  
DataProvider query BI report query ReportDataSet SA, RM, IGC 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

IGC: 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, IGC

BI report drill-through: SA: displayed as child of BI report field; IGC: 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

IGC: 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