The Business Objects Universe is a semantic data model between users and database that stores organization data, this semantic layer contains Objects that represent dimension, detail and measure.
Some advantages of Universe or Semantic Layer are:
1. The objects are represented in Business Terminologies which makes easy for them to create a report.
2. Users don’t need to knowl SQL. Business User can simply drag drop the objects and the tool will generate the required query to fetch the data.
3.Integrated security: All types and security can be applied on Universe making it data secure and only available to related person.
4.Intuitive interface for developers and end-users
5.Maintenance/change management: With the universe model all of your logic is in one place, making maintenance straightforward.
Fundamentally, the universe enables the end-user of BusinessObjects to interact with data without having to understand the complexities of database logic or be familiar with where the physical data is stored.
Now for create your fist Universe we need to open de Information design tool and then go to File>New>Projet
Choose a name and location for the project
Now we need to create a Relational Connection. Go to File> New> Relational Connection. Indicate the Relational Connection’s Name and then click next
Now we need to indicate the Data Provider we want to use, in this case we are going to use the OLE DB Provider for SQL Server 2008
Now we need to create the Business Layer, to do this we need to go to File>New>Business Layer.
Select the type of data source you are going to use, in this case we are going to use a Relational Data Source.
Now we are going to delete the Fact Internet Sales. We only will leave the dimension tables.
In the data foundation, select the connection section and select Change.