1. SAP Lumira Basics
- SAP Lumira is a self-service BI tool used for data visualization and storytelling.
- Built on SAP HANA platform with strong in-memory data processing.
- Two main components:
• Lumira Discovery – Data prep + visualization
• Lumira Designer – Dashboard development (formerly Design Studio)
2. Key Features
- Drag-and-drop data visualization
- Data cleansing & enrichment
- Offline data manipulation
- Predictive analysis integration
- Interoperability with SAP BW, HANA, Universes, Excel, CSV
- Storyboards & infographics for presentation
- Custom scripts via SDK in Designer
3. Lumira Architecture Overview
- Presentation Layer: Charts, tables, infographics
- Application Layer: Data acquisition, manipulation, stories
- Database Layer: SAP BW, SAP HANA, JDBC sources, flat files
4. Data Connectivity
Supports:
- SAP HANA (online & offline mode)
- SAP BW
- .UNX & .UNV Universes
- Excel/CSV
- SAP BEx Queries
- JDBC/ODBC
- BI Platform repository
5. Types of Datasets
- Imported Dataset: Data loaded into Lumira memory
- Live Dataset: Queries pushed to backend (HANA/BW)
6. Data Preparation Functions
- Data merging
- Append vs Join
- Filtering (row, column)
- Calculated columns
- Hierarchies (Geo & Date)
- Clustering / Grouping
- Data cleansing (trim, capitalize, remove duplicates)
7. Common Interview Questions (one-line answers)
Core Concepts
- What is SAP Lumira?
A self-service data visualization tool supporting rich dashboards and predictive integration. - Lumira Discovery vs Designer?
Discovery = Data prep + visualizations; Designer = enterprise dashboards. - What is a storyboard?
A sequence of visualizations presented as a business narrative. - Difference between Live and Imported connections?
Live pulls data from backend; Imported loads data in-memory. - Can Lumira connect to SAP HANA?
Yes — using online or offline acquisition. - What are measures and dimensions?
Measures = numeric fields; Dimensions = descriptive fields. - What is data blending?
Combining multiple datasets to create unified visualizations.
Advanced / Technical
- How to publish a Lumira story?
Using BI Launchpad → Publish to BI Platform. - Explain Lumira server.
Platform for hosting, sharing, and scheduling Lumira stories. - What is SDK in Lumira Designer?
Framework to build custom components and visualizations. - Can Lumira schedule reports?
Yes, through BI platform scheduling. - How is performance improved?
Use HANA views, filtering, aggregation, and minimize imported volumes. - Supported scripting language in Designer?
JavaScript-based scripting for UI logic. - Difference between Lumira & Tableau?
Lumira integrates tightly with SAP stack; Tableau excels in custom UI/visuals.
8. Lumira Designer Key Components
- Canvas: dashboard workspace
- Components: charts, crosstabs, KPIs, filters
- Data Sources: BEx queries, HANA views, UNX universes
- Scripting: OnClick, OnSelect, OnStartup events
- Bookmarks: Save user-level dashboard states
- CSS styling: Custom look & feel
9. Migration / Integration
- Lumira integrates with:
✓ SAP BI Platform
✓ SAP HANA
✓ Predictive Analysis
✓ BW/4HANA (via OLAP connections) - Legacy migration from:
✓ SAP Dashboards (Xcelsius) → Lumira Designer
✓ SAP Design Studio → Lumira 2.0
10. Troubleshooting Must-Know
- Data refresh failures → check backend OLAP connection
- Slow performance → reduce data volumes or enable HANA calculations
- Script errors → verify component IDs
- Universe (.UNX) connection failures → driver mismatch
11. Rapid Q&A Matrix (Memory Pointers)
| Topic | 5-sec Answer |
|---|---|
| Discovery Purpose | Self-service analytics |
| Designer Purpose | Enterprise dashboards |
| Live Data | Real-time backend query |
| Imported Data | In-memory dataset |
| Story vs Dashboard | Story = narrative; Dashboard = interactive UI |
| Geo Maps | Requires geo-hierarchy |
| Publishing | BI Platform |
| Data Merge | Append or Join |
| Hierarchies | Geo / Time / Custom |
| Scripting Language | JavaScript |
Checkout more content on: https://acorporateguy.com/
Follow my content on Linkedin: (1) Vartika Gupta | LinkedIn