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
4 Answers
-
Former MemberPosted on Feb 11, 2005 at 09:04 PMDaniel,
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
Add a comment
-
Former MemberPosted on Feb 16, 2005 at 09:28 AM
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
Add a comment
Add a comment