Importing SAP BW Data to a New or Existing Model

If you're creating a new model:

1. Select (Main Menu)   Create   Model.
2. Select Get data from a data source.
3. Select SAP BW.

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.

If you're importing into an existing model:

1. Select (Main Menu)   Browse   Files.
2. Open the model you want to update.
3. Switch to the Data Management screen.

   

4. Select   Data source.
5. Select SAP BW.

Note

You can 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.

To copy and edit an existing query, follow these steps:

1. Select Copy a query from a model.
2. Select a query from the list, and then select Next.
3. Make your changes, and then select Create.

Or, to create a new query, follow these steps:

1. Select Create a new query and select OK.
2. Type a name for your query.
3. Select a BW query from the list, or search for a query by name, and then select Next.
4. If the data source contains prompts, select values for them. If you're using a variable that is filled by customer exit, you can select the Use Backend Default option. Then when you refresh the data, the data is based on the current value filled by the customer exit instead of the value saved when the query initially ran.
5. Select dimensions and measures for your query.

   (If you're importing data via a BEx query using an SAP BW import data connection, see the note in the prerequisites above.)

6. You can select the icon to open the Select Presentations dialog, and then choose which presentations you want to see. Depending on the characteristic, you could have these presentations available:

   Key (DISPLAY_KEY)
   Key (Internal) (KEY)
   Long Text (LONG_TEXT)
   Medium Text (MIDDLE_TEXT)
   Short Text (SHORT_TEXT)
   Text (TEXT)

7. If one of the selected dimensions has a hierarchy, you can click (Select Hierarchy and Drill Level) for more options, such as specifying which hierarchy to use. Note that No Hierarchy / Flat Presentation (Default) is the default.

   You can also specify the drill level. The default drill level is 2.

8. Select Create.