There is an active version of each InfoObject that you want to transfer to the MultiProvider. Create any InfoObjects that you require that do not already exist and activate them. Create an InfoArea to which you want to assign the new MultiProvider. Enter a technical name and a description. Select the InfoProvider that you want to form the MultiProvider. The MultiProvider screen appears.
|Published (Last):||20 August 2010|
|PDF File Size:||12.81 Mb|
|ePub File Size:||13.91 Mb|
|Price:||Free* [*Free Regsitration Required]|
Its data comes entirely from the InfoProviders on which it is based. MultiProviders only exist as a logical definition. These InfoProviders are connected to one another by a union operation. There is a subquery for each InfoProvider included in the MultiProvider. These subqueries are usually processed in parallel. InfoProvider A contains sales actuals. InfoProvider B contains sales plan data.
One can combine the two InfoProviders into one MultiProvider to compare actual vs plan sales. A union operation is used to combine the data from these objects into a MultiProvider. And also this forum is for Bex quereis, you have to post this type of questions in right forum to get prompt answers and one more thing is before posting the question please check in sdn is already this topic is discussed or thread is available. Multi provider is union operation is used to combine the data from 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. As a comparison: InfoSets are created using joins. These joins only combine values that appear in both tables. In contrast to a union, joins form the intersection of the tables. A join can contain objects of the same object type, or objects of different object types.
You can include individual objects in a join as many times as you want. Join conditions equal join condition connect the objects in a join to one another. A join condition specifies the combination of individual object records included in the results set. Difference between MultiProvider and Infoset. Infoset are Virtual infoproviders which works in a concept of Intersection ,here any one objects should be common.
Multiprovider are also Virtual infoproviders which works in a concept of Union ,here atleast one objects should be common. You want to define a query that displays all products that have been purchased infrequently or not at all in the last 6 months. You want the query to display characteristic values for which there is no transaction data for the selected time frame or for which only low values exist. Not what you're looking for? Search community questions. This question has been deleted.
This question has been undeleted. Former Member. Posted on Dec 02, at AM Views. Add comment. Related questions. Sort by: Votes Newest Oldest. Best Answer. This answer has been deleted. This answer has been undeleted. Posted on Dec 03, at PM. Eg: InfoProvider A contains sales actuals. Alert Moderator. You already have an active moderator alert for this content. Dec 05, at AM. Hi, Please refer below link for details of production support roles , tcodes and activites u SAP BW Production support role - Tcodes And also this forum is for Bex quereis, you have to post this type of questions in right forum to get prompt answers and one more thing is before posting the question please check in sdn is already this topic is discussed or thread is available.
Thanks Riyez. Posted on Dec 02, at AM. Thanks, Venkat. Concept behind Multiprovider is Union Where as infoset works using Joins concept. Former Member Anshu Lilhori. Dec 03, at AM. Show all.
SAP BW - MultiProvider
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.
what is multiprovider
Step by step procedure to create a multi provider. MultiProvider is a special InfoProvider which combine data from several InfoProviders for its own reporting, without actually holding any physical data itself i. You can include Master data table in the Multiprovider but for that you should convert the InfoObject as the data target then only it is possible. Note : We go for Multiprovider when we want to do reporting on two or more data targets. A MultiProvider can be made of of various combinations of the following InfoProviders: 1.