WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE?
WHAT IS MICROCUBE EXACTLY?
Answer Posted / anil kumar ganga
1. OLAP systems are used to analyze the business.it solves
the questions What,when,who,where. Dataware house and OLAP
are same no difference.
2. Microcube resides in BO. I will ask you one question.
-->You have a report like World total sales. And you want
to show only India sales to your user. what you wil do? Yes
you need to apply filters. You have applied a filter to
show India sales. Now except India no country sales is
visible on your report. where it goes? It goes to microcube.
And if you remove filter and refresh the report,the
information which is stored in microcube will come into the
report. It is like a cache. Hope you completely clear on
this
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain what are the steps to be taken to schedule the report?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to execute the plsql procedure from the report by clicking with mouse?
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?
What is thumbnail?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is difference between webi and infoview?
Explain in detail about type 1?
Explain about a time when you discovered a more efficient way to do a work task?
Can we create universe with no cache??
What is the difference between datawarehousing and businessintelligence?
What is a bo repository?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message