Friday, September 21, 2012

Multi providers



Multi providers (just a structure, not a physical data store object like cube or ODS) is the union of infoproviders namely Infocubes, ODS , master data tables.

This is just a union of more than one infoproviders, for example if you have a requirement that you need to compare plan data vs actual data OR last year data vs current year ...or similar scenarios. Then it may be easy hassle to create different cube and create a multiprovider then design your report out of multiprovider. Just keep in mind that you need to have at least one similar char in all the infoproviders which includes in your multiprovider.
You can create multprovider of any of the following:

  1. Infocube
  2. ODS
  3. InfoObject
  4. Infosets.

Identification Tab:

Identification tab is for system to identify which char. in multiprovider maps to which characteristic in the specific base providers.

The same characteristic may be present in more than one of the base InfoProviders of the multiprovider.

Also one characteristic in the multiprovider can be matched to another characteristic in one of the base providers which is of similar data type and length.

E.g. you could match 0CUSTOMER and 0SOLD_TO (because 0SOLD_TO has reference characteristic 0CUSTOMER), but it is not possible to match e.g. 0MATERIAL and 0MAT_SALES (because 0MAT_SALES is compounded to 0SALESORG etc.).

Eg: If you have 0VENDOR in ODS1 and ZVENDOR in ODS2 and you want to assign them to the same Multiprovider characteristic 0VENDOR, you need to have ZVENDOR created with reference to 0VENDOR.
If the ODSs are productive I'd suggest creating an ODS3 that is filled out of ODS2 but with 0VENDOR instead of ZVENDOR.

1 comment:

Unknown said...

Hi..i am kartik,, thanks for sharing a vailable information in sap bwbiplz visit SAP HANA