Is it possible to join more than one universe in Busniess
Objects BOE XI ? If its so Please explain how is that
possible ?

Thanks in advance for the people posting the answers

Answers were Sorted based on User's Feedback



Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explai..

Answer / abc

Yes, we can join more than one universe in BO. we can join
2 master or kernal universes to one derieved universe.
To Link the universes go to universe parameters->links tab-
>add link.

Is This Answer Correct ?    3 Yes 0 No

Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explai..

Answer / pr

we can link universes using the parameter--link option.but
the database your using for both the universes must be
same.we can link as many universes but following the limitation.

Is This Answer Correct ?    2 Yes 1 No

Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explai..

Answer / saichand

The answers by abc,pr is correct. There is concept of
multiple star schema in the DWH for crating the universe.
Actually as per traditional DWH concept there are 3 types
of schemas are available.

1) Star Schema
2) Snow flake Schema
3) Multiple Star Schema or Galaxy Schema.

So before you create universe your data modeler suggest
which schema you have to fallow.
Especially multiple or integrated or galaxy schema is used
for when you are creating universe from different
datamarts.For example you need a report which should
contain data from both investments and assets
datamarts.Inthis case you have to create two different star
schemas for each datamart and linked them with based on
common field with help of conformed dimensions.(conformed
dimensions--these are the dimension tables which are common
for two fact tables).Hence integrated schema can able to
give the information from different datamarts of same
database instead of creating two different universe and
linked them. This is schema level solution. But the
disadvantage of this schema is, since the schema is very
big the performance is less due to more joins in the
schema. To improve the performance of the integrated schema
use the derived tables and indexes, aggregared functions at
database/schema level. Archiving the unused tables also do.
But the possibilities for using this type of schema is
depend upon project requirements and especially for complex
datamarts like financial domain related projects.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Crystal Reports Interview Questions

How to print two details fields at the bottom of the page

5 Answers  


Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,


Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?

2 Answers  


How to present data from Crystal Reports on to form?

3 Answers  


I have a crystal report with a linked subreport as well. is there any way not to print the current record on the main report if no records are returned from the subreport? thanks you email - stanlte@yahoo.com

3 Answers  






How many Sub Reports added in One MainReport?

4 Answers   Amadeus, Aviva, CTS, Patni, Welkin,


Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers

3 Answers   Wipro,


How do we connect to the database?

6 Answers  


How to add Crystal Reports(Standalone) to my VB.NET project

2 Answers  


Can we create report using more than one database?

3 Answers   CSC, Seed Infotech, Target,


How can i normalize a Crystal Report..??

0 Answers   HCL,


How to conditionally suppress a field based on whether a page number is odd or even?

3 Answers  


Categories