Performance isn’t the only thing that suffers as a result of poor universe optimisation and design. So too does ease of use, user adoption and in the worse cases incorrect results are returned.
I’ve seen so many poorly designed universes and most customers are blissfully unaware of the dramatic and negative impact they have. This was one of the reasons why I’ve developed a free web based training course so customers can fix these issues and improve performance and user adoption.
Web based course objectives
The EGI course is designed for ‘Universe Designers’ using Relational (SQL) Universes for XI3 and BI4. On completing the Expert Guided Implementation attendees will be able to improve their existing universes by either an improved understanding of how best to design a universe or by implementing performance and optimisation features explained during the course. Attendees will be able ‘try out’ new ideas or features and validate them within their own environment
What is an EGI?
Expert guided implementation is a new delivery methodology. The methodology balances the combination of training, practical experience and expertise on demand. Focus is to enable the customer to execute complex activities with the help of SAP experts. It is important that during the delivery itself, the activity is executed as described in the delivery slot.
Expert guided implementation enables you to execute activities without being a subject matter expert. The methodology closes the gap between class room trainings and consulting.
For more information on the EGI methodology please go to Support Portal > SAP Solution Manager > Services > Expert Guided Implementation. At the very bottom of the page is also a calendar showing other EGI offerings by time-zone.
Worth attending?
Those that have previously attended this free course, rate it very highly with the average rating of 9 out of 10 for “I would recommend this EGI to others”. Some customers have seen dramatic performance improvements having followed the course, for example a 20 minute query now taking just 3 minutes! Customer quotes include: ”Insightful course, full of great tips on how to improve your universes.” “I have been designing universes for more than 5 years and I still learnt some great tips.”
If you've already attended why not comment about the course and the improvements you've made!
When? And how to register
The web based course runs over 3 days and requires 2 hours each morning
The course is available in different regions of the world. For a full list of dates and registration links please go to https://service.sap.com/sap/support/notes/1809165
What’s the agenda?
Day 1
SAP Expert presents (2 hours morning webinar)
Checking for basic best practice
Universe size, descriptions and formats, list of values, index awareness, WHERE clauses
Execution by customer
Define object formats
Setup List of Values for best practice
Define Index Awareness on objects and in @Prompts
Move WHERE clause logic to the SELECT clause
Add comments to the table structure/Data Foundation
Day 2
SAP expert provides: (2 hours morning webinar)
Aggregations in the right place, non-additive measures
Checking for correct figures, SQL 'Chasm' & 'Fan' trap, Trust Cardinalities, Table Trees
Execution by customer (Remote support in the afternoon)
Check aggregate is occurring in the right place
Layout universe table structure as a table tree.
Correct object SQL and context definitions to ensure correct results
Day 3
SAP expert provides: (2 hours morning webinar)
Advanced SQL and other optimization tips
Loops, Outer joins, Parallel SQL, Automatic creation of derived tables (inline view), ANSI92 SQL, Shortcut joins, Tips & Tricks
Execution by customer (Remote support in the afternoon)
Resolve loops, either with contexts, aliases, derived tables or a “WHERE” clause
Resolve any outer-join issues
Enable JOIN_BY_SQL if query database supports it.
Enable BOUNDARY_WEIGHT_TABLE to automatically create derived tables for very large tables.
Enable ANSI 92 SQL to move joins into the FROM clause.
