WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE?
WHAT IS MICROCUBE EXACTLY?
Answer / 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 |
Can you please send me the migration related issues .
Explain is there any other repository domains rather than universe, security, document?
which is the best way to resolve loop context r alias why?
How many universes will run maximum in single project
5.what is slowly changing dimension ?
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
what is meant by report busting
where are objects are stored ?
tell me about aggregate awareness in detail?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
Is it necessary to give joins to the aggrigate tables in the universe?
What are Alerter, Filters, Breaks and Conditions?