通过代码连接多维数据集,使用的是ADOMD.NET。代码如下:string mdxQuery = @"SELECT NON EMPTY
{
[Measures].[Store Cost] ,
[Measures].[Store Sales]
} ON COLUMNS,
NON EMPTY
{
(
[Product Local].[Product Local].[Product Local].ALLMEMBERS *
[Product Local].[Product Class Local].[Product Class Local].ALLMEMBERS *
[Product Local].[Product Category].[Product Category].ALLMEMBERS *
[Time By Day Local].[the_month].[the_month].ALLMEMBERS
)
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM [Foodmart Sale DW] ";AdomdConnection conn = new AdomdConnection(@"Provider=MSOLAP;Data Source=.;Integrated Security=SSPI; Initial Catalog=FoodmartSaleDW");
AdomdCommand comm = new AdomdCommand(mdxQuery, conn);
conn.Open();
CellSet cs = comm.ExecuteCellSet();我可以正常地打开AdomdConnection对象,但是在ExecuteCellSet的时候总是报错:用户 XXXXXX\XXX 无权访问 FoodmartSaleDW 数据库,或该数据库不存在。
有谁知道这是什么原因吗?
{
[Measures].[Store Cost] ,
[Measures].[Store Sales]
} ON COLUMNS,
NON EMPTY
{
(
[Product Local].[Product Local].[Product Local].ALLMEMBERS *
[Product Local].[Product Class Local].[Product Class Local].ALLMEMBERS *
[Product Local].[Product Category].[Product Category].ALLMEMBERS *
[Time By Day Local].[the_month].[the_month].ALLMEMBERS
)
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM [Foodmart Sale DW] ";AdomdConnection conn = new AdomdConnection(@"Provider=MSOLAP;Data Source=.;Integrated Security=SSPI; Initial Catalog=FoodmartSaleDW");
AdomdCommand comm = new AdomdCommand(mdxQuery, conn);
conn.Open();
CellSet cs = comm.ExecuteCellSet();我可以正常地打开AdomdConnection对象,但是在ExecuteCellSet的时候总是报错:用户 XXXXXX\XXX 无权访问 FoodmartSaleDW 数据库,或该数据库不存在。
有谁知道这是什么原因吗?
其实我也没接触到多维.楼主以后多给我们讲讲