Importing SAP Universe Data to a New or Existing Model

You can import data from an SAP BusinessObjects BI platform universe into a new or existing model. You specify the source model and then specify how you want to import data into model dimensions.

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. Select the appropriate option:
    • If you're creating a new model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Start of the navigation pathGet data from a datasource Next navigation step SAP UniverseEnd of the navigation path.
        Note
        From the acquire data panel, select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.

    • If you're importing into an existing model:
      1. Select Start of the navigation path Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step DatasourceEnd of the navigation path.
      5. Select SAP Universe.
        Note
        You can select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.
  2. Choose an existing universe connection, or create a new connection.
  3. If you created a new connection, you'll next create a new query.
    If you chose an existing connection, you can copy an existing query (which you can edit), or create a new query.
    • To edit an existing query, follow these steps:
      1. Select a query from the list.
      2. Select Modify existing query.
      3. Make your changes, and then select Next.
    • Or, to create a new query, follow these steps:
      1. Select Create a new query.
      2. Type a name for the query.
      3. Select a universe from the list, or search for a universe by name, and then select Next.
      4. Select data objects from the universe tree, and drag or double-click to add them to the Selected Data or Filters area.
      5. Select Next.
      6. If the universe contains prompts, select values for them.
  4. Select OK.

Next Steps

After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.