Multiprovider

[Former Member]

Hi,

I have a InfoCube containing transaction purchase information like Vendor, Material and price/item. On the other hand I have a pricelist (currently stored in an ODS) from an external system containing similar information; price/item for the combination vendor and material.

Is it possible to combine the cube and the ODS in an multiprovider, so that the query get the following design:

"Vend A" "Mat A" "New Price" "Old Price" "Price Diff."

Where the "Old price" is fetched from the ODS. I tried this, but the field from the ODS is blank.

Best Regards

/Daniel

[Former Member · Accepted solution]

You can go ahead and construct the multiprovider but you will get (in your example)

If you drill down on char 2 (the common char):

2 A B

If you drill down on char 1 and char 2 then you will get

1 2 A 0

1. 2 0 B

[Former Member · Accepted solution]

I see, thanks. So there is then no way to find a workaround and JOIN data through a MultiProvider, UNION of data is the only way?

Thank you all, for your help!

BR

/Daniel

[Former Member]

Hello Daniel,

have you tried to use the virtual keyfigure exit?

In this EXIT you can select during runtime of the query the needed information from the ODS and update an existing key figure in a InfoCube. (empty or filled key figure)

If you use this EXIT, you have to take in account the runtime of the query will be bad if the query data is aggregated. Because the system needs to read the data before aggregation. (MAterial, Time, Price)

Kind regards

Michael

[Former Member]

Thanks Michael!

BR

/Daniel

[Former Member]

Infosets are used for joins in BW however you can't use a cube in an infoset.

[Former Member]

Daniel,

This is what I understood from your post.

INFOCUBE:

Chars: Vendor, Material

KFs: New Price

ODS:

chars: Vendor, Material

KFs: Old Price

and Price diff is a calculated key figure.

PROCEDURE: This can definitely be done in an multi provider.

When you design a query, make sure to include only the characteristics that exist in both the objects. If you select a characteristic that exists only in the Infocube, but not in the ODS, you might not see the desired result. Check your query to see if any such Characteristic is included in it.

This should work without any problems. If you still have problems, please explain the problem in more detail. Like, which fields are included from both the objects and what chars does your query contain.

Good luck

Gova

[Former Member]

Hi, thanks for your answer!

Unfortunately I'm forced to show both characteristics and key figures from one infoprovider (the cube) that don't exist in the other (the ODS), for instance Purchasing group... is there a way to solve this? Is it only a problem with cgaracteristics or with KFs too?

Best Regards

/Daniel

[Former Member]

The BW automatically shows all records that are available in only one InfoProvider because it doesn't create a join but simply maps the records onto the MPro structure.

Best regards

Dirk

[Former Member]

Daniel,

In the multi provider, your characteristics should come from both the objects involved. This restriction is not there for Keyfigures. Infact, key figures should come different objects. So, its not a problem with key figures.

Gova

[Former Member]

Ok, correct me if I'm wrong:

If you have characteristic 1 and 2 and key figure A in one infoprovider, and characteristic 2 and key figure B in second info provider - it's not possible to show the query as: 1 2 A B?

Best Regards

/Daniel

[Former Member]

Hi Daniel,

You're still wrestling with this?

Is the query on the Web or in Excel? If in Excel, you could easily run two queries and pull the results together into a single table.

- Pete

[Former Member]

Unfortunately it's for web-purposes... I guess I have to put the solution in the UpdateRule if there is no other solution; exexcuting SQL-statment against the ODS containing the data during upload of transaction data to the cube?

BR

/D