Entering content frame

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

Purpose

The Freeform template is a special relational template that walks you through defining a query without the constraint of a particular business question. With it, you can select fields from your data service and specify joins, filter values, and sort criteria (just as with the other relational templates).

This template is a simplification of the other templates, removing the constraint of a specific business question, but still hiding the complexity of the underlying query language.

 

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 Freeform template, the wizard steps you through the following process flow:

...

       1.      Select fields

       2.      Configure joins

       3.      Configure filters

       4.      Specify the sort order

       5.      Preview the result

 

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