How to configure Drill Through to BEx Query SAP BPC 10 NW

This section will focus on how to configure a drill through target to a BEx Query. In this example, we will configure a drill through target to a pre-existing BEx query called ZDT_PLANNING. This query was created using the 7.x version of the Query Designer, but the 3.x URL format will be used when defining the drill through target in BPC. The reason is that, at the time of this writing, there are limitations when using the 7.x URL format. For example, the parameter names used in the 7.x format are too long to be used when configuring the parameters in the BPC Admin client. A future BPC support package will address these limitations, but until then the 3.x format should be used. This BEx query has been created with two variable parameters called ZDTACCT and ZDTTIME. Values from a BPC report will be passed to these parameter variables when triggering the BEx Query.

1. Log on to the BPC Admin Client and click on “Drill Through“ from the appropriate Application.
2. From the action pane, click “Add Drill Through”.
3. Enter the Drill Through ID and a description, then click “Next“.
4. Next, enter the URL for the BEx Query. Again, the 3.x URL format works best here. An example URL would be:
http://<host>:<port>/sap/bw/bex?&query=<query_name>
5. Enter the parameters as shown below. BEx Query uses specific parameter names such as VAR_NAME_1, VAR_VALUE_EXT_1. This is how the parameter values are passed through the URL. You must supply the name of the parameter as well as the actual value assignment. So for each parameter variable defined in your BEx Query, you must define a pair of parameters here, one for the name of the variable in the BEx Query, and the other for the actual value to be passed.
6. Next, click the “Test” button.
7. Click “Run Test”.
8. The report is then displayed. Notice the parameters have been passed successfully to the BEx query.
9. Click “Close”, next.
10. The drill through target is now configured successfully.