Skip to main content Skip to complementary content

SAP BusinessObjects Desktop Intelligence (Repository) - Import

Availability-note AWS

Bridge Requirements

This bridge:
  • is only supported on Microsoft Windows.

  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor SAP
Tool Name BusinessObjects (BO) Desktop Intelligence
Tool Version 6.x to 12.x
Tool Web Site http://www.sap.com/solutions/sapbusinessobjects/large/intelligenceplatform/bi/qra/desktop_intelligence/
Supported Methodology [Business Intelligence] BI Report (Relational Source, Dimensional Source, Expression Parsing, Report Structure) via COM API
Data Profiling
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection

SPECIFICATIONS
Tool: SAP / BusinessObjects (BO) Desktop Intelligence version 6.x to 12.x via COM API
See http://www.sap.com/solutions/sapbusinessobjects/large/intelligenceplatform/bi/qra/desktop_intelligence/
Metadata: [Business Intelligence] BI Report (Relational Source, Dimensional Source, Expression Parsing, Report Structure)
Component: BoReporterRepo version 11.2.0

OVERVIEW
The bridge relies on the Business Objects Desktop Intelligence COM/OLE API to import the Report metadata. Therefore, BusinessObjects Desktop Intelligence must be properly installed on the machine executing this bridge.

REQUIREMENTS
WARNING: This bridge uses the COM API of a Windows based tool client and/or SDK which must be (a) properly installed, (b) licensed on behalf of a Windows user capable of running this tool, and (c) capable of accessing the tool server content. In addition:
(1) As recommended by the tool vendor, the tool server must NOT be installed/coexist on the same machine where the tool client (and the bridge) is installed/running because of potential conflicts of resources, including with respect to COM API.
(2) Windows COM API based tools are notoriously unstable after repeated failures or lack of system resources, which requires a Windows reboot to make that tool COM API work properly again.
(3) If this bridge is running as an application, then it must be logged with the same above Windows user.
If the bridge is running as a Windows service, then go to the services manager of Windows, right-click on the MIMB Application Server service, and go to the "Log On" tab to define an account by name under which the service will run.

If unsure whether SAP Desktop Intelligence is installed properly, be sure to check the following:
- SAP Desktop Intelligence must be executable as a Windows application on the machine which the bridge runs on. It generally is installed as part of the BO "desktop" tools.
- For the API to work, SAP Desktop Intelligence must be executable as a COM/ActiveX component, i.e., the COM/ActiveX component must be properly registered. You may check that a key exists in the Windows registry in HKEY_CLASSES_ROOT\BusinessObjects.Application.

There is a tool available from SAP BusinessObjects which can test for some connectivity issues. Go to Start -> All Programs -> Business Objects XI -> Diagnostic Tool. You must login with the same credentials as you use with the MIMB bridge. Then go to the menu Tests -> Run All Tests. You should see that all tests 'Pass'.

In addition, one may customize the configuration file used to control what tests are performed. It is located at C:\Program Files (x86)\Business Objects\common\4.0\java\lib\TestClasses.xml in the default SAP BusinessObjects client installation.

If any of these tests fail, please contact the local SAP BusinessObjects Administrator to resolve these issues. Please refer to Chapter 5, 'Working with Firewalls' in the SAP BusinessObjects Administration Guide.

Also, at bridge runtime be sure that you have:
- A valid login access to a BO repository server (the bridge must login to the BO platform)
- For BO 5.x, 6.x, 11.x, 12.x, there is the option of connecting in standalone (no CMS) mode.
- For BO 11.0 there is no standalone mode and you must have a valid login.

FREQUENTLY ASKED QUESTIONS
Q: What username and password should I supply into the BO login window?
A: If the current installation of BusinessObjects is a network installation with a BusinessObjects Repository managing users and access rights, please provide a BO username and password, exactly like you would do when opening the report document directly in Desktop Intelligence. If you are not sure about which user name and password to use, ask the BO 'supervisor' person in your company who manages the BO Repository, or ask the person who designed this report document, they should be able to help you.

Q: The bridge fails to complete for an unknown reason, what can I do?
A: Please try to run the bridge again with parameter 'Execution mode' set to 'Interactive'. The application may display an error in a pop-up window.

