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

business layer views in IDT 4.0


I have a situation here at work.

I need to create universe from different databases and also implement concept of linked universes in 4.0. Have a core universe and reuse the common components among other universes.

The data structure is divided into many datamarts [databases]. The tables used to create my core universe is in database1 and derived tables used to create my derived universes are in different databases2, db3 etc.

In universe design tool, the requirement is that all tables should reside in the same database.

But my data is distributed on different databases like this

CoreDM-is the database to create my core universe.

AdmissionDM- is the database to create derived universe1

FinanceDM- is the database to create derived universe2

PayrollDM- is the database to create derived universe3

and so on.....

Since universe linking is not availabe in 4.0, i have read about business views in universe using IDT. Can anyone please tell me steps involved in accomplishing the task.

Thanks a lot.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 28, 2012 at 04:43 PM


    In BO 4.0 it is possible to create universe based on multiple database connection.

    This feature is provided in Information Design Tool(IDT).

    Creating universe in IDT requires to create following resources
    1.Project : It is local workspace which contains all the resources to create one/multiple universes
    2.Connection: It defines how universe can access a relational or OLAP data source.
    3.Data Foundation:It is a schema which defines relevant tables and joins from one or more databases.
    4.Business Layer: Business Layer is a collection of metadata objects.

    You can create multiple connection to different database and while creating Datafoundation you can select Data foundation Type as "Multisoucrs-Enabled". Once you select this option you'll be able to see the connections which you have created.Then you can proceed further adding tables from different datasources and create a universe.

    Please let me know if it helps.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2012 at 01:28 PM

    Hi Pre,

    In BO 4.0 there is no linked universes. However, there is Data Federator engine embedded inside it. This allows you to create universes from different data sources.

    Check the second part of this blog and you will also find some useful links how to achieve it.

    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.