>>>通过OLEDBDataAdapter也能得到结果,填充到DataSet中后,结果也是正确的what are the column names?foreach (DataColumn dc in YourDS.Tables[0].Columns) Response.Write(ds.ColumnName);what does your ItemTemplate look like? do the column names match?
好处就是统计的数据来得方便!!DataSet中的列名是下面这些,其中只有[Phone Type].[Phone Type].[MEMBER_CAPTION] 这个能显示出来,其他都不行啊。[Phone Type].[Phone Type].[MEMBER_CAPTION] [Phone Man Station].[所有 Phone Man Station].[建议] [Phone Man Station].[所有 Phone Man Station].[举报] [Phone Man Station].[所有 Phone Man Station].[其他] [Phone Man Station].[所有 Phone Man Station].[咨询]请帮忙!
DataGrid的列是设置为动态生成的。
I don't have analysis services set up, so cannot test it for you, are you sure those are the column names? are there other tables in that DataSet? also seeHierarchical Data Binding in ASP.NET http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspn-hierdatabinding.asp
that is weird, what is the datatype? foreach (DataColumn dc in YourDS.Tables[0].Columns) Response.Write(ds.ColumnName + "=" + ds.DataType.Name); you may be interested in the following artcle:Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx
[Phone Type].[Phone Type].[MEMBER_CAPTION]=String [Phone Man Station].[所有 Phone Man Station].[建议]=Object [Phone Man Station].[所有 Phone Man Station].[举报]=Object [Phone Man Station].[所有 Phone Man Station].[其他]=Object [Phone Man Station].[所有 Phone Man Station].[咨询]=Object [Phone Man Station].[所有 Phone Man Station].[]=Object不显示的都是object类型的
Response.Write(ds.ColumnName);what does your ItemTemplate look like? do the column names match?
这个能显示出来,其他都不行啊。[Phone Type].[Phone Type].[MEMBER_CAPTION]
[Phone Man Station].[所有 Phone Man Station].[建议]
[Phone Man Station].[所有 Phone Man Station].[举报]
[Phone Man Station].[所有 Phone Man Station].[其他]
[Phone Man Station].[所有 Phone Man Station].[咨询]请帮忙!
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspn-hierdatabinding.asp
Q2、是关于数据的,如果我在PhoneRecord表(就是原始数据表)中增加了一条记录,在统计结果中不能实时变化,只有在OLAP Service的管理器中同步一下数据源才行。
Q3、OLAP的发布 用OLAP管理器中建立的维度模型怎么能便捷的发布到客户的服务器上
Q3 :你可以到http://www.dwway.com/ 去看一下,
A2:还是没找到方法
A3:通过mamdarch.exe来完成存档或还原。这个文件位于:\program files\microsoft analysis service\bin目录下。
foreach (DataColumn dc in YourDS.Tables[0].Columns)
Response.Write(ds.ColumnName + "=" + ds.DataType.Name);
you may be interested in the following artcle:Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx
[Phone Man Station].[所有 Phone Man Station].[建议]=Object
[Phone Man Station].[所有 Phone Man Station].[举报]=Object
[Phone Man Station].[所有 Phone Man Station].[其他]=Object
[Phone Man Station].[所有 Phone Man Station].[咨询]=Object
[Phone Man Station].[所有 Phone Man Station].[]=Object不显示的都是object类型的