Q: What report file formats does this bridge support?
A: This bridge can read the report formats supported by SAP BusinessObjects Desktop Intelligence:
- BusinessObjects documents (*.rep)
- BusinessObjects document templates (*.ret)
- BusinessQuery Files (*.bqy)
- WebIntelligence 2.x documents (*.wqy)

Q: What report file formats are not supported?
A: BusinessObjects Desktop Intelligence and this bridge do not support:
- WebIntelligence 6.x documents (*.wid)
- Crystal reports (*.rpt)
- Crystal OLAP Analysis reports (*.car)

Q: How should I understand the warning message: Could not import reference to universe '' for Data Provider 'Query 1'?
A: If the report being imported depends on a universe that is stored in the BO repository and you specify the 'Repository authentication mode' bridge parameter to be 'Standalone', it is not possible to retrieve the dependencies on the universe. To retrieve the dependencies of a report based on a universe located in the BO repository, it is necessary to set this parameter to one of the login values and provide a Repository username and Repository password.

Q: Can this bridge run from an application server as a Windows service?
A: No, Desktop Intelligence is a desktop application, running the COM API and this bridge as a service is not supported. Please make sure that if running from a remote bridge server, it is configured to run as a regular desktop application, not as a service.

LIMITATIONS
Refer to the current general known limitations at MIMB Known Limitations or bundled in Documentation/ReadMe/MIMBKnownLimitations.html

SUPPORT
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6

Q: How do I provide information to help the support team reproduce an issue?
A: Provide the following files:
- For BusinessObjects 5.x and 6.x, open the document in Desktop Intelligence, select 'Save for all users', and save it as an REP file.
- For BusinessObjects Desktop Intelligence 11.x and 12.x (XI), create a Business Intelligence Archive file (*.BIAR) using the BusinessObjects Import Wizard utility (ImportWiz.exe) and include the document in it.


Bridge Parameters

Parameter Name Description Type Values Default Scope
System Enter here the name of the BusinessObjects repository to login to.

- For BusinessObjects version 11.x and 12.x (XI), it is the name of the Central Management Server. This server will be used to login, by default on port 6400. E.g.
localhost

If the CMS server is configured in a Cluster environment, the cluster name may be specified with the following syntax: cms:port@cluster. E.g.
localhost:6400@MYCLUSTER

- For BusinessObjects version 5.x and 6.x, it is the name of the repository defined by the Supervisor application. E.g.
bomain

If this parameter is empty, Desktop Intelligence will perform an Offline login. A standalone installation of BusinessObjects does not require you to login.
STRING     Mandatory
Authentication mode Select the login authentication method.

This parameter is only applicable to version 11.0 and greater.
For versions 5.x and 6.x, this parameter is ignored.

'Enterprise'
BusinessObjects Enterprise login.

'LDAP'
Login using an LDAP server.

'Windows AD'
Login using a Windows Active Directory server.

'Windows NT'
Login using a Windows NT domain server.

'Standalone'
Standalone (no CMS).
ENUMERATED
Enterprise
LDAP
Windows AD
Windows NT
Standalone
Enterprise  
Username A repository installation of BusinessObjects (BO) requires the user to identify himself/herself using a login. A standalone installation of BO does not require such identification. E.g.
supervisor

If you omit the username or password, a BO Login dialog box will be displayed, in which you should enter your usual BO login username and password.

In order to avoid Desktop Intelligence to prompt the Login dialog box when running this bridge remotely on a server, you should fill this parameter value.
STRING     Mandatory
Password A repository installation of BusinessObjects (BO) requires the user to identify himself/herself using a login. A standalone installation of BO does not require such identification.

If you omit the username or password, a BO Login dialog box will be displayed, in which you should enter your usual BO login username and password.

In order to avoid Desktop Intelligence to prompt the Login dialog box when running this bridge remotely on a server, you should fill this parameter value.
PASSWORD      
Document repository path Used to access a document stored in a remote BusinessObjects Repository.

Specify here the path of the document, and the bridge will connect to the Repository, receive (download) the document, and read its metadata.

