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. Overview. As part of our series on SAP BW Data Modeling, we next cover MultiProviders and InfoSets. MultiProviders and. InfoSets enable you to combine other. 3 Jul Multiprovider. We have seen InfoProviders like DSO, InfoCube, InfoObjects These all are objects which can physically hold data. we have.

Author: Vudal Feshakar
Country: Tunisia
Language: English (Spanish)
Genre: Business
Published (Last): 6 August 2017
Pages: 423
PDF File Size: 19.52 Mb
ePub File Size: 5.77 Mb
ISBN: 712-6-82398-768-8
Downloads: 90320
Price: Free* [*Free Regsitration Required]
Uploader: Jule

In contrast to a union, joins form the intersection of the tables. A MultiProvider is a type of InfoProvider that combines data from a number of InfoProviders and makes it available for analysis purposes.

List of Slow-Moving Items.

SAP BW – MultiProvider

Here, the system constructs the union set of the data sets involved; all the values of these data sets are combined. However, if 0SALES is stored as an actual value in multiprovideg InfoProvider and as a planned value in another InfoProvider and there is no overlap between the data records in other words, sales are divided separately between several InfoProvidersit is useful to select the key figure from more than one InfoProvider.

A query based on a MultiProvider is divided internally into subqueries. Dividing a MultiProvider Query into Subqueries. If this is not clear, you have to specify the InfoObject to which you want to assign the characteristic in the MultiProvider.


The following sections contain more detailed information: List kultiprovider Slow-Moving Items Example: A union operation is used to combine the data from these bk in a MultiProvider.

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

what is multiprovider

In general, one InfoProvider provides the key figure. However, there are cases in which it is better mulhiprovider select the key figure from more than one InfoProvider: However, we recommend that you include no more than 10 InfoProviders in a single MultiProvider, otherwise splitting the MultiProvider queries and reconstructing the results multiprovided the individual InfoProviders takes a substantial amount of time and is generally counterproductive.

As a comparison, see InfoSet. Otherwise the value is totaled incorrectly in the MultiProvider because it occurs several times.

Recommendations for Modeling MultiProviders. These joins only combine values that appear in both tables. The data continues to be stored in the InfoProviders on which the MultiProvider is based. The MultiProvider itself does not contain any data. There is a subquery for each InfoProvider included in the MultiProvider. In a MultiProvider, each characteristic in each of the InfoProviders involved must correspond to exactly one characteristic or navigation attribute where these aap available.

SAP BW MultiProvider

If the 0SALES key figure is stored redundantly in more than mkltiprovider InfoProvider meaning that it is contained fully in all the value combinations for the characteristicswe recommend that you select the key figure from just one of the InfoProviders involved. These InfoProviders are connected to one another by a union operation. Integration MultiProviders only exist as a logical definition.


In contrast to a union, joins form the intersection of the tables As a comparison, see InfoSet. Modeling MultiProviders with jn than 10 InfoProviders is also highly complex.

A MultiProvider can consist of different combinations of the following InfoProviders: In this case, select just one of these Multiprovidef in the assignment table.

See the following examples: You do this when you define the MultiProvider.

what is multiprovider

InfoSets are created using joins. Technically there are no sa with regard to the number of InfoProviders that can be included in a MultiProvider.

These subqueries are usually processed in parallel. Its data comes entirely from the InfoProviders on which it is based. If a key figure is contained in a MultiProvider, you have to select it from at least one of the InfoProviders contained in the MultiProvider. MultiProviders only exist as a logical definition.