Integrating with SAP BusinessObjects

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Access data from SAP BusinessObjects Universe

SAP BusinessObjects Integration Scenario

The SAP BusinessObjects Business Intelligence platform is a flexible and scalable solution for delivering information to end users, in multiple forms including dashboards and interactive reports, via any web application—intranet, extranet, Internet, or corporate portal. The platform delivers tangible benefits extending across and beyond the organization, as an integrated suite for reporting, analysis, and information delivery. It also provides a solution for increasing end-user productivity and reducing administrative efforts. For example, it is used to distribute weekly sales reports, to provide customers with personalized service offerings, or to integrate critical information in corporate portals.

SAP BusinessObjects Business Intelligence on-premise solutions work with SAP Analytics Cloud in a Hybrid Analytics scenario. In the long term, SAP has strategically positioned SAP Analytics Cloud as the Augmented Analytics tool. Meanwhile, SAP continues to deliver innovations with SAP BusinessObjects 4.3 as part of a hybrid Analytics configuration. This configuration allows SAP Analytics Cloud to access on-premise Universes and Web Intelligence Documents as a data source.

SAP BusinessObjects Enterprise Live Data Connection

SAP BOE Live Data Connect enables a live connection to on-premise data sources and allows customers to reuse existing data, queries, and security without moving the data to cloud. BI 4.3 allows customers to use both universes and Web Intelligence data models to build SAC Stories.

SAP BusinessObjects, Private Cloud Edition

SAP will continue to enhance SAP BusinessObjects BI Suite (BI 4.3) in the subsequent releases until the end of 2027, providing one of the longest maintenance timelines in the industry. The product will then evolve into a managed cloud subscription only, as part of the SAP BusinessObjects Enterprise, Private Cloud Edition (BOE PCE). BOE PCE allows customer options to shift their on-premise workloads to a managed cloud environment and will continue to evolve and be supported beyond 2027. In addition, BOE PCE also provides the option to leverage existing on-premise investments from the managed cloud environment:

SAP BusinessObjects BI 4.3 allows administrators to easily onboard on-premise users to the cloud and to keep them synchronized with their identity provisioning system.

Live Data Connection - BOE PCE Solution

The Live Data Connection for BusinessObjects Enterprise, Private Cloud Edition includes Universes, Calculation Views, ABAP CDS Views, and BW queries. To support hybrid scenarios, Live Data connection connects to both on-premise as well as cloud data.

BOE PCE runs on the same software used by on-premise BI 4.3 with identical user interfaces, but runs as a managed private cloud solution hosted by SAP or Hyperscaler partners (AWS, AZURE, GCP). To connect SAP Analytics Cloud to BusinessObjects Private Cloud Edition the following components are required to be deployed in managed cloud environments:

  • The SAP Cloud Connector
  • The SAC Agent
  • BusinessObjects Live Data Connect

These required components are now included as an optional deployment with the Private Cloud Edition SKUs. They are considered optional and not provisioned by default as some customers may have them deployed as part of SAP S/4HANA. The SAP Cloud Architect and Advisor (CAA) provides the technical requirements to each BOE PCE solution.

Live Data Connection - SAP Universes

Live Data connection can connect to a SAP Business Objects Universe model and be used to create stories.

Universe is a an organized collection of metadata objects that enable business users to analyze and report on corporate data in a nontechnical language. These objects include dimensions, measures, and attributes. The metadata object layer, called the business layer, is built on a relational database schema or an OLAP cube. The objects map directly to the database structures via SQL or MDX expressions. A universe includes connections identifying the data sources so queries can be run on the data.

SAP Universe Integration

SAP Analytics Cloud can be integrated with many SAP systems, including the SAP BusinessObjects BI platform.

The SAP BusinessObjects universe is one of the BI platform's semantic layer options and is able to connect to almost any datasource, both SAP and non-SAP. With SAP Analytics Cloud's ability to connect to universes, BI platform customers can leverage their on-premise BusinessObjects system with SAP Analytics Cloud's cloud-based modeling and analytics capabilities.

Most data preparation should be done within the universe, including data optimization and data enhancement, before using the universe in SAP Analytics Cloud.

General Considerations

Let's explore the SAP Analytics Cloud - SAP Universe connections.

Watch this video to learn how to integrate an SAP universe.

Create the Universe Connection

To connect to a universe, first create the appropriate connection. Once you have the connection, create a universe query to identify the data required by the SAP Analytics Cloud model.

Watch this video to learn how to create a model from an SAP BusinessObjects universe query.

Create an Analytic Model from a Universe

You need to acquire and wrangle weekly data from a universe into an analytic New Model. The weekly data should be organized in a time hierarchy with a 4-4-5 pattern. The data only needs to be analyzed therefore, a planning model is not needed.

Task Flow

In this exercise, you will perform the following tasks:

  • Create an Analytic New Model
  • Enable a week-based data pattern of 4-4-5
  • Allow data for 2014 to 2023 with a week granularity
  • Import data from a universe
  • Wrangle data by concatenating the month and year data for the Date dimension
  • Create model-specific calculations
  • Create a Story using your model

Save progress to your learning plan by logging in or creating an account