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 performance tunning in BO in report level& designer level?

1 Answers   IBM,


what are cascading prompts explain with steps

4 Answers  


Can any one say me wat does"maintanence of universe" means wit?

2 Answers   Business Intelligence Analytics, NAL, TCS,


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

0 Answers  


1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

1 Answers   BNP Paribas,






What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  


what is the different between link and join ?

2 Answers  


what is optional prompt in boxi r2

4 Answers   Mind Tree,


CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers  


Can Bo generates the Report from the cubical data Explain?

0 Answers   Wipro,


can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  


Categories