How to… Create Efficient MultiProvider Queries

Link to Article

MultiProvider

Introduction:

A MultiProvider is a type of InfoProvider that combines data from a number of
InfoProviders and makes it available for reporting purposes. 

The MultiProvider does not itself contain any data. Its data comes entirely from the InfoProviders on which it is based. 

These InfoProviders are connected to one another by a union operation. InfoProviders and MultiProviders are the objects or views that are relevant for reporting.

Structure:

Step-by-Step Procedure to Create a Multiprovider

MultiProvider is a special InfoProvider which combine data from several InfoProviders for its own reporting, without actually holding any physical data itself (i.e. its data comes exclusively from the InfoProviders on which it is based), then, it can only use an InfoProvider that is ready and available for reporting, in which case, the Transactional ODS object is not one of them. 

Therefore, to include a Transactional ODS object in a MultiProvider, you would have to first define an Infoset for the Transactional ODS object.