1. What is SAP BOBJ?
SAP BusinessObjects is an enterprise BI platform used for:
✔ Reporting
✔ Data discovery
✔ Dashboarding
✔ Ad-hoc analysis
✔ Data services & scheduling
Core idea: Self-service BI + centralized governance.
2. Key Components of SAP BOBJ
Front-End Tools
- Web Intelligence (WebI) – Ad-hoc reporting
- Crystal Reports – Pixel-perfect, formatted reports
- SAP Lumira – Data discovery & visualization
- Dashboards/Xcelsius – Interactive dashboards
- Analysis for Office (AFO) – Excel-based OLAP analysis
- Explorer – Search-based BI (retired in many landscapes)
Back-End / Platform
- BI Launchpad – End-user portal
- CMC (Central Management Console) – Admin portal
- Information Design Tool (IDT) – Build Universes (.UNX)
- UDT – Legacy Universe design (.UNV)
- SAP BO Repository – Stores security & metadata
- Adaptive Job Server – Scheduling & processing
- Input/Output File Repositories (FRS) – Handles BO files
3. Universe (Semantic Layer) Essentials
Design layers in IDT
- Connection Layer – OLAP/JDBC/ODBC connection
- Data Foundation – Joins, tables, schema
- Business Layer – Objects exposed to WebI users
Key Concepts
- Measures, Dimensions, Details
- Contexts (resolve loops)
- Aliases (avoid fan traps/loops)
- Derived tables
- Prompts (@Prompt syntax)
- Parameters & LOVs
- Aggregate awareness (@Aggregate_Aware)
4. Core Interview Questions (with crisp answers)
1. What is Web Intelligence (WebI)?
A browser-based ad-hoc reporting tool for interactive analysis.
2. Difference between UDT and IDT?
UDT → older tool creating .UNV universes.
IDT → modern tool creating .UNX universes with multi-source support.
3. What is a Context?
A mechanism to prevent fan/traps and loops by defining logical join paths.
4. What is Aggregate Awareness?
A technique allowing BO to pick the most aggregated table for fast performance.
5. What is a LOV?
List of Values – used in prompts to guide user input.
6. What is CMC used for?
Admin tasks: users, roles, rights, servers, auditing.
7. How do you migrate from UNV to UNX?
Using IDT → Convert Universe feature.
8. Can WebI connect directly to HANA?
Yes—via HANA Views (Calculation Views).
9. Difference: Crystal Reports vs WebI?
Crystal: Pixel-perfect, formatted, printing heavy.
WebI: Ad-hoc, analytical, flexible layouts.
10. What is BI Launchpad?
End-user interface for consuming reports, dashboards, and analysis.
5. Scheduling & Publications
Scheduling
- Formats: PDF, Excel, CSV
- Recurrence options
- Email, FTP, BI Inbox delivery
- Calendar-based triggers
Publications (Bursting)
- Dynamic distribution to multiple users
- One report → personalized outputs
- Uses Profiles & Enterprise recipients
6. Security Structure
User Groups
- Designer
- Business User
- Administrator
Rights
- View, Edit, Refresh, Delete, Schedule
- Inherited permissions via groups
Authentication Types
- Enterprise
- LDAP
- Windows AD
- SAP SSO
7. Servers in SAP BOBJ
- CMS (Central Management Server) – brain of BO
- Adaptive Job Server – jobs, scheduling
- Web Intelligence Processing Server – executes WebI
- Input/Output FRS – file repository
- Dashboard Server – Xcelsius
- Crystal Reports Server – Crystal processing
- Adaptive Processing Server – multidomain services
8. Universe Performance Tuning Tips
- Use aggregate tables
- Avoid full outer joins
- Index key columns
- Apply query filters
- Create contexts logically
- Use @Aggregate_Aware
- Minimize multi-source universes unless required
- Use derived tables for complex SQL
9. WebI Interview Short Notes
- Query Panel → Build queries
- Report Panel → Tables, charts, cross tabs
- Variables → Create custom calculations
- Input Controls → Interactive filters
- Breaks vs Sections → Data grouping
- Conditional formatting → Highlights
- Merged dimensions → Combine data from multiple queries
- Trimming data → Subqueries & query filters
10. Most Common WebI Functions
- If(), Where()
- Sum(), Count(), Average()
- Substring(), Replace(), Left(), Right()
- ToNumber(), ToDate()
- Rank()
- RunningSum()
- RelativeValue()
11. Real-Time Scenario Questions
- How do you optimize a slow WebI report?
- How do you handle multiple queries merging?
- Explain how to resolve a loop in a universe.
- Why would you use derived tables?
- How to implement row-level security?
- Difference between report-level filter and query-level filter?
- How do you handle delta loads in universes?
- How would you implement dynamic prompts?
- How do you troubleshoot a failed scheduled job?
- How do you publish a webi report to multiple regions?
12. Quick Memory Grid (15 Seconds Revision)
| Topic | Flash Answer |
|---|---|
| Universe Tool | IDT |
| File Format | .UNX |
| Report Tool | WebI |
| CMS | BO Brain |
| Contexts | Avoid loops |
| Aggregate Aware | Performance |
| Scheduling Tool | CMC |
| Security | Groups + Rights |
| Connection Types | OLAP/JDBC/ODBC |
| Publications | Report Bursting |
Checkout more content on: acorporateguy.com – Prepare For Your Next Interview !!
Follow my content on Linkedin: (2) Vartika Gupta | LinkedIn