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
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 |
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 |
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 |
How to print two details fields at the bottom of the page
Is there any feature like summing total in crystal report?
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?
How to present data from Crystal Reports on to form?
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
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
How do we connect to the database?
How to add Crystal Reports(Standalone) to my VB.NET project
Can we create report using more than one database?
3 Answers CSC, Seed Infotech, Target,
How can i normalize a Crystal Report..??
How to conditionally suppress a field based on whether a page number is odd or even?