Multiprovider

Definition

A MultiProvider is a type of InfoProvider that combines data from a number of InfoProviders and makes it available for analysis purposes. The MultiProvider itself does not 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.

Use

A MultiProvider allows you to analyze data based on several InfoProviders.

We have seen InfoProviders like DSO, InfoCube, InfoObjects... (can physically hold data)

we have some more infoproviders on which reporting can be performed, but they cannot physically hold data... and they won’t be having any tables also..

They are virtual Infoproviders..

• Multiprovider
• Infoset
• Virtual Cube

The design of a data target such as an Info Cube or DSO is based on one business process,

for example, one Info Cube for sales billing processing and another one for sales order processing. In this way BI will have multiple Info Cubes, each supporting an individual business process. In real time we will get scenarios where data from two different Info Cubes needs to be joined.

A Multi Provider is a logical definition that doesn’t physically store data. The data lies in the underlying data provider on which the Multi Provider is created. A MultiProvider can consist of different combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level

Multiprovider can also be create on a single info provider.

A union operation is used to combine the data from these objects in a MultiProvider. Here, the system constructs the union set of the data sets involved; all the values of these data sets are combined. 

In a MultiProvider, each characteristic in each of the InfoProviders involved must correspond to exactly one characteristic. If this is not clear, you have to specify the InfoObject to which you want to assign the characteristic in the MultiProvider. You do this when you define the MultiProvider.

lets see how we create a multiprovider on a DSO and Cube

lets create a multoprovider on top of the highlighted Cube and DSO..

Drag and drop the dimensions(with characteristics) or only characteristics(creating dimensions)  and keyfigures to respective places..

Now we have to identify the characteristics included in the Multi Provider and match them to the characteristics or navigation attributes in the base info cubes.

Identify characteristics for all characteristics and Identify keyfigures for all keyfigures..

And activate Multiprovider

Select the Multiprovider and right click and select "Display data" option to see the virtual data.
we don't find Tranformation and DTP  for Multiprovider because we are not loading physical data.