A. Universe Design (IDT/UDT)
1. A report is showing wrong numbers after joining two tables. How do you troubleshoot join cardinality, context creation, and loop detection in the Universe?
2. Business wants to restrict users from seeing data from another region. How do you implement row-level security in the Universe?
3. A derived table in the Universe is not updating after a DB structure change. How do you refresh, validate SQL, and ensure database compatibility in IDT?
4. Query performance became slow after adding new objects. How do you analyze aggregate awareness, index usage, and query strips?
🔵 B. Web Intelligence (WebI)
5. A WebI report prompts for the same value multiple times. How do you fix merged dimensions, query filters & prompt linking?
6. Report is taking too long to refresh. What do you check in query script, context pruning, drill filters & universe performance?
7. Conditional formatting is not working for a custom column. How do you identify formula errors, datatype mismatch & variable dependencies?
8. Report shows duplicate rows after adding new fields. How do you troubleshoot merged dimensions, fan traps, and context creation?
9. User says scheduled WebI report is blank but manual refresh shows data. What do you check in scheduling parameters, prompt values & instance database?
🔵 C. Dashboard / Lumira / Design Studio
10. A dashboard is not showing the latest data. How do you review data refresh settings, BEx queries, and OLAP connection caching?
11. Dashboard performance is slow when applying filters. How do you debug data binding, unnecessary components & query size?
12. A story in SAP Lumira is not reflecting newly added measures. What checks do you perform in data acquisition, mapping & data refresh?
🔵 D. Crystal Reports
13. Crystal Report is showing inconsistent totals. How do you analyze summary fields, evaluation time, and section-level formulas?
14. Parameters are not passing correctly to Crystal reports via BO launchpad. What do you check in parameter mapping, SQL commands & prompt groups?
15. User complains that Crystal Report output export to Excel is misaligned. How do you correct section layout, grid alignment, object snapping?
🔵 E. BI Platform Server Administration
16. A user cannot log in to BI Launchpad though their AD login works. What steps do you check in authentication plugin, AD mapping & SSO configuration?
17. BO server becomes slow during peak hours. How do you analyze APS configuration, server sizing, caching & JVM tuning?
18. Audit database is growing too fast and affecting performance. How do you manage audit purging, retention policy & partitioning?
🔵 F. Scheduling & Publications
19. Scheduled report is failing for one distribution group but works for others. What will you check in destination settings, SMTP server logs & personalization filters?
20. A publication is not bursting correctly for regional managers. How do you check profile values, dynamic recipients & prompt personalization?
21. Excel output from scheduled WebI is missing tabs. How do you validate report tabs, formatting options & publication settings?
🔵 G. BO Integration (BW/HANA/DB)
22. WebI report based on BEx query is not showing new characteristics added in BW. What do you check in BICS connection & query refresh?
23. BO reports using HANA views fail intermittently. How do you troubleshoot connection pool exhaustion, HANA timeout & calculation view changes?
24. Data in BO report does not match BW cube. How do you debug filters in BEx, hierarchy versions, and authorization variables?
🔵 H. Security / Access Issues
25. A user can view a report but cannot refresh it. How do you check application rights, data access profiles & Universe/Object level permissions?