You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Query Studio › Query Builder

Querying SAP BW InfoProvider

Query SAP BW InfoProviders including InfoCubes, DSOs, and MultiProviders.

Overview

This guide demonstrates querying an SAP BW InfoProvider — such as a DSO, InfoCube, or MultiProvider — using Data Trust. The SAP BW connection profile accesses the BW layer and maps InfoProvider fields to query columns.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• An SAP BW connection profile has been configured in the Administration module.

Steps

Path: Data Trust › Query Studio › Querying SAP BW InfoProvider

Figure 1: Query navigation

Navigate to the Query Studio module and select Query navigation to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 2: SAP BW_Connection selection

This step configures the SAP BW_Connection selection SAP connection for the query data source. Ensure the SAP connection profile is set up in the Administration module before proceeding with table or InfoProvider selection.

Figure 3: SAP BW_Info provider

This step configures the SAP BW_Info provider SAP connection for the query data source. Ensure the SAP connection profile is set up in the Administration module before proceeding with table or InfoProvider selection.

Figure 4: Pick table from Info objects

This step shows Pick table from Info objects in the Querying SAP BW InfoProvider workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 5: Drag table from navigator_execute button

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table, then click Select to add it to the query.

Figure 6: Query execution results_save button

The Query execution results_save button displays the output data returned by the query or Query Chain execution. Review row counts, column values, and data quality before saving or using the output in downstream processes.

Figure 7: Query save pop up

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.

Figure 8: Query save message Toaster

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.