Creating a Dataset from SAP BW Data
To import data from an SAP Business
Warehouse (BW), or an SAP BW/4HANA system, to datasets, you specify the source data and then
specify how you want to import the data into dataset dimensions.
Prerequisites
You use an SAP Business Warehouse (BW) system, version 7.3x or higher
release, or an SAP BW/4HANA system, SP4 or higher, and both the SAPCP cloud
connector and SAP Analytics Cloud agent
are installed and configured.
Note
If you're importing data via a BEx query using an SAP BW import
data connection, see these SAP Notes:
2416705
2408693 .
Procedure
-
Create a new dataset and choose a data source:
- Select .
- Select Data from a data
source.
- 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.
-
Choose an existing connection, or create a new
connection.
-
Create a new query.
- Type a name for your query.
- Select a BW query from the list, or search for a
query by name, and then select Next.
- 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.
- 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.)
- 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)
- 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.
- Select Create.
You can continue to work on other tasks while the data is being
uploaded in the background.
When the draft data is
finished uploading, the data appears in the data integration
view.
-
Complete the following substeps if your SAP BW data source
contains date dimensions that you want to enrich with time-hierarchy
information.
If you enrich the date dimensions, you can use date-related
features such as sorting by date, and date range sliders for
filtering.
-
Select the column that contains the SAP BW date dimension
data.
-
In the right hand Details side panel, in the
Column Details section, choose the
Date data type.
-
Choose the appropriate Conversion
Format.
Next Steps
After importing the raw data, continue with data preparation
before completing your dataset: About Adding Data to a Story.