Click Next >

Note:

You can use the Reset button to remove the value for each field in the Message Details pane. The Reset All button can be used to remove the values for all the fields in the Message Details pane.

Related Topics

•Adding a Node

•Copying a Node

•Deleting a Node

Setting drill filters

In the drill block, you can specify the filter and drill path values to retrieve the drilled data.

To specify the filter and drill path values, perform the following steps:

1. In the filter node, perform the following steps to filter data for any object:

a. Select dimension, enter the name of the dimension on which you want to filter data in the Enter the Value field, and click Apply.

b. Select value, enter the value of the dimension in the Enter the Value field, and click Apply.

c. Select operator, and select the value from the Select a Value drop-down list.

Note:

For INLIST and NOT_INLIST operators, you must specify multiple values with a comma-separated list.

2. In the drillpath node, perform the following steps to retrieve the drilled data:

a. Select drillOperation, and select a value for the drill operation from the Select a Value drop-down list.

The supported drill operations are UP and DOWN.

b. Select value, enter the value of the dimension in the Enter a Value field, and click Apply.

c. Select from, enter the name of the dimension in the Enter a Value field, and click Apply.

3. Click Next >.

The "Query Panel" appears.

Note:

You can use the Reset button to modify the value and the operator for each dimension, and Reset All button to modify the values and the operators for all the dimensions.

Related Topics

•Adding a Node

•Copying a Node

•Deleting a Node

Adding a Node

A node can refer to a filter or a drillpath. You add new nodes if you want to add more drill conditions or more filter conditions on the same dimension. In case of filters, these conditions refer to AND joins.

To add a new filter or a drillpath, right-click the parent filter or drillpath node, and select the Add option.

A new filter or drillpath node is created.

Copying a Node

A node can refer to a filter or a drillpath.

To copy a filter or a drillpath node, right-click the child filter or drillpath node, and select the Copy option.

A filter or drillpath node is copied with the existing values to its parent node.

Deleting a Node

A node can refer to a filter or a drillpath.

To delete a filter or a drillpath node, right-click the child filter or drillpath node, and select the Delete option. The node is deleted from its parent node.

Note:

You can delete nodes only if they have been created by using the Add or Copy option. You cannot delete the original instance of a filter obtained from the WSDL.

6.2.5.1.6 Setting filters for the Generic Web Service

To set filters for the generic web service, perform the following steps:

1. In the "Input Message" panel, select the input field, enter the value in the Enter a Value field, and click Apply.

2. In the "Output Message" panel, select the output fields, and click Next >.

You must select at least one field in the "Output Message" panel. To select multiple fields in the

"Output Message" panel, press the Control key, and select the fields.

The "Query Panel" is displayed with the data sample.

6.2.5.1.7 Editing and Running a Query You can edit the following query parameters:

• Object Properties: You can edit the object properties such as name, qualification, type, aggregate function, and aggregate dimension.

• Query Properties: You can edit query properties such as name, source URL, refreshable, and editable.

• Query Definition: You can edit the query definition by clicking Edit settings.

To run a new query, verify the objects and sample data that appear in the "Query Panel" window, and click Run Query.

A new report is displayed.

Note:

If you edit the source URL in the "Query Panel" window, ensure that the new WSDL has the same structure as the WSDL that was used earlier.

For information on creating Custom Data Provider plug-in, see theCustom Data Provider Plug-in Developer Guide.

6.2.6 Building queries on Advanced Analysis views

6.2.6.1 SAP BusinessObjects Analysis defined

SAP BusinessObjects Analysis is an OLAP analysis tool that allows users to interactively define analyses to explore data in OLAP data sources. Users can export data in their analyses as Analysis Views, for use in other applications including SAP BusinessObjects Web Intelligence.

You can build queries on Analysis Views to analyse their data in Web Intelligence documents. The data in the Analysis View appears in the query panel as report objects such as hierarchies, dimensions and attributes.

Note:

Analysis Views with custom objects are not supported. Only analysis views coming directly from NetWeaver BW are supported.

6.2.6.2 To build a query on an Analysis View

Note:

You cannot build a query on an analysis view with the Web interface (DHTML client).

1. In Design or Data mode, select Data Access > New > From Analysis View to display the "Select an Analysis View" dialog box.