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 aggregate table and aggregate fact table ... Any examples of both?

614


Can we create universe with no cache??

1958


When we use aggregate awareness function in designer?

552


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

579


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2403






Can more than 1 metric be applied on an analytic in business objects?

1659


Explain how to schedule the report in b.o?

567


What Is The Difference Between Oltp And Olap?

682


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

591


how to create metric universe ?

1897


What is report template in b.o?

588


What is the difference between condition & filter?

609


what is xcelsius architecture?

3747


Explain when we use aggregate awareness function in designer?

590


Explain is there any default username & pwd for bo designer & supervisor?

599