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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1557


What task is 98% of the required work of a business analyst?

581


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1829


How were the reports scheduled and how to resolve unexecuted documents?

2223


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4191






Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

686


How to schedule the report in b.o?

564


Explain what is the difference between business requirement document and use case document.

579


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1481


What is thumbnail?

580


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

553


what is document design in boxi,have u participate in that

1663


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

591


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1817


What are the data types present in bo? What happens if we implement view in the designer and report?

622