- SAP Universe Designer Tutorial
- SAP Universe Designer - Home
- SAP Universe Designer - Introduction
- SAP Universe Designer - Object Types
- SAP Universe Designer - User Interface
- Creating, Editing and Saving
- Creating Parameters
- Creating Schemas
- Table Browser
- Using Derived Tables
- Using Formula Bar
- Universe Building
- List of Values (LOVs)
- OLAP Data Sources
- Using Connection Wizard
- Creating Calculated Measures
- Aggregate Awareness
- Deploying Universe
- Managing Access of Universe
- User and Groups
- UDT vs. IDT Comparison
- unv File to unx File
- Job Responsibilities
- SAP Universe Designer Resources
- SAP Universe Designer - Quick Guide
- SAP Universe Designer - Resources
- SAP Universe Designer - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
SAP Universe Designer - User Interface
When you install BI client tools, Universe Designer is part of client tools and can be opened under SAP BusinessObjects BI Platform Client Tools → Universe Design Tool as shown in the below image −
In above image, you can see Information Design Tool and Universe Design tool both available under SAP BusinessOBjects BI platform client tool. In older version of Business Objects, only UDT was available to design the universe. In BO4.0 or later, Information Design Tool was introduced to add universe created on multiple sources.
In the above image, you can see different options available under Universe Design tool user interface. It has both the "Universe" pane” containing objects and classes usually visible in Web Intelligence/Dashboard designer tool and the "Structure pane" which is only visible in Universe designer.
- Universe Pane
- Structure Pane
In Universe pane, you can further expand each of class to see objects created in it. These objects are named as per business requirement and easy to understand for business users.
In Structure pane, Universe designer drags table and join them to create a schema. This schema view is only visible to Universe Designers and not to business users.
To connect to a data source, connection wizard is used in UDT and you can create multiple connections in UDT however each universe is created using single connection.
Universe design tool provides a graphical interface that allows you to select and view tables in a database. The database tables are represented as table symbols in a schema diagram. You can use this interface to manipulate tables, create joins that link the tables, create alias tables, contexts, and solve loops in your schema.
The following schema types are supported:
- Star Schema
- Snowflakes schema
- Multiple Star schema
Universe are stored in CMS repository and user connects to universe using a web browser. When user connects to Universe, he can access all the data in a database.