IBM Support

Metadata mappings for bridge imports from SAP BusinessObjects

Product Documentation


Abstract

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

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
The tables in this topic explain the metadata mappings for each bridge, including the following information:
  • 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.
For information on importing metadata from BusinessObjects into InforSphere Information Server, V11.3 , see the SAP BusinessObjects Repository bridge reference.

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
SystemBI Server icon BI serverBIServerSA, RM, MW
FolderBI folder icon BI folder BIFolderSA, RM, MW
Universe BI model icon BI model OLAPModelSA, RM, MW, BG
Crystal Reports document
Desktop Intelligence document
Web Intelligence document
BI report icon BI reportReportDefSA, RM, MW, BG


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
UniverseBI model icon BI modelOLAPModelSA, RM, MW, BG 
Class (data classes)BI collection icon BI collectionOLAPCollectionSA, RM, MW, BGCollection type attribute is set to FACT if the source class contains measures, otherwise set to REGULAR.
ObjectBI collection member icon BI collection memberOLAPMemberSA, RM, MW, BGType is set to MEASURE if the instance is from a Measure class. Set to REGULAR if it is from a DimensionAttribute class.
JoinBI join icon BI join

BI join reference icon BI join reference

OLAPJoin
OLAPJoinRef
SA: As child of BI model Two BI join references are created for each BI join.
FilterBI filter icon BI filterOLAPFilterSA, MW: As child of BI model 
Default hierarchy
Custom hierarchy
BI hierarchy icon BI hierarchy

BI hierarchy member icon BI hierarchy member

BI hierarchy association icon BI hierarchy association

BI level icon BI level

BI level element icon 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.
OwnerDatabase schema icon Database schemaDataSchemaSA, RM, MW, BG 
TableDatabase table icon Database table DataCollectionSA, RM, MW, BG 
ColumnDatabase column icon Database column DataFieldSA, RM, MW, BG 
KeyCandidate key icon Candidate key

Key component icon Key component

CandidateKey
KeyComponent
SA, RM, MW, BGKey components are derived from columns that are referenced by the key.
[Object list of values] ValueRule Not displayed
Alias tableAlias icon AliasAliasSA: Displayed in preview. MW: Displayed as property of database table. 
Alias columnDatabase column icon Database column DataFieldSA, RM, MW, BG 
[Class lineage]

NOTE: Not imported or required for lineage at V11.3.
BI collection source icon BI collection sourceOLAPDataCollectionSourceSADerived 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 icon BI collection member sourceOLAPMemberSourceSADerived 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 icon BI reportReportDefSA, RM, MW, BGBoth report and subreport in Crystal Reports become BI report in the metadata repository.
ReportFieldsBI report query icon BI report queryReportDataSet 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 icon BI report query itemReportDataItemSA, RM

MW, BG: Displayed as BI query member

Represents the data contents of fields in the report.
ReportField (display headings)BI report field icon 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 icon 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 icon BI collection memberOLAPMemberSA, RM, MW, BG
Report filterBI filter icon BI filterOLAPFilterSA, MW: Displayed as child of BI model 
TableLinkBI join icon BI join

BI join reference icon BI join reference

OLAPJoin

OLAPJoinRef

SA: Displayed as children of BI modelsTwo BI join references are created for each TableLink.
UniverseBI model icon BI modelOLAPModelSA, RM, MW, BGFor reports that are sourced from universes.
Class
QueryTable
BI collection icon BI collectionOLAPCollectionSA, RM, MW, BG
Alias tableAlias icon AliasAliasSA: Displayed in preview. MW: Displayed as property of database table. 
Alias columnDatabase column icon Database column DataFieldSA, RM, MW, BG 
[QueryTable lineage]

NOTE: Not imported or required for lineage at V11.3.
BI report query source icon BI report query sourceReportDataSetSource SA 
[QueryTable column lineage]

NOTE: Not imported or required for lineage at V11.3.
BI report query item source icon BI report query item sourceReportDataItemSourceSA 


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
UniverseBI model icon BI modelOLAPModelSA, RM, MW, BG
ClassBI collection icon BI collectionOLAPCollectionSA, RM, MW, BG
Universe objectBI collection member icon BI collection memberOLAPMemberSA, RM, MW, BG
Universe filterBI filter icon BI filterOLAPFilterSA, MW: Displayed as child of BI model
Document BI report icon BI reportReportDefSA, RM, MW, BG
DataProvider
Query
BI report query icon BI report queryReportDataSetSA, RM, MW, BGEach 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 icon BI report query itemReportDataItemSA, RM

MW, BG: Displayed as BI query member


CellBI report field icon 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 icon 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 icon BI report query sourceReportDataSetSource SA 
[DataProvider query lineage]

NOTE: Not imported or required for lineage at V11.3.
BI report query item source icon BI report query item sourceReportDataItemSourceSA 


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 icon BI model
SA, RM, MW, BG
Class
BI collection icon BI collection
ClassOLAPCollectionSA, RM, MW, BG
Universe objectBI collection member icon BI collection memberOLAPMemberSA, RM, MW, BG  
Universe filterBI filter icon BI filterOLAPFilterSA, MW: Displayed as child of BI model 
HierarchyBI hierarchy icon BI hierarchyOLAPHierarchySA, MWBI level elements are created from the relationships between the hierarchy elements and objects.
Hierarchy elementBI hierarchy member icon BI hierarchy member

BI hierarchy association icon BI hierarchy association

BI level icon BI level

BI level element icon 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 icon BI reportReportDefSA, RM, MW, BG 
DataProvider
query
BI report query icon BI report queryReportDataSetSA, RM, MW, BGEach 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 icon BI report query itemReportDataItemSA, RM

MW, BG: Displayed as BI query member

 
Formula cellBI report field icon 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 icon 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 icon BI report query sourceReportDataSetSource SA 
[DataProvider query column lineage]

NOTE: Not imported or required for lineage at V11.3.
BI report query item source icon BI report query item sourceReportDataItemSourceSA 

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27036883