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

BOBJ Execution Changes

Review updated BOBJ execution behaviour and connection handling in Data Trust.

Overview

This guide covers recent BOBJ execution changes in Data Trust Query Studio. Improvements include updated connection handling, enhanced error reporting, and more reliable report data retrieval from the SAP BusinessObjects layer.

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 BusinessObjects connection profile has been configured.

Steps

Path: Data Trust › Query Studio › BOBJ Execution Changes

Figure 1: QUERY STUDIO

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

Figure 2: Query page

The Query page is the main workspace for building and editing queries. Use the canvas to write SQL, add data sources, connect transformations, and configure output options.

Figure 3: select bobj profile

The select bobj profile panel configures the SAP BusinessObjects (BOBJ) connection for accessing BO universe data. Select the BOBJ profile and the target report or universe to use as the query data source.

Figure 4: Navigator slide screen

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 5: User folders

The User folders option creates a copy or moves the selected query or folder within the Query Explorer hierarchy. Use this to duplicate a query as a starting point for a new one, or to reorganise the folder structure.

Figure 6: Expand user folders and select table

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 7: Sales Report with Prompts’ data

This step shows Sales Report with Prompts’ data in the BOBJ Execution Changes workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 8: User Prompt pop up

This step shows User Prompt pop up in the BOBJ Execution Changes workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 9: select year

This step shows select year in the BOBJ Execution Changes workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 10: Click the ‘Apply’ button

This step shows Click the ‘Apply’ button in the BOBJ Execution Changes workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 11: Click show data

This step shows Click show data in the BOBJ Execution Changes workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 12: Results’ tab

The Results’ tab 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.