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:
You can create multprovider of any of the following:
- Infocube
- ODS
- InfoObject
- 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.).
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.).
If the ODSs are productive I'd suggest creating an ODS3 that is filled out of ODS2 but with 0VENDOR instead of ZVENDOR.
