Hi eb

I don't get the basic architecture of ROLAP dimensions (say all partitions and dimensions are ROLAP in my cube).

Google sais about ROLAP cubes: "... dimensions and measures are referenced within the relational data warehouse and not stored separately within the cube."

Questions:

1. Client sends query to ROLAP cube in MDX asking for time member [Time].[year].&[2013] on rows.

I am guessing that based on his empty defenitions of attributes, SSAS knows to translate this to sql's where clause where the year attribute key members column = 2013.

Then the sql's result set is mapped again by SSAS from 2013 to [Time].[year].&[2013] before sent finally to Client?

2.If so - is there a point in having MOLAP dimensions together with ROLAP partitions if queries are translated to sql any how and executed on relational data source side?

Thanks for your thoughts!

Rea