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

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  


What is thin client And thick client..?

2 Answers  


Explain what are the steps to do to use alerts in bo?

0 Answers  


What is metrics?

2 Answers  


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

0 Answers  






Can anybody explain what mean by Database Delegated Measures?

2 Answers   TCS,


how to find the size of the report

1 Answers  


When we use aggregate awareness function in designer?

0 Answers  


how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,


What is security domain in Business Objects?

4 Answers   Polaris,


In banking domain how many Fact tables,Dimension table are present?

0 Answers   TCS, UST,


Give some information on report bursting?

0 Answers  


Categories