SAP BusinessObjects is an enterprise business intelligence platform that delivers reporting, analysis, and data visualization capabilities across organizations. The suite combines several tools — Web Intelligence (WebI) for ad-hoc reporting, Crystal Reports for formatted production reports, Universe Designer/Information Design Tool for semantic layers, and the Central Management Console for system administration — enabling users to access, analyze, and share data from SAP and non-SAP sources. A core strength of the platform is its semantic layer abstraction (universes) that shields business users from database complexity, allowing them to build reports using familiar business terms rather than SQL. Critical to understand: proper universe design, security configuration, and performance tuning at both the database and platform layers are essential for scalable, governed BI deployments.
What This Cheat Sheet Covers
This topic spans 15 focused tables and 111 indexed concepts, 106 flashcards. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
A jump-to index of every table row in this cheat sheet.
An interactive map of every table and concept in this topic.
Table 1: Web Intelligence (WebI) Report Design
Web Intelligence is the self-service reporting tool most business users live in, and these are the building blocks for shaping a report once the data is in: how you break and section rows into readable groups, where you filter (report-side after the query versus query-side at the database), and the interactive touches — prompts, input controls, alerters, ranking, and drill — that turn a static table into something a reader can explore. The recurring distinction worth internalizing here is when a filter applies, because it determines both performance and what data stays in the document.
| Technique | Example | Description | |
|---|---|---|---|
Insert → Section → Select [Region] | • Splits report into distinct blocks, one per dimension value • each section can have independent formatting and filtering | ||
Right-click column → Break → Set on [Year] | • Groups rows visually within a table without creating separate sections • supports headers, footers, and subtotals at each break level | ||
Drag [Country] to report filters pane | • Filters data after query execution — removes rows from visible output without modifying SQL • data remains in document and can be unhidden | ||
[Year] In list 2025;2026 in query panel | • Filters at query execution time — reduces data retrieved from database • altering query filters requires refresh | ||
[Region] = | • Interactive query filter that displays dialog at refresh time asking user to select values • drives dynamic report generation | ||
Create input control → Bind to [Quarter] | • Dashboard-style UI widgets (dropdowns, sliders) placed in report or section headers • filter report data interactively without re-running query | ||
Insert → Chart → Select Bar/Line/Pie | • Visual representations of measures • support drill filtering, custom axes, dual-axis combos, and conditional formatting on data points | ||
Define alerter: [Revenue] < 10000 | • Conditional highlighting or notification when measure meets criteria • displays alert icon and enables alert-based filtering in reports | ||
Apply Rank → Top 10 by [Sales] | • Isolates top/bottom N or top/bottom N% of rows based on a measure's value • applied per block and respects calculation context | ||
Enable data tracking → Set reference data | • Compares current data to a saved reference snapshot • highlights new, deleted, and changed values with customizable colors and symbols | ||
Activate drill → Click dimension value | Interactive navigation that modifies underlying query (adds/removes dimensions and filters) to drill up, down, or across hierarchies in real time. | ||
Edit query → Remove unused dimension | • Performance optimization: removes objects from query that aren't used in any report element • reduces database load and improves response time |