SAP ABAP Data Element RSIPROVSUPPORT (Query is used as InfoProvider)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-BEX-ET (Application Component) End User Technology
⤷
RSR (Package) BW: General reporting processor
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-BEX-ET (Application Component) End User Technology⤷
RSR (Package) BW: General reporting processor
Basic Data
| Data Element | RSIPROVSUPPORT |
| Short Description | Query is used as InfoProvider |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 9 | QueryProv |
| Medium | 18 | Query InfoProvider |
| Long | 37 | Query is used as InfoProvider |
| Heading | 37 | Query is used as InfoProvider |
Documentation
Definition
The system processes the data in a query as an InfoProvider.
Use
This setting makes it possible to perform high-quality analyses, especially on queries that are quite simple but contain a very large amount of data, i.e. with over a million lines. This has the advantage that you can calculate functions of the query more efficiently in the analytic server before reading the data.
You can still index the data of all InfoProviders that the query is based on using query snapshots in the SAP HANA database or in SAP NetWeaver Business Warehouse Accelerator.
Dependencies
If you use a query as an InfoProvider, not all query functions are supported.
Example
The following are examples of how a query can be used as an InfoProvider:
- You can use a query as the data source of an analysis process and create analytic indexes on it using SAP NetWeaver BW Analysis Process Designer.
- You can use a query as the data source of a data transfer process with extraction mode Full. This allows you to extract query data and to distribute it, using an Open Hub Destination, to downstream applications - to an SAP HANA database for example. You can also use OLAP functions in the staging process with the query as the data source of a data transfer process.
- With the analytic server#s relational interface, you can use a query - especially if it contains mass data # as the data source for the SAP BusinessObjects Data Federator and use it as the basis for analyses, in SAP BusinessObjects Web Intelligence for example.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 740 |
