----------------------Diff b/w MOLAP and ROLAP?

Answer Posted / uma

MOLAP: data stored in multi dimensional cube.ROLAP: relies on manipulating data from relational database. MOLAP:excellent performance cz data retrival is easy and also optimal for slicing and dicing,ROLAP:performance can be slow cz query time can be long if the data size is large. MOLAP: performs complex calculations and ROLAP difficult to perform. MOLAP: handles limited amt of data ROLAP: handles large amt of data

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we drill through from a powerplay cube to reportnet?\

1868


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1798


What is the deployment requirements used in cognos?

528


how can you get the errors in job? when loops are araised we get error?

1629


What are all the different types of prompt in cognos?

528






What is meant by alternate drill down with ex?

602


Write some methods to apply securities in framework manager model?

632


Define report item?

632


Define metrics studio?

558


What do you understand by ‘ibm predictive maintenance and quality’?

540


What is the complex report you faced in real time?

1708


how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

668


What is meant by drill down?

504


is cognos 7 is better than cognos 8

1670


----------------------What are the User Securities?

1444