Bo web intelligence with sap bi
Web Intelligence with SAP BI
Applies to:
Web Intelligence XIr3.0
Summary
This document outlines some basic steps with Web Intelligence XI Release 3.0 in combination with a SAP BI landscape. From SDN Community Day @ TechED Berlin 2008 Author: Ingo Hilgefort
Company: Business Objects, an SAP company Created on: October 2008
Author Bio
Ingo Hilgefort started in 1999 with SeagateSoftware / Crystal Decisions as a Trainer and Consultant. He moved to Walldorf for Crystal Decisions by end of 2000 and worked with the SAP BI Development team on integrating Crystal Reports with SAP BW. He then relocated to Vancouver in the year 2004 and worked as Product Manager / Program Manager (Engineering) on the integration of Business Objects products with SAP products. He is now focusing onthe topic of Embedded Analytics for the SAP Solutions.
SAP COMMUNITY NETWORK © 2008 SAP AG
SDN – sdn.sap.com | BPX – bpx.sap.com | BOC – boc.sap.com 1
Web Intelligence with SAP BI
Table of Contents
SAP connectivity for Web Intelligence………………………………………………………………………………………………….3 BW queries and BW cubes. SAP BWmetadata in OLAP Universes ………………………………………………………..3 SAP BW metadata in OLAP Universes ………………………………………………………………………………………………..4 SAP BW OLAP Universes ………………………………………………………………………………………………………………4 Dimension andcharacteristics …………………………………………………………………………………………………………5 Display attributes and navigational attributes …………………………………………………………………………………….7 Hierarchies………………………………………………………………………………………………………………………………….11 Creating a OLAP Universe on top of SAP BI……………………………………………………………………………………….12 Creating your first Web Intelligence report ………………………………………………………………………………………….22 Creating a Web Intelligence report with time dependencies………………………………………………………………….28 Copyright………………………………………………………………………………………………………………………………………..43
SAP COMMUNITY NETWORK © 2008 SAP AG
SDN – sdn.sap.com | BPX – bpx.sap.com | BOC – boc.sap.com 2
Web Intelligence with SAP BI
SAP connectivity forWeb Intelligence
The available SAP data sources for Web Intelligence are: • SAP BW
BW queries and BW cubes.
SAP COMMUNITY NETWORK © 2008 SAP AG
SDN – sdn.sap.com | BPX – bpx.sap.com | BOC – boc.sap.com 3
Web Intelligence with SAP BI
SAP BW metadata in OLAP Universes
SAP BW OLAP Universes The following table shows a list of SAP BW query elements and how these elements are usedin an OLAP Universe. BW Query element Cube Dimension Characteristic (incl. Time and Unit) Hierarchy Keyfigure Calculated keyfigure Restricted keyfigure Navigational attribute Display attribute Query filter SAP variables Custom structure OLAP Universe element Class A class with dimension and detail objects (detail objects for key and description). A class containing a dimension and detail objectsfor each hierarchy level. Measure element in a class named Keyfigures. Measure element in a class named Keyfigures (Information about the calculation is not available). Measure element in a class named Keyfigures (Information about the restriction is not available). A class with dimension and detail objects (detail objects for key and description). Each display attribute becomes a detail object…