Universe Designer is a graphical design tool used to create the rich “semantic layer” (metadata) that makes SAP Business Objects products intuitive for non-technical users. It’s a graphical abstraction of the dimensional models that exist in your data warehouse. It auto-generates the Structured Query Language that interrogates the database tables so that business users do not need to understand this language or even know that it exists.
When the SAP BusinessObjects SAP Integration Kit is installed you can also create a universe based on your SAP Business Information Warehouse data using Universe Designer. This XML based universe will use the MDX language. You can combine the SAP data with your relational data (e.g. Teradata) by synchronisation within Web Intelligence.
Russell Beech, Founder of BI System Builders & Cornerstone Solution®
I architect data solutions and superintend the solutions that I architect. I build teams that are usually a mix of full-time employees and sub-contractors. I ensure mentoring and knowledge transfer. The emergence of big data has opened the door to a rise in interest in predictive analytics aka machine learning. The technology changes have provided the opportunity to architect data solutions which combine enterprise data warehousing experience with data lake concepts and to apply knowledge of statistics to that data to deliver predictive analytics. To that end I’m putting effort into understanding how the evolving technologies hook in to each other. I have a focused interest in big data technologies especially on the Google Cloud Platform. Technologies such as Hadoop, Spark, Apache Beam, BigQuery and Tensorflow (machine learning) and their integration/virtualization with the enterprise data warehouse.
You can find me on LinkedIn here and subscribe to watch BI System Builders videos on our YouTube channel here.