Show TOC

Modifying QueriesLocate this document in the navigation structure

Use

After you have created a query, you may modify it using the BI Integration Wizard, or you may edit the query statement directly by using the MDX Editor (OLAP queries) or SQL Editor (relational queries).

Caution

MDX and SQL Editor functionality is disabled by default. For more information, see Security Risks with the SQL Editor and MDX Editor in the SAP NetWeaver Visual Composer Security Guide .

Prerequisites
Procedure

To modify a query using the BI Integration Wizard:

  1. In the workspace, select the data service icon.

  2. Select Start of the navigation path BI Next navigation step BI Integration Wizard End of the navigation path.

    Alternately, from the context menu, select Configure Query .

The BI Integration Wizard is displayed on the Select a Query Template screen. You may change any aspect of your query except for the data service, cubes, or tables associated with your query.

To modify aquery using the MDX or SQL Editor:

  1. In the workspace, select the data service icon.

  2. Select Start of the navigation path BI Next navigation step MDX Editor End of the navigation path(OLAP queries) or Start of the navigation path BI Next navigation step SQL Editor End of the navigation path(relational queries).

    Alternately, from the context menu, select MDX Editor or SQL Editor .

The MDX or SQL Editor appears with your currently configured statement active.

Note

If you select a relational data service and you evoke the MDX Editor, the editor disregards your selection and assumes that you want to create a new OLAP query. Similarly, if you select an OLAP data service and you evoke the SQL Editor, the editor disregards your selection and assumes that you want to create a new relational query.