MS SQL Server OLAP - Can't create data source as part of AS Tutorial

Author

Can't create data source as part of AS Tutorial

Ben Walling

2006-01-26, 4:58 pm

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.

Ben Walling

2006-01-27, 11:23 am

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? Pro...on&LinkId=20476

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

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

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

at
Microsoft.DataWarehouse.VsIntegration.Shell.Project. FileProjectHierarchy
. OnHierarchyNodeAppen
ding(IHierarchyNode node, IHierarchyNode parentNode)
at
Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at
Microsoft.DataWarehouse.VsIntegration.Shell.Project. FileProjectHierarchy
. MaterializeComponent
(IComponent component, Object parent)
at
Microsoft.AnalysisServices.Project.ComponentModel. AnalysisServicesHost
.Microsoft.AnalysisServices.Hosting. IHostMaterialization
Service. MaterializeComponent
(IComponent component, Object parent)
at
Microsoft.AnalysisServices. ModelComponentCollec
tion. Insert(IModelCompone
nt
item, String key, Int32 index, Boolean updateDependents)
at Microsoft.AnalysisServices. ModelComponentCollec
tion.Add(ModelComponent
item)
at Microsoft.AnalysisServices. NamedComponentCollec
tion.Add(ModelComponent
item)
at Microsoft.AnalysisServices. MajorObjectCollectio
n.Add(ModelComponent
item)
at Microsoft.AnalysisServices. ModelComponentCollec
tion.AddNew(String
name, String key, Type type)
at Microsoft.AnalysisServices.DimensionCollection.AddNew(String name,
String key)
at Microsoft.AnalysisServices.Design.TimeDimension. GetDimension(Databas
e
database, String newID, String newName)
at
Microsoft.AnalysisServices.Design.TimeDimension. CreateTimeDimensionF
romTable(Database
database, Boolean createNonKeyAttribut
eRelationships, DataSourceView
dataSourceView, String newID, String newName, DataTable mainTable, Object[,]
timeLevelColumns)
at
Microsoft.AnalysisServices.Wizards. TableBasedTimeDimens
ionPageBase. OnLeavePage(LeavePag
eEventArgs e)
at
Microsoft.SqlServer.Management.UI.WizardPage. RaiseLeavePage(Wizar
dButton
button)
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
EventArgs e)

Sponsored Links