Problems with Multiprovider

[Former Member]

Hi Folks,

Items: Cube1, Cube2, Multiprovider

I've 2 cubes and then a Multiprovider on top on these cubes. The common Char is "Doc#". Based on this doc# I'm pulling 15 fields from Cube1 and 2 fields from Cube2.

But when I execute a Query on top of this Multiprovider, its not showing details from Cube2. Please suggest what could be possible workaround so that I can see these details.

The fields I need from Cube2 are Event Name(CHAR) and Date (DATS).

Do I ve to do anything at Report level to see the details from other Cube.

Reddy.

[Former Member]

Actually the report is not showing anything from Cube2.

[Former Member]

Selections are fine. Infact I'm using "Create Recommendations" but still it is not working.

Any idea if its because of Note.950258. As it asks for Patch-18. we are on BW 350

Pls help.

[Former Member]

Hi Reddy,

Welcome to SDN!!

Most of such problems occur because the relevant fields are not selected in the "identification" section. Goto RSA1 -> Multiprovider -> click the identification button and check if you selected the fields from the correct infoprovider.

Bye

Dinesh

[Former Member]

hi ragavendra ,

Can u tell me what report you want to generate and what are the fields present in cube1 and cube 2 .

regards

ven

[Former Member]

Report is having folling fields coming from:-

Cube1:

Doc#, CompCode, Acc#, Source, Ref#, CustName, Inco, Shipto, Cost, Price, Net value

Cube:2

Doc#, Status, Status Date

Doc#, Source System and CompCode is common in both InfoProviders

Thanks!