Skip to Content
author's profile photo Former Member
Former Member

Multiprovider

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 11:42 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2005 at 09:04 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 11:57 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted 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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.