Skip to Content
avatar image
Former Member

Create a universe based on multiple existing universes

I have a BI 4 SP02 installed in Windows OS. I am using Information design tool to create data foundation to connect to multiple data sources. Instead of using multiple database connection, can I create a data foundation to connect to multiple universes. My intention is not to create new universe based on multiple databases. Instead, I want to combine two existing universes as one and create report from that. Is it possible to do? if so, may I know how to do that?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 22, 2011 at 01:35 PM

    You cannot create datafoundation on top of the universes. I think you are looking for option linking of the universes, i.e not possible if ur universe is designed using IDT (.unx) format. As you said u already have universes, it means you have data foundation behind that. So the alternative option is to create new business layer by using this existing data foundations. Other option is, create report using multiple data providers where you can connect to multiple universes. with this you can avoid the creation of new universe.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2012 at 12:16 PM

    Hi

    If you want to combine two universes and make a report of it, it is possible by universe linking concept.

    If you have two universes for example, then these two universes have to be linked by using any of these two methods.

    1. Add link

    2. Include link

    Add Link : Complete reusing of an existing universe in the current universe.

    Steps

    1. File > parameters > link tab> Add link> browse for the universe> open > ok.

    Then make the join between the common object.

    Save and export.

    Include link: Partially reusing of the existing in the current universe with few modifications.

    Steps

    1.File > parameters > link tab> Include link> browse for the universe> open > ok.

    Hope it helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 19, 2012 at 04:40 PM

    I am interested in the same possibility.
    The guide instructs to make a new data foundation and mark it as multisource enabled.
    Also you have to use connection shortcuts to relational connections.
    Doing this I am able to add tables and joins.
    Even when I add a connection to an Excel source and link it to the multisource dfx, then the Excel table is displayed in the master section.
    However, when converting a .Unv. to .Unx and link it to the multisource .dfx the universe is showing up as a .blx and .dfx with the original name separately(not linked to the multi source .dfx). In the multisource .dfx I see the connection and the possibility to add tables, but no added tables.
    I can copy them  from one .dfx to the multisource .dfx by pointing all links separately, but I cannot imagine that this is the way to do it (and still then I am missing the .blx).

    Does anyone have experience in converting a .unv. to unx and link it to a multi source .dfx?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      @Hazeleger

      You cannot convert a unv to a unx and link it to a multisource dfx. The reason why is that the unv universe per definition is single source and it will be so after conversion to unx - sorry