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
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 |
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 |
What is the difference between absolute and relative div positioning?
Pls Explain about the different between 6.5 & Xi R2
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
What is the link option in the reporting Environment?
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
why less number of records in loop? why more number of records in traps?
how to create a derived table in designer? i need steps regarding derived table
Explain what are the steps to be taken to schedule the report?
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
what is incompactabulity error in sap bo
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 ?