问题描述
select * from openquery(BILS
,
'WITH MEMBER [Measures].[ParameterCaption] AS [ServiceOwner].[Owner].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [ServiceOwner].[Owner].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [ServiceOwner].[Owner].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,[ServiceOwner].[Owner].ALLMEMBERS ON ROWS FROM [IFLBIDSV]')
[ServiceOwner].[Owner].[Owner].[MEMBER_CAPTION] [Measures].[ParameterCaption] [Measures].[ParameterValue] [Measures].[ParameterLevel]
NULL All [ServiceOwner].[Owner].[All] 0
NULL [ServiceOwner].[Owner].&[] 1
Call Centre Call Centre [ServiceOwner].[Owner].&[Call Centre] 1
CC Email CC Email [ServiceOwner].[Owner].&[CC Email] 1
CFR-UW CFR-UW [ServiceOwner].[Owner].&[CFR-UW] 1
CMU CMU [ServiceOwner].[Owner].&[CMU] 1
Distribution Support Distribution Support [ServiceOwner].[Owner].&[Distribution Support] 1
Financial Operations Financial Operations [ServiceOwner].[Owner].&[Financial Operations] 1
Group Operations Group Operations [ServiceOwner].[Owner].&[Group Operations] 1
New Business New Business [ServiceOwner].[Owner].&[New Business] 1
Not Mapped Not Mapped [ServiceOwner].[Owner].&[Not Mapped] 1
Persistency Persistency [ServiceOwner].[Owner].&[Persistency] 1
Policy Servicing Policy Servicing [ServiceOwner].[Owner].&[Policy Servicing] 1
Underwriting Underwriting [ServiceOwner].[Owner].&[Underwriting] 1
我的尝试：
如何在c＃
中获取和读取数据
i尝试使用Dataset它给出相同的输出但是如何阅读我想将数据填充到融合图表
adomdConnection.ConnectionString =数据源= 172.16。 50.107;用户ID = sa;密码= sa @ 1234;初始目录= BILS;;
这是我的链接名称BILS
adomdCommand.CommandText =WITH MEMBER [Measures]。[ParameterCaption] AS [ServiceOwner]。[Owner] .CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures]。[ParameterValue] AS [ServiceOwner]。[Owner] .CURRENTMEMBER.UNIQUENAME MEMBER [Measures]。[ParameterLevel] AS [ServiceOwner]。[Owner] .CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures]。[ParameterCaption]，[Measures]。[ParameterValue]，[Measures]。[ParameterLevel]} ON COLUMNS， [ServiceOwner]。[所有者] .ALLMEMBERS来自[IFLBIDSV];
Microsoft中出现未处理的Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException类型异常.AnalysisServices.AdomdClient.dll
What I have tried:
how to fetch and read data in c#
i tried with Dataset it giving same out put but how to read i want to populate data to fusion chart
adomdConnection.ConnectionString = "Data Source=172.16.50.107; User Id = sa; Password = sa@1234;Initial Catalog =BILS;";
this is my link name "BILS"
adomdCommand.CommandText = "WITH MEMBER [Measures].[ParameterCaption] AS [ServiceOwner].[Owner].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [ServiceOwner].[Owner].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [ServiceOwner].[Owner].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,[ServiceOwner].[Owner].ALLMEMBERS ON ROWS FROM [IFLBIDSV]";
An unhandled exception of type 'Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException' occurred in Microsoft.AnalysisServices.AdomdClient.dll
推荐答案
这篇关于如何从多维数据集ssas获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！