What's a Cube in Rolap?
Answers were Sorted based on User's Feedback
Answer / swati
ROLAP Cube is a datastructure that is used for faster analysis of data.ROLAP is slow at analysis but large at capacity(Multibillion rows can b stored) u can use good indexes to improve its performance
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / fatma
ROLAP Cubes: stands for Relational OLAP. In ROLAP cubes a
copy of data from the fact table is not made and the data
aggregates are stored in tables in the source relational
database. A ROLAP cube is best when there is limited space
on the Analysis Server and query performance is not very
important. ROLAP local cubes contain the dimensions and
cube definitions but aggregates are calculated when they
are needed. ROLAP cubes require less storage space than
MOLAP and HOLAP cubes.
Is This Answer Correct ? | 4 Yes | 1 No |
How to know the time taken for particular report execution?
What are the primary ways to store data in OLAP?
What are the data marts?
What are components of reportnet?
Which columns go to the fact table and which columns go the dimension table?
how to calculate sum(sal) with out using aggregator satge
I have two universes created by two difference database can we join them in designer & report level? How
How to answer the question how many fakt table in your datawarehouse and what size it have?
Can you state some of the innovations throughout history?
What is surrogate key? Where we use it? Explain with examples.
Which is the optimized method of extracting the data.
What are the advantages of query studio compared to report studio?