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


Please Help Members By Posting Answers For Below Questions

what is xcelsius architecture?

3737


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

550


Explain when to use local filter and when to use global filter?

603


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

1572


Can Bo generates the Report from the cubical data Explain?

1626






What is aggregate table and aggregate fact table ... Any examples of both?

609


What is the dense rank?

671


What are the steps to be taken to schedule the report?

551


What is the difference in creating filters in designer and business objects?

584


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

689


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

596


What is the difference between user and versatile user?

577


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

598


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.

2994


What is difference between custom hierarchy and report based hierarchy?

548