I've installed SQL 2005, including Analysis Services, the sample databases,
and the tutorials. My machine already had VS2003 & VS2005, if that's of any
relation. From the samples, I was able to open and deploy the AdventureWorks
solution. I can see in Management Studio that I now have the Adventure Works
DW database, with its cubes, dimensions, etc.

I'm following the instructions per
http://msdn2.microsoft.com/en-us/library/ms167105.aspx, and I cannot click
the 'Finish' button in the wizard. It simply puts the focus back into the
Name field. Doesn't matter what I type in the Name field, the wizard won't
complete. I also cannot get a list of databases when using the suggested
provider of Native OLE DB\Microsoft OLE DB Provider for SQL Server. I can
get a list of database using the Native OLE DB\SQL Native Client provider and
the .Net Providers\SqlClient Data Provider. Both work fine when clicking
'Test Connection'. None of the options help with clicking the Finish button
at the end of the wizard.

I created the DataSource from another machine and tried to continue the
tutorial. Now, in the Cube Wizard, I get another error. I have now
installed BI Dev Studio on three different machines, and I get a whole
collection of different errors on different machines. Does this software
even really work?

===================================

This wizard will close because it encountered the following error:
(Microsoft SQL Server)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdN...n&LinkId=20476

===================================

Exception of type 'System.Runtime.InteropServices.COMException' was thrown.
(Microsoft.DataWarehouse.VsIntegration)

------------------------------
Program Location:

at
Microsoft.DataWarehouse.VsIntegration.Shell.Projec t.FileProjectHierarchy.OnHierarchyNodeAppending(IH ierarchyNode node, IHierarchyNode parentNode)
at
Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hi erarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at
Microsoft.DataWarehouse.VsIntegration.Shell.Projec t.FileProjectHierarchy.MaterializeComponent(ICompo nent component, Object parent)
at
Microsoft.AnalysisServices.Project.ComponentModel. AnalysisServicesHost.Microsoft.AnalysisServices.Ho sting.IHostMaterializationService.MaterializeCompo nent(IComponent component, Object parent)
at
Microsoft.AnalysisServices.ModelComponentCollectio n.Insert(IModelComponent
item, String key, Int32 index, Boolean updateDependents)
at Microsoft.AnalysisServices.ModelComponentCollectio n.Add(ModelComponent
item)
at Microsoft.AnalysisServices.NamedComponentCollectio n.Add(ModelComponent
item)
at Microsoft.AnalysisServices.MajorObjectCollection.A dd(ModelComponent
item)
at Microsoft.AnalysisServices.ModelComponentCollectio n.AddNew(String
name, String key, Type type)
at Microsoft.AnalysisServices.DimensionCollection.Add New(String name,
String key)
at Microsoft.AnalysisServices.Design.TimeDimension.Ge tDimension(Database
database, String newID, String newName)
at
Microsoft.AnalysisServices.Design.TimeDimension.Cr eateTimeDimensionFromTable(Database
database, Boolean createNonKeyAttributeRelationships, DataSourceView
dataSourceView, String newID, String newName, DataTable mainTable, Object[,]
timeLevelColumns)
at
Microsoft.AnalysisServices.Wizards.TableBasedTimeD imensionPageBase.OnLeavePage(LeavePageEventArgs e)
at
Microsoft.SqlServer.Management.UI.WizardPage.Raise LeavePage(WizardButton
button)
at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object sender,
EventArgs e)