1. can we create report using multiple universes and how ?
2. how can we move the objects from universe A to universe B
in report ?
3. how can we create aggregate table at universe level ?
4. if there is only one fact table in that universe, what
happens if we get fan trap ?



1. can we create report using multiple universes and how ? 2. how can we move the objects from univ..

Answer / mark

1. Yes, by using multiple data providers. Bear in mind,
though, whether or not it is meaningful to do so.

2. Objects are not moved between universes at the report
level, they are managed within Designer.

3. Aggregate tables cannot be created at universe level.
Derived tables that act as aggregate views can be created
but will not perform anywhere near as well as physical
aggregate tables.

4. Alias the non-fact table containing the measure, create a
second context containing the alias and derive the measure
object from the alias table.

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Business Objects Interview Questions

I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

2 Answers   Patni,


1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,


can anybody tell me about complicated object you have created

0 Answers  


every reports have docid,when i export a report docid will change or not?

4 Answers   Zensar,


Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,






What is the merge dimension?

3 Answers   IBM,


6.what is conformed dimension? R u used?

8 Answers   TCS,


what is universe null

0 Answers   TCS,


What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,


1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,


What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers   TCS,


Can anybody tell me what are the tuning problems?

0 Answers  


Categories