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.

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.

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.

How do we format field?

4 Answers  

---

When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From

3 Answers  

---

How to access crystal reports in .net?

0 Answers  

---

How to refresh the crystal report from the application ?

6 Answers   Satyam,

---

How can we improve the performance of a crystal report?

0 Answers  

---

One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita

5 Answers   Barclays,

---

Can we use stored procedure for creating the report?

11 Answers   Medreich,

---

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)?

0 Answers  

---

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

5 Answers  

---

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

0 Answers   CSC,

---

Can we use our own SQL for creating a report?

5 Answers  

---

hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....

0 Answers  

---