Click here to Skip to main content
15,867,834 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
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]')


HTML
[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
Posted
Updated 7-Mar-16 22:56pm
v2

1 solution

Please, take a look here: Retrieve data from sql cube[^]
Both answers refer to ADOMD.NET[^] framework.
 
Share this answer
 
Comments
Member-515487 8-Mar-16 4:54am    
An unhandled exception of type 'Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException' occurred in Microsoft.AnalysisServices.AdomdClient.dll

this exception getting
Member-515487 8-Mar-16 4:55am    
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]";

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900