
To be able to use easy queries, you have to check certain settings in the system and/or make a number of changes.
Check Authorizations
Check the required authorizations. Users who want to generate easy queries require the following authorizations.
Role S_RS_RDEMO contains all authorization objects for the BW system.
Role SAP_BC_SIW_DEV needs to have activity 06 for authorization object S_SIW_CFG added to it. The Service Integration Workbench (SIW) is needed for generation of the ABAP components in the easy query.
You still need an SOA role for service configuration with SOA Manager (such as SAP_BC_WEBSERVICE_DEBUGGER, SAP_BC_WEBSERVICE_ADMIN_TEC or SAP_BC_WEBSERVICE_ADMIN_BIZ). For more information, see the documentation for SOA Manager under Roles and Authorizations.
BEx Query Designer Installation
BEx Query Designer must have revision level 671 or higher. In revision levels below this, you cannot select the By Easy Query option under the Advanced tab page in the query properties.
Check Configuration of the Service Implementation Workbench (SIW)
Call table maintenance (transaction SM31).
Display the VSIW_LANDSCAPE view: landscape ID = LOCAL_WO_ESR. No RFC destination is required.
Display the VSIW_CONFIG view. The following configuration entries are required:
Configuration entry |
User entry |
|---|---|
Configuration ID |
EQ_LEVEL_SPACE |
Description |
Configuration for easy queries |
Config. build class |
CL_EQ_SIW_LEVEL_SPACE_CFG |
Landscape ID |
LOCAL_WO_ESR |
Make the SOAP Settings
A standard profile must be configured in the SOA manager before the easy query can create the SOAP service with configuration profile. For more information, see the documentation about SOA Manager under Working with SOA Manager.
If the standard profile cannot be found, the system creates the SOAP service without configuration. You will not be able to use the SOAP service until you have retrieved the configuration however.
Make the Settings for Background Processing
Call background processing configuration (transaction SBGRFCCONF).
Choose the Maintain Supervisor Destination tab. Create a supervisor destination with an approrpriate user name.
Go to the Maintain Inbound Destination tab. Create a destination called QD_EQ_LOCAL with queue prefix EQQD_.