Posted on

Increased Performance Through Optimised Universe Design

SAP Business Objects Universe

SAP Business Objects UniverseThe SAP BusinessObjects universe sits between the reporting tool e.g. Web Intelligence and the data warehouse. It is a type of graphical abstraction of how the data warehouse tables and relational joins would look if they could be viewed with the naked eye.

The critical function of the universe is explained by its other name, the semantic layer. All data warehouse platforms are interrogated through some type of code. The universe generates code (hence semantic) so that a query can be issued against the data warehouse. This code will be in the form of Structured Query Language (SQL) for relational platforms and Multi Dimensional eXpressions (MDX) for OLAP based universes.

The powerful feature of the universe is that the business information consumer does not need to understand data warehouses or write code. The business user simply drags and drops objects of interest from a side panel on to their report page, e.g. sales revenue and location objects to generate a table displaying sales revenue by location. The universe generates the code automatically behind the scenes.

However, the optimization of the code generated will be dependent upon the structure of the data warehouse tables and universe configuration for relational tables and the cube and query design for OLAP sources.

Whilst it is possible to generate a SAP BusinessObjects universe in a few minutes using an automation wizard, the resultant performance of queries may be disappointing. By performance is meant fast queries that return accurate data sets.

With experience it is possible to gain a tool box of best practice techniques to build a universe designed for performance. As a universe designer a good starting place is to build a query and then to ask:

What does the code generated by my universe look like?

If I were to write it freehand in an optimised way, would it be different?

Do I need to change the universe configuration or data warehouse structure to achieve optimised query code?

Leave a Reply

Your email address will not be published. Required fields are marked *