Dim objCellSet As CellSet
Dim objConnection As New AdomdConnection("Data Source=localhost;Initial Catalog=Adventure Works DW 2008")
Dim objCommand As New AdomdCommand()
Dim objDatatable As New DataTable
Dim strCommand As String
strCommand = "SELECT [Measures].[Reseller Sales Amount] ON COLUMNS,"
strCommand = strCommand & " [Product].[Category].[Category] ON ROWS "
strCommand = strCommand & " FROM [Adventure Works]"
objConnection.Open()
objCommand.Connection = objConnection
objCommand.CommandText = strCommand
objCellSet = objCommand.ExecuteCellSet()
Dim objDataAdapter As New AdomdDataAdapter(objCommand)
objDataAdapter.Fill(objDatatable)
2 个回复
天善_小龙 2015-10-13 回答
赞同来自: loader
具体你可以参考下面的文章:
使用 ADOMD.NET 进行开发: https://technet.microsoft.com/zh-cn/library/ms123483(v=sql.110).aspx
另外了解下用于 Analysis Services 连接的数据访问接口: https://msdn.microsoft.com/zh-cn/library/dn141152(v=sql.120).aspx
如果想参考一个例子,可以看下这个:
Cubes, MDX, Analysis Services and ADOMD in C# http://www.codeproject.com/Articles/6562/Cubes-MDX-Analysis-Services-and-ADOMD-in-C
没事多去http://www.codeproject.com/ 上面看看,里面有很多接口开发,会提供sample.
稍等,还有另外一个大神的文章你也可以看看: Sorna Kumar Muthuraj
https://gallery.technet.microsoft.com/scriptcenter/6901ede5-5d59-4b1f-8f1b-df3c8e645048
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2015-10-13 回答
赞同来自:
%ProgramFiles%\Microsoft.NET\ADOMD.NET\90\Microsoft.AnalysisServices.AdomdClient.dll
Dim objCellSet As CellSet
Dim objConnection As New AdomdConnection("Data Source=localhost;Initial Catalog=Adventure Works DW 2008")
Dim objCommand As New AdomdCommand()
Dim objDatatable As New DataTable
Dim strCommand As String
strCommand = "SELECT [Measures].[Reseller Sales Amount] ON COLUMNS,"
strCommand = strCommand & " [Product].[Category].[Category] ON ROWS "
strCommand = strCommand & " FROM [Adventure Works]"
objConnection.Open()
objCommand.Connection = objConnection
objCommand.CommandText = strCommand
objCellSet = objCommand.ExecuteCellSet()
Dim objDataAdapter As New AdomdDataAdapter(objCommand)
objDataAdapter.Fill(objDatatable)
objConnection.Close()