Hi;

1) Is there a url that discusses the best way to do this using ADO.NET (and
pretending it's a SQL database)?

2) Is there a url that shows the best way to access it as a cube taking full
advantage of all cube functionality?

Hello Dave,

I'd like to suggest you may consider ADOMD.net to access an OLAP-cube,
You may refer to the follow document for an example with ADOMD.net.
http://msdn2.microsoft.com/en-us/library/ms123461.aspx

Hope this helps. Please feel free to update here again, if you have any
more concern or there is anything we can help with. We are glad to assisst
you.

Have a great day
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Large VB ADO.NET Recordset Import into Excel
How start identity field at 100
Better way for dropdownlists
Add Records
Importing Data