Building a Query based on a Universe

Objective

After completing this lesson, you will be able to create and save documents

Universes, Objects, and Data

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.

New Document: See text after image for more details.

An SAP BusinessObjects 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 folders.

The correspondence between objects and data: See the text before and after the image for more details.

Objects are elements in an SAP BusinessObjects universe that correspond to the data in the database. Ideally, the universe designer names the object with business terms that you use in your daily activities, such as Sales revenue or Customer name. You use these objects to build queries and retrieve the data you want to show in your report.

The components of a universe are as follows:

  • Folders and Sub-folders organize objects into logical groups.
  • Objects are elements that map data in a relational database and are named using familiar business terms. For example, named objects in the eFashion universe include Year, Quarter, and Sales revenue.
The components of a Universe: See text after image for more details.

The types of objects are as follows:

  • Dimension: A Dimension object retrieves the data that provides the basis for analysis in a report. Dimension objects typically retrieve character-type data, for example, Customer name, Store name, or Date.
  • Attribute: An Attribute object provides descriptive data about a Dimension. An Attribute is always attached to the Dimension object for which it provides additional information. For example, the Customer name Dimension can have Age and Address detail objects associated with it because those objects provide additional information about a customer.
  • Predefined Query Filters: A Predefined Query Filter restricts the information returned by objects, such as limiting data pertaining to revenue of a specific year. Filters can also prompt the person viewing the report to select a value, such as the Which product? query filter.
  • Measure: A Measure object retrieves numeric data that results from calculations on data in the database. For example, Sales revenue is the calculation of the number of items sold multiplied by the item price. Measure objects are often located in Measures folders.

Query Panel

Watch this video to learn about the Query Panel.

Query Process

You run queries that were built in the Query Panel to return data to the document for presentation and further analysis.

When using the web client, these queries are sent to a Processing Server (part of the SAP BI Platform) and then forwarded to the data source.

The Processing Server takes the data returned from the data source and places the results in a data provider. You can then interact with this data in the Web Intelligence client.

This process repeats each time you refresh the query.

The Web Intelligence Query Process: See text before image for more details.

Procedure: To Build a Query based on a Universe

Follow these steps to build a query based on a universe: 

  1. On the BI Launch Pad home screen, choose Applications.
  2. Choose Web Intelligence.

    The Select a Data Source screen appears.

  3. Choose SAP BI Platform Repository.
  4. Choose Universe.
  5. Choose OK.

    The Select a Universe screen appears.

  6. Select the universe on which you want to create a document.
  7. Choose OK.

    The Query Panel screen appears.

  8. Drag the dimensions and measures you want to include in the query into the Result Objects pane.
  9. Choose Run.

Save a Document

You can save the current document to a Personal Folder or a Public Folder (if you have the appropriate rights).

The Save As functionality only saves the document in Web Intelligence document format (*.WID).

Save document: In the File Name field, enter the file name and choose Save.

Recovering Documents

You can recover Web Intelligence documents after a session timeout.

Procedure: To Open and Save a Recovered Document

Follow these steps to open and save a recovered document:

  1. In the File section of the toolbar, choose Open.
  2. Choose Document Recovery tab.
  3. Select the recovered version you are interested in.
  4. Choose Open.
  5. If you are satisfied with the selected version, choose Save in the File section of the toolbar.

Web Intelligence Document Components

Watch this video to learn about Web Intelligence document components.

Create a Document with a Simple Query

Describe Web Intelligence User Interface Elements

The application has several elements that you can use to create, edit and navigate documents.

Component: Main Toolbar

You use the Main Toolbar to open, save and print documents, save a copy or export a document to the SAP BI Platform, track data changes, display the report outline, display the filter and formula bars, drill, change source, create conditional formatting, refresh reports, create and insert visualizations, fold or unfold data, open the query panel, and so on...

The Main Toolbar is made of six sections, File, Query, Insert, Analyze, Display and Navigate.

Screen capture: Main toolbar. See text before image for more details.

Component: Build Side Panel

Watch this video to learn about the Build Side Panel.

The Build Side Panel is accessible all the time in both Reading and Design mode.

Component: Main Side Panel

Watch this video to learn about the Main Side Panel.

The Main Side Panel is accessible all the time in both Reading and Design mode.

Log in to track your progress & complete quizzes