BEx Query Fetchers (BICS) allow you to use BEx query as a data source using BI Consumer Services. They provide the BEx query name for the data read. They also support filtering on query variables.
Prerequisites
- SAP BW release 740 SP19 or higher.
- Ensure that the additional transport with BEx Query Fetcher based on the BICS function is installed on the system.
- Before creating the BEx Query Fetcher, ensure you have at least created an active and consistent variable variant in the Query Monitor (transaction RSRT). This is required for the initialization of the BEx query structure due to certain limitations of the BICS function.
Creating BEx Query Fetchers (BICS)
Perform the steps provided under Creating Fetcher Objects and select BExQuery Fetcher (BICS) from the Component implementation drop-down menu in step 7.
Activating BEx Query Fetcher (BICS)
...
- BEx query
- Name of the BEx query for the data read
- KYF in External Display
- If selected, key figures will be in an external format, i.e. currency conversion will be applied
- Use customer-exit
- If selected, the query is executed with the values for variables provided by customer-exit (CMOD)
- Can be changed before before each extraction
After the BEx query parameter is filled, the variables will be loaded into the variable filter definition. In the current version, all the variables will be enabled for the selection.
...
BEx Query Fetcher allows you to change the navigational state of a query with which it will be executed. The functio function is similar to the drill-down of free characteristics in the Query Monitor (transaction RSRT). If you want to change the default navigational state of a query, you can drag and drop query elements between the three screens: Rows, Columns, and Free characteristics.
...
- The row axis must not have a key figure structure. However, other types of structures can be in the rows, for example, structures with characteristics or formulas.
- The column axis can contain only the key kigure figure structure. Any additional characteristic or structure in this axis will lead to an error.
- All active hierarchies in characteristics in the row axis are disabled automatically right before the extraction.
- If a characteristic in the row axis uses a key figure as an attribute, the data for that key figure is stored in one field, e.g. EUR 1.23. As a result, the value and currency are not separated into two fields.
- Characteristic in the row axis cannot have the setting Display Value set to No Display.
- Due to the complexity of some calculated key figures and formulas, it is sometimes impossible to determine whether these types of query elements have any unit or currency.
- .Calculated key figure figures or formulas with a currency and a unit in one cell are not supported, . e.g. EUR/KM.
Other Restrictions:
- Customer - exits (CMOD) in query variables. For variables of this type, you must fill in the selection values manually. They are not prefilled as in the Query Monitor (transaction RSRT).
...