Creating a Dataset from SAP Universe Data

You can import data from an SAP BusinessObjects BI platform universe into a dataset.

Prerequisites

  • The cloud connector and SAP Analytics Cloud agent are installed and configured.
  • You use a supported version of SAP BusinessObjects Business Intelligence platform. For information on supported versions, see System Requirements and Technical Prerequisites.

Procedure

  1. Create a new dataset and choose a data source:
    1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  DatasetEnd of the navigation path.
    2. Select Data from a data source.
    3. Select SAP Universe.
    Note
    From the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
  2. Choose an existing universe connection, or create a new connection.
  3. Type a name for your query.
  4. Create a new query:
    1. Select a universe from the list, or search for a universe by name, and then select Next.
    2. Select data objects from the universe tree, and drag or double-click to add them to the Selected Data or Filters area.
    3. Select Create.
    4. If the universe contains prompts, select values for them.

Next Steps

After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.

Related Information