multiprovider join? Possibilities

[Former Member]

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!!

[Loed · Accepted solution]

Hi Dinesh,

Try creating a CONDITION using these conditions:

Price > 0

Quantity > 0

After that, all materials having price and quantity which is greater than 0 will only be shown..

Thus,

Material      Quantity      Price         Sales Amount

101                     5          10                50

102                     7            8                56

103                     3           25               75

Try it and post here for the result..

Regards,

Loed

[Former Member · Accepted solution]

Hi Loed Despuig ,

   Sorry I am looking for Multiprovider level integration and not  a Query level Condition,

Thanks ,

Dinesh

[Loed · Accepted solution]

Hi Dinesh,

What do you mean?

You wanted to have this result in MULTIPROVIDER level? (Like when you MANAGE DATE the multiprovider you will have below result?)

Material      Quantity      Price         Sales Amount

101                     5          10                50

102                     7            8                56

103                     3           25               75

Is that right? If yes, then I think that is not possible since MULTIPROVIDER's functionality is UNION not JOIN..

Regards,

Loed

[Former Member · Accepted solution]

Hi Loed Despuig,

Ya I wanted a JOIN function on a M.P.

Anyway thanks for your help!

[Loed · Accepted solution]

Hi Dinesh,

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

Regards,

Loed

[former_member186053 · Accepted solution]

Hi Dinesh,

You can add both cubes in MultiProvider and you need make assignment of the material infoobject in multiprovier from both cubes. But you will get material 104 as well in report with quantity as blank. MP works on union operation.

Material      Quantity      Price         Sales Amount

101                5                10                50

102                7                8                  56

103                3                25                75

104                                  30                                   

I have a question, in general material will have quantity as well as price assigned to it.

what exactly is your requirement, can you elaborate.

Thanks,

Vengal.

[Former Member · Accepted solution]

Thanks Loed Despuig

[Former Member · Accepted solution]

Hi Vengal ,

  It was just a sample , and I wanted to know weather it is possible to do it on a M.P instead of restricting it in query level.

Thanks ,

Vengal

[giselle_lin]

Hi Dinesh,

You could join cube 1 and cube 2 on Material  by creating an infoset in RSA1.

If you are using BW on HANA,  you could create a Composite provider (the next version of multiprovider) and join cube 1 and cube 2 on Material.

[Former Member]

Thanks Giselle Lin