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
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