Show TOC

Object documentationSQL Editor Locate this document in the navigation structure

 

Use the SQL Editor to create new relational data services or edit the SQL statements of existing relational data services. You can edit the SQL statements of relational data services that have been created by the BI Integration Wizard, dragged from the Find Data Services Task Panel, or generated by the SQL Editor itself.

The SQL statement is available as a field on the Input port of the corresponding relational data service.

Caution Caution

For security purposes, SQL Editor functionality is turned off by default in Visual Composer. Therefore, if you try to access it you will see the message "You are not authorized to use this functionality."

See Security Risks with the SQL Editor and MDX Editor in the SAP NetWeaver Visual Composer Security Guide for more information.

End of the caution.

Note Note

  • See the prerequisites described in the notes in BI Menu Dialog Boxes.

  • The SQL Editor is not available for SAP Query data services (services defined based on the BI SAP Query Connector).

End of the note.

To create a new relational data service using the SQL Editor:

  1. Create an iView and drill into it.

  2. Choose   BI   SQL Editor  .

  3. See the reference below.

After you save your statement and close SQL Editor, you return to the workspace where a new relational data service has been configured with the SQL statement you've created.

To edit the SQL statement of an existing relational data service:

  1. In the workspace on the Design board, select the relational data service, and from the context menu, choose SQL Editor (alternately, choose   BI   SQL Editor  ).

  2. See the reference below.

Structure

The main sections and controls of the SQL Editor are described below:

Section

Control

Description

Object Browser

Browse tab

Lets you browse or look for and select relational data. See Find Data Services Task Panel for a description of the similar Look for functionality for relational systems.

Select any type of relational metadata, and drag it to the Editor pane, or double-click to add it at the current cursor location. The unique name of the selected metadata is added to the statement.

Syntax Examples tab

Provides syntax templates, organized into several categories, with which to build your SQL statement.

Select a syntax example, and drag it to the Editor pane, or double-click to add it at the current cursor location. Replace the objects in brackets (<< >>) with selected metadata from your data service.

Editor

Editor icons

Cut (Cut) - Cuts text selected in the Editor pane.

Copy (Copy) - Copies text selected in the Editor pane.

Paste (Paste) - Pastes at the current cursor location.

Undo (Undo) - Reverts the last action.

Redo (Redo) - Repeats the last action.

Validate (Validate) - Checks your SQL statement and lets you know if it is valid. The editor lets you save statements even if they are invalid.

Run (Run) - Runs your statement to preview its result. Generates a table of the result in the Preview section.

Editor pane

Displays the current SQL statement and lets you edit it using the following methods:

  • Type directly into the pane.

  • Transfer metadata objects or syntax examples from the Object Browser.

  • Use the editor icons.

Preview

Displays a table of the results. Generate the preview using the Run icon. Maximize or restore the pane by clicking the up (Expand) or down (Collapse) arrows.

Save

Saves your statement and closes the editor.

Close

Closes the editor without saving.