In the UDM overview document on the web it suggests that data source views
are accessible from clients like Excel. It does not explain how. I have not
managed to work this out or find additional info. Can anyone help?

I think you may have misinterpreted the UDM overview document. Can you paste
the exact paragraph which says that data source views are accessible to
clients like Excel ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/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.
==================================================

The role of a Unified Dimensional Model (UDM) is to provide a bridge between
the user and the data sources. A UDM is constructed over one or more physical
data sources, and then the end user issues queries against the UDM using one
of a variety of client tools, such as Microsoft Excel.



"Mosha Pasumansky [MS]" wrote:

Note, how nowhere does it say that client tool can query Data Source Views
(DSVs) - which is really not client's business to do. Client tools query the
UDM itself !

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/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.
==================================================

Mosha,

OK - I don't quite get it. If Excel was to access the UDM how would this
appear to Excel, via what connection technology. I'm still trying to get to
grips with SQL 2005 and this is confusing me somewhat.

"Mosha Pasumansky [MS]" wrote:

You connect to UDM from Excel pretty much the same way you used to connect
to cube in AS2K - just make sure that you choose new version of OLEDB for
OLAP driver (i.e. 9.0) which is capable of working against AS2005.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/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.
==================================================

OK - I tried this again just to check I was not missing something and all I
can see are the list of cubes. I was using v9 driver as you said. Is the cube
the method by which the UDM makes itself visible, or an I looking for
something else?

"Mosha Pasumansky [MS]" wrote:

You did everything right - to the client tools UDM is exposed as a cube.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/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.
==================================================

Is there any documentation that instructs you how to create a UDM with Feb CTP?



"Mosha Pasumansky [MS]" wrote: