Answer Posted / 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 |
Post New Answer View All Answers
What is prompt types of prompts?use of prompts syntax of prompt?
What is the difference between connected and unconnected stored procedures?
Explain about core dimension, balanced dimension, and dirty dimension?
What is freehand sql?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain vldb?
What is data warehosuing hierarchy?
What are diagrams?
What is incremintal loading?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Briefly state different between data ware house & data mart?
How to stop a batch?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
what type of raid setup would you put your tx logs?
What are the possible data marts in retail sales?