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 can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema

0 Answers   CSC,


What are Crystal Reports and Crystal Reports Explorer?

1 Answers  


What all performance improvement techniques used in crystal reports? (Particularly cr xi)?

0 Answers  


Can we create report using more than one database?

3 Answers   CSC, Seed Infotech, Target,


Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,






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

3 Answers  


I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.

5 Answers   Barclays,


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

2 Answers  


How can i normalize a Crystal Report..??

0 Answers   HCL,


How to pass stored Procedure Parameters to the report?

2 Answers  


HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM

1 Answers  


How do we format field?

4 Answers  


Categories