Architecture of MOLAP

When a report is executed by end user the actual data is retrieved from the MOLAP
cubes. The way it retrieves by using MDX queries based on the report. MDX stands
for Multidimensional expression. SQL is used to get the data RDBMS, MDX is used
to get the data from MOLAP. The MOLAP cubes are refreshed periodically
based on the data refreshes which happen in DW.