Entering content frame

Process documentation All Data (Relational) Locate the document in its SAP Library structure

Purpose

The All Data template is a simple default template activated when you drag a relational data service to the workspace (see Configuring Queries Directly in Data Services). With this template, you can build queries that select all records and all fields as the final result, without any filters or joins.

You should use this template if you would like to address business questions such as the following:

What are all the available grade levels and their details?

 

Prerequisites

You have a relational data service configured as a BI system.

 

Process Flow

After using the BI Query Wizard to select a relational data service and the All Data template, the wizard asks you only to Select a Table to complete the procedure for this template.

This graphic is explained in the accompanying text

If you have entered the BI Query Wizard from configuring your data service directly in the workspace, your system and table are already configured and this step is bypassed.

 

Result

After you have completed the wizard screens according to the process above and clicked Finish, you return to the Visual Composer workspace, where a new data service has been created with the query you have configured.

A data service created with the BI Query Wizard is configured automatically with a start input and a table view as output. These three elements together constitute a complete iView, ready for preview and deployment to your portal.

To continue working with your data service and query, see:

·        Working With Queries

·        Using the SQL Editor

 

 

Leaving content frame