Create an SAP BusinessObjects Multi-Source Universe – A Step-by-Step Guide

  • by Abhijit Ingale, SAP Analytics Technical Architect, Tata Consultancy Services
  • Vinayak Gole, Senior Business Intelligence Consultant, Tata Consultancy Services
  • November 2, 2017
With the exponential growth of data from multiple sources, using conventional methods for extracting it is time-consuming, costly, and resource intensive. SAP has simplified Multi-Source Universes in SAP BusinessObjects 4.0 as an answer to this issue. Created with the Information Design Tool (IDT), a Multi-Source Universe can combine data from SAP Business Warehouse (SAP BW) with other relational databases, such as Oracle and SQL Server. See how to create a Multi-Source Universe in this step-by-step guide.
Learning Objectives

Reading this article, you will learn about:

  • The concept of a Multi-Source Universe
  • Advantages and limitations of a Multi-Source Universe
  • How to create a Multi-Source Universe
Key Concept

SAP simplified Multi-Source Universes with the release of SAP BusinessObjects 4.0 by enabling the querying of data drawn from data sources in SAP systems and non-SAP systems without going through the lengthy Extract, Transform, and Load (ETL) cycle. This enables a quick turnaround for business reporting requirements.

Big Data technologies combined with Internet of Things complement business functions by providing insights into processes through data. As these sources of data increase, so do reporting needs. Varied reporting needs require the merging of data sets to comprehend relationships and insights into the data. As the demand for shorter turnaround times to answer specific business queries grows, the requirement to build solutions quickly has been increasing. SAP BusinessObjects provides this functionality to quickly merge multiple data sources to present a single version of truth to answer the business queries through Multi-Source Universes.

Multi-Source Universes extract data from multiple sources and present it in a single semantic layer. Prior to the release of the SAP BusinessObjects 4.0, Multi-Source Universes had to be developed using the Data Federator application, a separately licensed product. With Business Objects 4.0, Data Federator is integrated in the Information Design Tool (IDT) and therefore doesn't require an additional license.

Built on underlying data sources, the Universe, also known as a semantic layer, enables the business user to understand data in familiar business terms. Accessible across a variety of SAP BusinessObjects tools, such as Web Intelligence, Design Studio, and SAP Lumira, a Universe builds a common platform that provides relevant business information to users across hierarchies and functions.

Abhijit Ingale

Abhijit Ingale is an experienced SAP analytics technical architect. He has more than 12 years of IT experience in designing, developing, and managing many complex software solutions including more than seven years of experience with SAP Analytics applications. He has been associated with many SAP Analytics implementation programs in various capacities across different geographies while working with some of the leading global IT organizations such as Tata Consultancy Services, Hewlett Packard, and Patni Computers. His core expertise includes SAP BusinessObjects, SAP HANA, and SAP BW. He holds a bachelor of engineering degree in Information Technology from the University of Mumbai. He is SAP certified in Enterprise SAP HANA Modeling and Business Intelligence with SAP BW and SAP BusinessObjects. He also a certified SAFe Agilist.

See more by this author

Vinayak Gole

Vinayak Gole is a senior Business Intelligence consultant with 15 years of experience in IT across multiple business domains. Part of the global SAP Analytics Center of Excellence at Tata Consultancy Services, Vinayak has been engaged in architecting solutions on SAP Business Objects suite including Lumira and Business Objects cloud.  

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.