Building Queries on Universes

Objective

After completing this lesson, you will be able to Use a universe as data source.

Use a Universe as Data Source

Web Intelligence makes it easy for you to access your corporate data by enabling you to work with familiar business terms to retrieve data from a database rather than using technical code required by the data source. One of the possible methods Web Intelligence uses to accomplish this task is to use a universe.

An universe is the semantic layer that maps everyday business terms to the data stored in the database. Using a universe, you can retrieve data that interests you by dragging and dropping the desired objects.

In your company, universes are created by a universe designer using the Information Design Tool. The designer then makes the universes available to you and other users in your organization so that you can select the appropriate business terms to create queries and retrieve data from the database. Within each universe, these business terms are listed as objects, while similar types of business terms are grouped into classes.

In SAP BI 4.3, the start of the procedure, to build a query on a universe, is different. On the BI Launch Pad home screen, scroll down to the Applications section and click Web Intelligence.

In the Select a Data Source dialog box, click SAP BI Platform Repository, select Universe on the right, click OK, and use the browser to select a universe.

Drag the dimensions, attributes and measures you want to include in the query into the Result Objects pane and click Run.

When you have more than one query and you want to run just one query, click the down arrow next to the Run button and select the query that you want to run.

Watch this video to learn how to build queries on universes:

Log in to track your progress & complete quizzes