For Business Objects version 11.x and 12.x (XI), the format of document path is: {FolderName/}*DocumentName. E.g.
Report Samples/General Business/MyDocument

For Business Objects version 5.x an 6.x, the format of documents path is: DocumentDomain/DocumentName. E.g.
Document/EFASHION
STRING     Mandatory
Silent execution Specify whether to execute in interactive or silent mode.

'Silent'
The application runs in silent mode, pop-up windows and message boxes are blocked. This mode does not require user intervention, but may cause execution termination with unknown error.

'Interactive'
The application runs in interactive mode, allowing pop-up windows and message boxes. This mode may require user intervention to acknowledge pop-up windows, and allows the user to resolve issues during execution.
ENUMERATED
Silent
Interactive
Silent  
Close after execution Close the Business Objects application after importing the model. By default the tool will be closed.

'False'
The application is left open on the desktop after the bridge has run.

'True'
The application is closed after the bridge has run.

Note that the application is started on the same machine where this bridge is running.

If running this bridge remotely on a distant server, this parameter should be set to 'True', otherwise the application will be left running on the server.
BOOLEAN   True  
Include List of Values This parameter controls how the bridge should import the List of Values associated to Objects. Since the target tool may not be able to display such a list, this algorithm is not enabled by default. Importing the List of Values via the BusinessObjects API also requires more time to perform the import. BOOLEAN   False  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"SAP BusinessObjects Desktop Intelligence (Repository)"
Metamodel
BoReporter
Mapping Comments
     
Attribute Column A Table Column may be inferred from the parsing of a SQL DataProvider query
Name Name  
BaseType Object Type  
DataType   See datatype conversion array
Name   Based on the datatype
PhysicalName   Derived from the datatype
Class Table A Table may be inferred from the parsing of a SQL DataProvider query
Name Name  
ClassifierMap   ClassifierMap objects are used to hold the lineage of DataProviders, Queries, DocumentVariables
Operation expression text can be a BO native expression or a SQL statement
Condition Universe Filter  
Name name  
DataAttribute DataProvider Column, Query Column  
Name name  
Position position  
DataSet DataProvider, Query Each DataProvider is imported as DataSet. Each of its queries is also imported as lower-level DataSet
Name name  
DatabaseSchema Database schema May be inferred from the parsing of a SQL DataProvider query
Name Name  
DerivedType List Of Values The import of Objects' ListOfValues is controlled by a bridge option
DataType   See datatype conversion array
DesignPackage Universe Class DesignPackages reflect the reporting objects organization hierarchy as in the Reporter tool, as well as the Class structure of objects used from a Universe
Name name  
UserDefined   set to True for Universe Classes
Dimension Universe Class  
Description description  
Name name  
UserDefined   set to True
DimensionAttribute Universe Object other types of objects as imported as regular dimension attributes
Description description  
Name name  
FeatureMap   FeatureMap objects are used to hold the lineage of DataProvider columns, Query columns and DocumentVariables
Operation expression text can be a BO native expression or a SQL statement
Filter Universe Filter  
Description description  
Name name  
Measure Universe Object Objects of type measure are imported as measures
Description description  
Name name  
OlapSchema Universe Represents the universes this document depends on
Report Document  
Description Description  
Name Name  
ReportAttribute Formula, Variable, Constant  
Name Name  
ReportAxis Chart Axis Corresponds to the Pivot information of each Block displayed on pages
ReportChart Chart  
Name Name  
ReportDataSet Formula, Variable, Constant Groups of Formulas, Variables, and Constants
ReportField Cell  
ReportMatrix CrossTab  
Name Name  
ReportPage Report  
Name Name  
ReportPageBody Report main section  
ReportPageFooter Report footer  
ReportPageHeader Report header  
ReportRectangle Section Generic report item representing presentation structure
ReportTable Table  
Name Name  
ReportText Cell  
Value textual value  
StoreConnection Database May be inferred from the parsing of a SQL DataProvider query
Name Name  
StoreModel Document  
Comment comments  
Name name  
TypeValue List Of Values The import of Objects' ListOfValues is controlled by a bridge option
Value value  

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!