Skip to Content
avatar image
Former Member

Difference between MultiProvider and Infoset

How we can create Multiprovider and Infoset

Please taking the following example,

We have 3 infocube, one have A,B,C,D fields, second one have P,Q,R,S fields. third one have X,Y,Z fields. How can we create Multiprovider and Infoset (please tell me some possibilities)

and tell me the exact Difference between MultiProvider and Infoset.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 27, 2011 at 12:07 PM

    Hi,

    Multiprovider is a union of two subset.

    Infoset is a intersection of two subset (dependent on join).

    If you need all the values in report use multiprovider. If you need values that are common in two objects use Info Set.

    Performance is beeter in mutiprovider in compare to Info set (which are very slow while reporting).

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 06:03 AM

    With the given condition, you van create Multiprovider but you cant craete infoset. For infoset, you need one common field b/w infoproviders.

    To create a multiprovider:

    http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/bc734190ba137de10000000a155106/content.htm

    Diffrence b/w MP and Infoset:

    http://sap.ittoolbox.com/groups/technical-functional/sap-bw/how-infoset-is-different-from-multiprovider-1294696

    Thanks...

    Shambhu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 07:17 AM

    HI,

    A 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 MultiProvider can consist of different combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.

    Infoset

    You can include any DataStore object, InfoCube or InfoObject of type Characteristic with Master Data in a join. 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.

    http://help.sap.com/saphelp_nw70/helpdata/en/52/1ddc37a3f57a07e10000009b38f889/frameset.htm

    Tarak

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi..

      1) A Multiprovider can be built on basic InfoCubes, ODSs, info objects or Infosets. An Infoset can have only ODSs or info objects. Multiproviders use 'union' operation but Infosets use 'join'. Both the objects are logical definitions which don't store any data.

      2)Multiprovider works on the concept of union of all infoproviders but the info set works on the concept of

      intersection of the data in the fields available in the different infoproviders.

      3)Multiprovider is 3dim in this infoobject, ods and infocube included.it will works on union concept.

      Infoset are 2dim in this infoobject and Ods included. it will works on intersection concept.

      in BI7 infocubes also included in Infosets.

      info cube is 3 dimention data target.

      ex: MULTIPROVIDER

      DS Object Sales:

      MONTH SALES_PERSON SOLD_ITEMS

      04.2005 A 10

      05.2005 A 15

      DS Object Delivery

      MONTH DEL_PERSON DELIVERED

      04.2005 C 10

      04.2005 D 10

      MONTH SALES_PERSON SOLD_ITEMS DEL_PERSON DELIVERED

      04.2005 A 10 HASH(SYM) 0

      04.2005 HASH(SYM) 0 C 10

      05.2005 A 15 HASH(SYM) 0

      05.2005 HASH(SYM) 0 D 10

      HASH(SYM) >> UNASSIGNED WHEN CHARACTERISTICS ARE NOT IN BOTH PROVIDERS.

      INFOSET :

      MONTH SALES_PERSON SOLD_ITEMS

      04.2005 A 10

      04.2005 B 20

      05.2005 A 15

      05.2005 B 30

      05.2005 B 35

      MONTH DEL_PERSON DELIVERED

      04.2005 C 10

      04.2005 D 10

      05.2005 E 10

      05.2005 F 30

      HERE JOIN CONDITION = MONTH

      MONTH SALES_PERSON SOLD_ITEMS DEL_PERSON DELIVERED

      04.2005 A 10 C 10

      04.2005 B 20 D 10

      05.2005 A 15 E 10

      05.2005 B 30 F 30

      06.2005 B 35 ??? ???

      Regards,

      Debjani....

      Edited by: Debjani Mukherjee on Sep 1, 2008 4:13 PM

      Edited by: Debjani Mukherjee on Sep 1, 2008 4:41 PM

      Edited by: Debjani Mukherjee on Sep 1, 2008 4:48 PM

  • avatar image
    Former Member
    Jul 27, 2011 at 09:55 AM

    May i know the output difference between multiprovider and info set

    Add comment
    10|10000 characters needed characters exceeded