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 the join problems comes appart from loop,chasm & fan Traps

1558


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4457


What sort of existing documents should business analysts refer to when starting on a new project?

626


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

608


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

1833






I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3003


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

604


in sap bi we have wad, then why we go for sap bo

2780


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

1405


what are the day to day activities of BO administrator ?

1980


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

562


Explain which versions are used in the bo dashboard work?

637


what is the difference b/w the refresh and buffered data?

1765


How to execute the plsql procedure from the report by clicking with mouse?

623


What we need to discuss with designer before starting the universe designing.

1826