how to get data from 0sd_c03 and 0fiar_c03

[Former Member]

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

[Former Member]

Hi Krishna,

Multiprovider will be the best option for this. But at the same time you need to fetch the unique records out of these two cubes. Always you have to see assignments which you are selecting and that can be proposed. KF's data can be extract based on this.

Please share the detail information regarding your unique chars.

Assign points if helful.

Regards,

Amit