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

Universe building strategy for SAP Infocubes and BW queries

Hi All,

We are on BO XIR2.We have recently setup an SAP BI server and we are planning to build webi reports using BO.

In Universe designer,as of now we know of building one connection per BW query or Infocube

ie one universe per BW query or Infocube.

But this could result in huge number of connections and universes being generated depending on the number of reports.

Is there an alternative or better approach to minimize the number of universes to be created and maintained?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Feb 19, 2009 at 02:46 PM

    hi Rajesh,

    you are correct that the connection is on a query level. You don't need a connection for every single report but you should also not go to the other extreme where you create one large query for all reports.

    take a look at some best practices here:

    /people/ingo.hilgefort/blog/2008/11/19/businessobjects-integration-with-sap-netweaver-bi--technical-material

    Ingo

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 18, 2009 at 10:21 AM

    Hi Rajesh,

    an option is to use SAP BW multiproviders/infosets in order to bundle results from different cubes in a way that you can reduce the number of BW queries you require to get the data you want. But at any case there is almost always a trade-off between performance and flexibility. A query with many key figures and/or dimensions is not a good practice when most of them are rarely used in your reports.

    Regards,

    Stratos

    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.