Utilizing business terms and definitions already stored in a business reporting model it is possible to automatically derive a formal business glossary. The first of such tools based on semantic technologies and metadata stored in MMX Metadata Repository now supports SAP Business Objects Universes.
Many top-down business terminology design initiatives suffer with lack of interest and details or missing touch of realty. The existing reporting environment or the BI system might be good idea to look for business terms, definitions and database object relations. The bottom-up approach might be the fast and right way to document real-life terminology or a solid base for mixed approach and further manual management of the business terminology. We need a methodology and a technology to take the challenges like integration and consolidation of similar terms or BI system inner life and dependencies with database objects.
We introduce the working solution for the SAP Business Objects Universes to collect and consolidate the BO definitions, generate business reporting glossary and create relations between concepts, implementations, reports and database objects. The used methodology based on semantic integration technologies and it's tested many times in real-life environments. The main components of the solution are following:
The following illustration (Figure 1) contains the main idea and the components of the solution and DW environment:
Figure 1. Reporting Glossary Automation and Usage.
We point out some figures from the case studies which should illustrate the effect of the automated solution:
To conclude the use case we can see the 80:20 ratio between the real system definitions and consolidated concepts. The four times smaller amount of the managed business concepts (compared to all BO definitions) is the good start for business glossary management where small amount of meaningful definitions is connected to large amount of technical objects and implementations. Another magic effect comes form the BO formal query definitions that allows us to connect concepts with db views and tables and it gives the meaning and business semantics to the db structures.
MMX Framework Business Objects metadata scanner is designed for and works with: