If a dimension in a cube is marked as ROLAP, and the query references a
member such as [Unknown Country] without fully qualifying it, how would
Analysis Services resolve this name? Would it need to fetch the members
of the ROLAP dimension from the database into memory? Or would it in
some way push the name resolution down to the underlying database?

-Aman

It would do the former (fetch into memory). In general it is always a good
practice to avoid unqualified names - both with ROLAP and MOLAP dimensions,
both in AS2K and AS2005.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"amansinha" <amansinha100 (AT) yahoo (DOT) com> wrote