This post is just for demonstrating the use of virtual infocubes and direct access DTPs as these are not used so frequently while modeling.
There is no data acquisition and the BI system connects remotely to the source when the query is called by the user. This is particularly useful where very less data need to be retrieved and it changes frequently.
There is also a concept of using Open ODS views if your BW system is based in HANA, where there is a similar access to source tables directly and queries are based on the source fields. Continue reading →