Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

multiprovider join? Possibilities

Hi Everyone !

I have a requirement ,  This is just a sample .

1.cube    

material ID       Quantity

101                     5

102                     7

103                     3




2.Cube


Material ID        Price

101                     10

102                     8

103                     25

104                     30




Report



Material      Quantity      Price         Sales Amount

101                     5          10                50

102                     7            8                56

103                     3           25               75




report should not have Material ID = 104 , as there is not corresponding material ID in 1 st cube .

Using Infoset is not an option provided for me. This can be solved with a Multiprovider itseems , Please help!!

Tags:
Former Member
replied

Hi Dinesh,

You need to upgrade to BW 7.4 (HANA) and use the COMPOSITE PROVIDER to achieve this JOIN CONDITION..

Regards,

Loed

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question