You can also model the data flow so that you do not need to load the data into the BW system. Instead, you can access it directly for reporting and analysis purposes. The VirtualProvider is used as the data structure.
VirtualProviders are InfoProviders whose transaction data is not stored in the object itself, but is read directly for analysis and reporting purposes. The relevant data can be from the BW system or from other SAP or non-SAP systems. VirtualProviders only allow read access to data.
Note that the system does not run existing exits or customer and application extensions (customer exit, BTE, BAdI) for direct access to the source system.
Creating Virtual Providers
Various VirtualProviders are available. You use these in different scenarios:
To read data directly from SAP systems: Creating VirtualProviders Based on Data Transfer Processes
To read data directly from external systems: Creating VirtualProviders with BAPI
To read user-defined data directly: Creating VirtualProviders with Function Modules
To read data directly from a SAP HANA model: Creating VirtualProviders Based on a SAP HANA Model
Creating Characteristics with Direct Access
You can directly access the data in the source system for an InfoObject of type characteristic that you have selected for use as an InfoProvider.
More information: Modeling Data Flows for Characteristics with Direct Access
Creating Data Flows for Hierarchies with Direct Access
In BEx queries, you can use hierarchies with direct access. This is recommended for small hierarchies that do not change often.
More information: Modeling Data Flows for Hierarchies with Direct Access