Previewing the Result 

Use

This screen allows you to review the query you have defined and see a preview of its result in a table.

 

Procedure

...

       1.      In the Description section, review the query you have defined.

The description confirms the values you have selected from your data service in a descriptive phrase of the result.

       2.      In the Preview section, review the way the result will appear in a table.

The table displays results of the query, listed in the columns you have configured using the wizard.

The display is limited to a maximum of 15 rows of the result.

       3.      Click Finish.

 

Result

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.

·         Just as on the Preview Result screen, when you preview your query’s result using the Preview tab in the Visual Composer workspace, the maximum number of rows displayed is 15.

·         For Heatmap templates, an HTML view that generates a heatmap is created on the URL port.

·         For data services based on BW-native systems, an HTML view that displays the default Web template is generated on the URL port.

·         If you have configured your query directly in a data service instead of using the BI Query Wizard, you must configure the input and output ports of your data service manually. See Configuring Queries Directly in Data Services for more information.

 

For more information about displaying the result, and working with your query and its view after it has been created, see Working With Queries.