Answer Posted / raman
MOLAP:An Query which can query the data from a
multidimensional database for multidimensional analysis know
as "MOLAP"
multidimensional analysis can be achieved by using drillup
and drilldown
ROLAP:An Query which can query the data from Relational
database is known as "ROLAP"
EX:Cognos8.4,Microstrategy
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are components of reportnet?
Describe the differences between a data warehouse and data mart.
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what are the basic needs to join two sources in a source qualifier?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is data warehosuing hierarchy?
What is the very basic difference between data warehouse and operational databases?
What are the different types of data warehousing?
Explain what does level of granularity of a fact table signify?
What do you mean by static and local variable?
What is the difference between view materialized view and view?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain what is analytical or analytic mean?