hi all
we have two infocubes 0SD_C03 and 0FIAR_C03
i want to create a multiprovider based on these two infocubes
can anyone suggest me how do i proceed.
i need the payment receipt( credit amt local currency) value which is in 0FIAR_C03
and net value in 0SD_C03
for our report which gives Total Sales, Billing and Payment receipt values.
I am able to get sales and billing values by creating a selection on netvalue from 0SD_C03 based on sales document category but my payment reciept is in 0FIAR_C03 cube .. ( which gets data from BSID and BSAD tables using datasource 0FI_AR_4.)
0FI_AR_4. DataSource extracts Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system
how do i achieve this
is multiprovider is the only way
if so please suggest what fields i need to use to join these two infocubes in multiprovider
thanks & regards