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
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Give some information on report bursting?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the difference between slice and dice and cross tab report?
How to execute the plsql procedure from the report by clicking with mouse?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain what is the difference between slice and dice and cross tab report?
How would you format some text using css to be verdana and bold?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the dense rank?
What three things do you consider to be the most important factors for a manager?
what is xcelsius architecture?
In banking domain how many Fact tables,Dimension table are present?