Importing SAP BW Data to a New or Existing Model

To import data from an SAP Business Warehouse (BW) system to a new model or existing model, you specify the source data and then specify how you want to import the data into model dimensions.

Prerequisites

You use an SAP Business Warehouse (BW) system, version 7.3x or higher release, and both the SAPCP cloud connector and SAP Analytics Cloud agent are installed and configured.

Context

Note

You can use time-series charts with level-based hierarchies, but take note of these constraints and limitations:

Query Model Constraints

  • All dimensions (characteristics) that are members of the level-based hierarchy should be among the free characteristics that can be switched to different granularity levels in SAP Analytics Cloud.

    Otherwise, you wouldn't be able to switch between the different time granularities. The following screenshot shows the default hierarchy based on Calendar day. The hierarchy levels are Year, Month, and Day.

    Quarter is also modeled in the free characteristic area so that you can switch between different hierarchies.

  • One of the valid hierarchies should be present as a default hierarchy for the date dimension. Otherwise, the time-series chart won't be rendered until the hierarchy is manually changed. The following screenshot shows that the hierarchy with the levels Year, Month, and Day is active when running that BEx query in SAP Analytics Cloud.

Current Limitations

  • Dynamic restricted measures like Sales Volume restricted on date calculations (for example, previous year).
  • Restricted measures on level-based date dimensions, while selecting members by range (alternatively, this can be achieved by selecting members using an input control and then filtering by range).
  • Non-concatenated date dimensions are not currently selectable inside time series charts. For example:
    • 0CALMONTH2
    • 0CALQUART1
    • 0HALFYEAR1
  • Fiscal date dimensions. For example:
    • 0FISCYEAR
    • 0FISCPER

Procedure

  1. Go to the Models list: select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  ModelsEnd of the navigation path.
  2. Select the appropriate option:
    • If creating a new model: Select Start of the navigation path Next navigation step Get data from a datasource Next navigation step SAP BWEnd 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 importing into an existing model: Select Start of the navigation path Next navigation step Import Data From SAP BWEnd of the navigation path, and then select a target model from the list.
  3. Choose an existing connection, or create a new connection.
  4. Copy a query from an existing model (which you can edit before saving), or create a new query.
    • 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, and then select Create.
    You can continue to work on other tasks while the dataset is being uploaded in the background.
  5. When the draft data is finished uploading, open it from the Draft Data list (for a new model), or the Draft Sources list (for an existing model).

    The data appears in the Data Integration view.

  6. Complete the following substeps if your SAP BW datasource 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.
    1. Select the column that contains the SAP BW date dimension data.
    2. In the right hand Details side panel, expand Modeling and choose the Date dimension type.
    3. Choose the appropriate Date Format.

Next Steps

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