This article applies to SAP Business Objects 3.1 SP2 and above. The information mentioned in this document should not be used for SAP BO 4.0 ie Aurora as the format of import and export universe files is different. Please refer to www.sdn.sap.com forums for further information.
Here in this article we will explore the various scenarios related to SAP BO transports. For felicitating movement of BO objects across various system landscapes we can either use Import Export wizard or LCM(Life cycle manager) each method with their individual pros and cons. In this article we will explore method 1 and LCM will be explored in detail in the following article with their advantages and disadvantages.
Author(s): Himanshu Mahajan, Imran Khan
Company: Accenture Services Pvt Ltd
Created on: 28 March 2012
Himanshu Mahajan is a SAP BI/BO consultant currently working with Accenture Services Pvt Ltd. He has varied experience in various BI/BO implementation and support projects
Imran Khan is a Basis BI/BO consultant currently working with Accenture Services Pvt Ltd. He has varied experience in handling various Basis activities in various implementation and support projects
An ideal BI implementation has environments with transport route as follows: Development->Quality Assurance->Production. To move BI objects (Queries, Cubes DSO’s etc) across these systems transport requests needs to be generated and imported into target systems. Even though each BI system has a corresponding Business Objects server installation on top but the transports in BO landscape happen in a much different manner. There are 2 major ways to transport objects across BO landscape namely Import Export wizard and Life Cycle manager each one having its own pros and cons. There are following classifications of possible BO objects which need to be transported:
2) WEBI Reports
3) QAAWS connections/Queries
5) Crystal Reports
6) User Groups etc
Business Objects Transport Method1 via Import Export Wizard
Import Export wizard is used to bring in / send out reports, universes, users etc. from one Business Objects environment to the other environment.
a) All BO objects can be transported along with their dependencies
b) Robust functionality as it allows overwriting of existing versions or making a new copy
a) Connection parameters have to be updated manually else all objects point to the original source system connections
Exploring BO Import/Export Wizard:
Important Note: Below mentioned objects needs to be updated with new connection parameters after importing into the target system
1) Universe Connection
2) QaaWs connection parameters in dashboards
BO transports Step by Step:
Step1: Run Import Wizard from your Business Objects Client tools in the server workstation
Step2: Select the appropriate release(3.x in most BI/BO implementations) and provide source user name and password to be imported from.
Step3: Select type of import ie users with authorizations or BO objects(WEBI, Dashboard etc) and folders
Step4: select second option to use the description to identify new or existing objects.Here you may select appropriate function for update or copying the existing objects. Select Next
Step5: Select Next
Step6: Select the authorization import settings and click next
Step7: Select Next
Step8: Now select the object sthat need to be imported into the target system ie WEBI, Crystal Reports or Dashboards along with relevant folders. Selecting folders selects all underlying BI objects.See below screen shots for various types of objects
Step9: Select appropropriate Qaaws for Crystal Reports and Dashboards
Step9: Select option Import Recipients used by selected Publications and select Next
Step10: Select Next
Step11: Verify the objects and select Next
Step12: Import is successful. Check the error log and resolve errors if any
Follow the above mentioned steps to update the new connection parameters and verify the connections and data.
For more information, visit the Business Intelligence homepage.
© Copyright 2012 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.
Java is a registered trademark of Oracle Corporation.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.
All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies (“SAP Group”) for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.