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.
- BusinessObjects Designer
- BusinessObjects Crystal Reports
- BusinessObjects Desktop Intelligence
- BusinessObjects Web Intelligence
- BusinessObjects Information Design Tool
- 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
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 |
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. |
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 |
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 |
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 |