How the universe is working for fetching data? when it's get
connected with db or data source? what is micro cube and
when it is created? Is micro cube reside in inside of the
universe?

Answers were Sorted based on User's Feedback



How the universe is working for fetching data? when it's get connected with db or data source?..

Answer / v.sivakumar

1.universe fetch the data once it is connected to the
database.

2.Microcube works like a cache, once you drag few objects
in results objects pane and run, complete report data will
go and store in microcube and then display in the report.

For Example: In the report if you apply filter/rank/formula
you will get data that satisfies your
formulae/filters/rank, where the rest of the data goes? it
will be not deleted from the report, microcube will store
that data.
when ever you remove filters,formulae from the report,
again you will get the complete data from microcube. this
is the functionality of microcube.

Is This Answer Correct ?    6 Yes 0 No

How the universe is working for fetching data? when it's get connected with db or data source?..

Answer / bo_craze

1. When you run a report the report query which has the universe objects hits the db/datasource. This is how a universe works and connects to the db/ds.
2. A micro cube is something like an OLAP cube. When you run a report all the results from your report query gets stored in the micro cube. Whereas the document shows the objects/data that you have added in the document after all filters etc. So the micro cube holds all the report query results even if it is not visible in the report document.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Business Objects Interview Questions

What is the difference between absolute and relative div positioning?

0 Answers  


Pls Explain about the different between 6.5 & Xi R2

2 Answers   IBM,


how many reports have u created ? explain a few.

0 Answers   Bank Of America, TCS,


What is the link option in the reporting Environment?

3 Answers  


is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  


why less number of records in loop? why more number of records in traps?

1 Answers   Wipro,


how to create a derived table in designer? i need steps regarding derived table

1 Answers  


Explain what are the steps to be taken to schedule the report?

0 Answers  


i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

3 Answers   TCS,


what is incompactabulity error in sap bo

2 Answers  


What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,


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 Answers   Virtusa,


Categories