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 |
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
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?
How toconnect one to one report?
HOW DO YOU SCHEDULE THE REPORTS?