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 |
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
what is crosstab reporting,slice and dise and drill mode??
What is broad cast agent?
What are the data types present in bo? What happens if we implement view in the designer and report?
i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
Report have 10000 records,how to restrict the end user to 1000 Records?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
explain in detail about type 3?
while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?
can i use stored procedure in webi?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?