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

Multiprovider

Hi Experts,

Is there any standard SAP defined limit for using number of InfoProvider in a single MultiProvider.

Regards,

Ashish

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 12, 2005 at 08:26 PM

    Also keep in mind that unless you have parallel processing turned off for the query or multiprovider, and/or filter on the InfoProvider within the query, it will launch query against each InfoProvider within the MultiProvider concurrently.

    With 10 Infoproviders in a MultiProvider, 10 queries could be launched simultaneously. If 4 people all run the query around the same time, you could now have 40 queries running concurrently. It is easy to overload the server. I think I have seen some notes for 3.1 SP 21 that provide some options to limit the maximum nbr of processes that a MP could launch, to avoid overloading the server.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2005 at 08:01 AM

    Technically there are no restrictions with regard to the number of InfoProviders that can be included in a MultiProvider. However, SAP recommends that you include no more than 10 InfoProviders in a single MultiProvider, because any more than this number and splitting the MultiProvider queries and reconstructing the results from the individual InfoProviders takes a substantial amount of time and is generally counterproductive. Modeling these types of MultiProviders is also highly complex.

    Hope it helps!

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks a lot Roberto.

      I was looking for this only becuase I tried with 12 Infoprovider , so start thinking about SAP recommanded number or any restiction.

      Assigned points for your quick response and clarifications.

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2005 at 03:51 AM

    Hi Ashish,

    You could create a multiprovider to join your cubes into one single view. You have to remember that tehre must be commonality between those cubes so that the BW has enough context to provide information at the characteristic levels that you select. When you create the multicube, you need to define what characteristics from the Eg:-Sales cube will be related, and at what level to your Shipments cube. That is actually a very straighforward process. However, your design is key to complete reporting. You create the multicube within the InfoProvider area of BW.

    TQ

    Kumar

    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.