----------------------Diff b/w MOLAP and ROLAP?
Answers were Sorted based on User's Feedback
Answer / sandeep (cowboy), patni
MOLAP: OLAP which comminicates with the Multi Dimensional
Analysis.
ROLAP is Relational OLAP.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / sharath
1) molap is multidimensional olap
rolap is relational olap.
2)in molap we can acess cubes but not in rolap.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suman palisetty
ROLAP has slower performance than MOLAP
ROLAP is more capable in handling large data volumes
| Is This Answer Correct ? | 0 Yes | 0 No |
How u provide security to reports in report studio or in cognos connection?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
What is the difference between ‘macro’ and ‘prompt?
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What are the different types of OLAP. Which one is Cognos Powercube?
How to test reports in cagonos ?
10 Answers CST, CTS,
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
In a Single page we are having 3 list. While running each has to populated in separate page?
what is tabular set? how can you break the report?
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
what are the names of the reports that you prepared?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.