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

hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.

0 Answers  


I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?

5 Answers  


how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema

0 Answers   CSC,


What are the sections that we have in Crystal reports?

11 Answers  


Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities

2 Answers  


How to Filter the Crystal reports?

12 Answers   CCIL, Mammut Building Systems,


Where can we find the log file generated when we run a crystal report?

0 Answers  


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

2 Answers  


Can we add any database field once we have chosen ?Close? button?

2 Answers  


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 uncertainty 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 the reports at run time?

0 Answers  


hi ... i've created one crystal report in windows form and one crystalreportviewer .. the following is my code.. in form1.cs file try { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net- informations.pdf"; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); } the above code is saving the file into pdf into specified path.. but i dont want to save a file i should get direct print preview and have a option to print .. As we do in web application using crystal report viewer clicking print and report will be opened in pdf.. and the click print.. i want the same function as we do in web application... i'm writing code in c#.net hope the above explaination will be understood clearly..

0 Answers  


Can we call or add subreport within subreport?

10 Answers  


Categories