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

multisource Universe?

hi guys

I have a structure which consist of several different databases which are SQL Server 2008 and I am working BO xi 4.0 on it. I do want to make a universe.However Sql 2008 database builds the table by adding each month and each individually. For example 2010 sales table, or 2011 sales table. Do I have to add these tables to universe by manually? Should I use universe designer for this structure? Should i use Information Design Tool?

Should I use Data Federator tools or Data Integrator tools which I havent use them before?

Do you suggest anything to me related to the this structure? It could be a road map or any documents? If you know something Would you please explain to me step by step ?

Best Regards

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 Aug 22, 2011 at 11:58 AM

    As already suggested I would definately consider changing the database design. However, if that is not an option I would you the Information Design tool where you can make a business layer (universe) based on multiple sources. Then you just have to make a connection to each database and connect it in the data foundation.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2011 at 02:02 PM

    How about correcting the horrible database design? Alternatively, you could create a bunch of empty sales tables streching out into the future and then put a UNION ALL view over them and reference that in the universe (or create a derived table in the universe).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2011 at 03:40 PM

    Hai SYaGCi ,

    One universe have only one connection(ODBC) string. but one ODBC connection use for many universes. So, The multiple connnections is not possible for one Universe.

    See the below Link

    [http://www.bidw.org/business-objects/universe-design/universe-access-restriction/]

    in the first template we give the only one connection to the universe.. but we does not give the more than one connection....

    if is required more than one connection, we use the ETL proccess and merge the both data into one database...and build the one ODBC connection to connect the data....

    Thank you,

    praveen

    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.