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

Read Master Data vs. MultiProviders vs. Retrieving from Query Designer

Example: I have an Infocube with sales info. User needs more information on material, hence I need to add material master data to report.

From my limited understanding there are 3 basic ways to merge/link data, especially if master data needs to be used.

1) Use "Read Master Data" option in rule details in transformation.

2) Create multiprovider.

3) Retrieve data from query designer.

I know it depends on the volume of records, but let's assume volume is above average. (Most companies don't even buy BW unless volume is pretty high).

1) What is best practice?

2) What is best solution for performance?

If I missed anything or made a mistake please lt me know.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2010 at 07:21 PM

    Why dont you add a navigational attribute of the material attribute you are interested, that would add the new field in to the infocube and you can use that in your queries and you dont need to change anything else.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Ok ...let me explain....when you enter to the infocube structure in change mode, you can see a folder called Navigational attributes, here you can see all the navigational attributes associated to the master data you are using as characteristics here you can see al the navigational attributes of 0MATERIAL if this new field is associated to the 0MATERIAL as a navigational attribute you can use in infocube and in navigational attributes folder in infocube yo u can select what navigational attributes use. After that you could see the new field in query designer.

      Regards

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2010 at 07:06 PM

    I cannot think of a Sales InfoCube without 0MATERIAL in it. Hence your transaction data (from the source) will anyway provide the material ID. Rest of the Information the Report you can have the attributes of 0MATERIAL. Each of these attributes can be displayed when you run the query.

    "Read Master Data" option in rule details in transformation is useful only when you want to use a characteristic in the Data Target (DSO or InfoCube) to be populated from the master data of any characteristics.

    In general, you can also use a start routine to do a look up in to the master data table of the characteristic you want to capture in your transformation.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      No I mean within Analyzer also you can display. You can make those attributes as Navigational (in the Data Modeling) if user want to filter on it.

      "Read Master Data" can be used in the transformation where your target could be any DSO or InfoCube or InfoObject. I would first get the requirements clear from the user on what is needed to be seen within the report and how.

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.