After completing this lesson, you will be able to:
The SAP BusinessObjects BI solution consists of different client tools for specific use cases and the SAP BusinessObjects BI platform server that provides functionality including a central repository, user management, security, and reports scheduling.
The SAP BusinessObjects Suite includes a collection of reporting and analysis tools. Each tool has features that target different types of users or use cases, but there is overlap among the tools, and customers are not required to deploy all the tools to use the suite effectively. This figure shows what type of functionality is available and what SAP BusinessObjects tool provides this functionality.
Before it can be consumed, content must be created. To be beneficial, it must be both controlled (to provide a single version or definition of raw data) and flexible to encourage use of the tool.
A good model for meeting these requirements is to have some formality to the creation and initial presentation of the content, with the power to have end-user customization and personalization.
Powered by sophisticated models and machine learning technology, SAP Analytics Cloud reveals insights that help you make data-driven decisions with confidence.
For on-premise solutions, mainstream Priority 1 support will be available through 2027. We recommend transitioning analytic application and data discovery use cases to SAP Analytics Cloud for developing dashboards and application.
The tools in the BI Suite are web and mobile-enabled, some users require the power of Microsoft Excel or PowerPoint. For these users, the SAP Analysis for Microsoft Office tool set provides access to a range of OLAP data sources and allows users to combine information from different systems within a single workspace.
With SAP BusinessObjects Analysis for Microsoft Office Features you can:
SAP Crystal Reports is a Windows-based report design tool that builds reports that look exactly the way you want through pixel-perfect positioning, layout, and templates. You can include reports with charts, visual elements, and interactivity such as drill-down and filtering.
SAP BusinessObjects has reporting and analytics tools, but behind the scenes, software running on servers perform supportive tasks to manage and generate the output used to analyze the data.
This collection of hardware and software components makes up what SAP collectively calls the SAP BusinessObjects Platform (BIP). The BI Platform sits on "top" of your data because it provides and secures connections to the underlying systems that hold your data.
You can integrate the SAP BusinessObjects BI Platform with SAP Analytics Cloud in a hybrid approach such as using data discovery in SAP Analytics Cloud, and operational reporting with the SAP BusinessObjects platform. The SAP Identify Provisioning Service can provision and synchronize BI platform users to SAP Analytics Cloud, and enable SAP Analytics Cloud users to access on-premise data.
The semantic layer enables business users to access data autonomously without being familiar with the structure and technical characteristics of the respective data source. For this study, BW queries, universes, and HANA views qualify as semantic layers.
The objective of a semantic layer is to provide a common adaption layer that allows business users to have a common experience across the different clients, sources, and types of information.
The Purpose of the Semantic Layer in SAP BusinessObjects BI
The SAP Business Warehouse (BW) is a system that uses a separate database to stage information from various data sources such as databases, online services, and the internet for the purpose of data reporting and analysis.
Data is staged in various forms, including personalized reports, freely definable queries, and predefined reports. Users can analyze data for key facts.
For example, a data warehouse in the retail sector can be used to do the following:
SAP HANA combines database, data processing, and application platform capabilities in memory. The platform provides libraries for predictive, planning, text processing, spatial, and business analytics. This architecture enables converged Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) data processing within a single in-memory, column-based data store with ACID (atomicity, consistency, isolation, durability) compliance, while eliminating data redundancy and latency.
By providing advanced capabilities, such as predictive text analytics, spatial processing, and data virtualization, on the same architecture, it further simplifies application development and processing across big data sources and structures.
Some unique features of SAP HANA’s in-memory technology are to store massive amounts of information compressed in main memory, utilize parallel processing on multiple cores, and move data intensive calculations from the application layer into the database layer for even faster processing. Since all the detailed data is available in main memory and processed on the fly, there is no need for aggregated information and materialized views, fundamentally simplifying the architecture and hence reducing latency, complexity, and cost.
SAP BUSINESSOBJECTS UNIVERSE provides open and agnostic access to all corporate databases, data warehouses (including SAP BW), and applications. It also enables a consistent business user experience. A universe creates the code that accesses the data for the reporting tools.
A universe contains no data but rather points to a data source, such as a database, data warehouse, OLAP cube, and other sources. It is typically comprised of three components: