如何从多维数据集ssas获取数据 [英] How to fetch data from cube ssas

问题描述

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

推荐答案

请看一下：从sql cube中检索数据 [ ^ ]

两个答案都是指ADOMD.NET [ ^ ]框架。

Please, take a look here: Retrieve data from sql cube[^]
Both answers refer to ADOMD.NET[^] framework.

这篇关于如何从多维数据集ssas获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！