Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5411 Views
- I also Faced
- E-Mail Answers
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 |
Is it possible to develop reports without Universe access?
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible
what is difference between global filter an query filter in web intelligence?
what is diff between Decode and case ? Give some Example?
is there any limit for rows and columns in cross tab
What is Array bind size in universe? Plz
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
What are @FUNCTION?
What is a universe?
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
What is the use of AFD? Where it can be stored?
How to change English language to Chinese in BO Desiner (Universe)?
Teradata 
