Stack Overflow
Stack Overflow

Questions tagged [adomd.net]

ADOMD.NET is a Microsoft .NET Framework data provider that is designed to communicate with Microsoft SQL Server Analysis Services. ADOMD.NET uses the XML for Analysis protocol to communicate with analytical data sources by using either TCP/IP or HTTP connections to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification

ADOMD.NET is a Microsoft .NET Framework data provider that is designed to communicate with Microsoft SQL Server Analysis Services. ADOMD.NET uses the XML for Analysis protocol to communicate with analytical data sources by using either TCP/IP or HTTP connections to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification. Commands can be sent in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), Analysis Services Scripting Language (ASSL), or even a limited syntax of SQL, and may not return a result. Analytical data, key performance indicators (KPIs), and mining models can be queried and manipulated by using the ADOMD.NET object model. By using ADOMD.NET, we can also view and work with metadata either by retrieving OLE DB-compliant schema rowsets or by using the ADOMD.NET object model.

133 questions
19
votes
5 answers

Different approaches to accessing SSAS

I’m interested in knowing some different approaches for retrieving data from Analysis Services, to use in either objects in code, or for end-user reporting. I’ve used two different approaches in the past, one was using ADOMD to pull results and put…
Meff
  • 5,889
  • 27
  • 36
16
votes
4 answers

First Step into ADOMD.Net - Cannot reference Microsoft.AnalysisServices

Can someone help me out please, as google is not providing the answers. I've got a SharePoint 2007 setup which uses SQL Server 2008 R2 SSAS OLAP cubes via some web parts. As a C# developer, Sharepoint is a nightmare, so I decided I needed to try to…
Chris Kemp
  • 2,069
  • 2
  • 18
  • 27
10
votes
1 answer

How to execute a MDX query of SQL Analysis Server in C#

I want to execute a SQL Analysis Query in C#. I have successfully connected to Analysis database using the below code: Server DM_Server = new Server(); Database AS_Database = new Database(); DM_Server.Connect(//SQL Analysis Server Connection…
Quest
  • 444
  • 1
  • 6
  • 18
8
votes
3 answers

MDX query containing 2 dimensions from the same Hierarchy

The relevant structures from my cube are that I have a Hierarchy with "Class" and "SubClass". I also have a Measure called "Value" which is what im trying to obtain. A simple query may look like: SELECT NON EMPTY ([Measures].[Value]) ON COLUMNS, …
Jamiec
  • 133,658
  • 13
  • 134
  • 193
7
votes
1 answer

Limiting the number of retrieved rows using Fill in ADOMD

The following C# code runs a DAX statement and retrieves a DataTable. This works fine, but now I need to retrieve from the database up to N rows. Is there a way to limit the number of rows returned by the Fill function? If not, how can I retrieve…
ps0604
  • 1,227
  • 23
  • 133
  • 330
6
votes
2 answers

ADOMD nuget package for asp.net core

I am looking at ADOMD nuget package. It seems it does not support ASP.NET Core framework. How can I Get this nuget package for ASP.NET core. If not this package, do we have any other alternative to connect to cube ?
OpenStack
  • 5,048
  • 9
  • 34
  • 69
6
votes
1 answer

Reading SQL Analysis Services Metadata

I have a number of objects in my SSAS cube, many of which were created to be invisible. For example: CREATE MEMBER CURRENTCUBE.[Measures].[Latency Backcolor] AS CASE WHEN [Average Latency] > [Web Alert] THEN 6384849 WHEN [Average Latency] > [Web…
BillP3rd
  • 1,009
  • 1
  • 9
  • 21
5
votes
3 answers

How to retrieve data from mdx query in c#?

I am trying to get data from an MDX query using the Adomdclient library. I relied on this example http://www.yaldex.com/sql_server/progsqlsvr-CHP-20-SECT-6.html. MDX query: SELECT {[Measures].[Cantidad Vta],[Measures].[Monto…
auraham
  • 147
  • 1
  • 2
  • 10
5
votes
2 answers

Where is Microsoft.AnalysisServices.dll

I'm trying to work through some examples working with Analysis Services Management Objects (AMO), specifically some of this content: https://technet.microsoft.com/en-us/library/ms345093.aspx These reference some objects in the…
Xedni
  • 3,662
  • 2
  • 16
  • 27
4
votes
0 answers

Error when connecting to powerbi dataset using adomd

I am completely new to xmla and attempting to use the 19.22.0.1 version of Microsoft.AnalysisServices.SdomdClient.NetCore.retail.amd64 to connect to a dataset in a Powerbi premium workspace. I lifted the connection string from the excel file…
Tedford
  • 2,842
  • 2
  • 35
  • 45
4
votes
2 answers

How to check if a windows user has access (Windows Integrated Security authentication) to SQL Server Analysis Services (SSAS) Server via impersonation

For a SQL Server instance, to check if a windows user is present and has any access or not one can try various ways as detailed here. I'm looking for something similar for SQL Server Analysis Services (SSAS) server. I went into properties of SSAS…
RBT
  • 24,161
  • 21
  • 159
  • 240
4
votes
1 answer

Error connecting to Azure Analysis Services

I am new to analysis services on azure and trying to query it using AdomdClient. I downloaded the latest client libraries from here : https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers What I tried : I am…
frictionlesspulley
  • 11,070
  • 14
  • 66
  • 115
4
votes
1 answer

Convert CellSet object to JSON result

I want to convert a CellSet object (which is the result of an MDX query in SSAS) into a valid JSON format which will empower some client side charts. Following is the sample query . SELECT [Measures].[Sales Amount - Reseller Sales] ON COLUMNS, NON…
user3908927
  • 51
  • 2
4
votes
1 answer

How to test connection to a data source in SSAS using C#

I have a database in Analysis Services on a remote server. This contains a data source for another database located on another remote server. I am trying to write a connectivity test using C# which will check the database connection between the two…
acatt
  • 487
  • 3
  • 10
3
votes
1 answer

ADOMDCommand ExecuteCellSet vs ExecuteReader

What are the major differences between ADOMD ExecuteReader and ExecuteCellSet method ? I understand that ExecutecellSet will return a cell set where as ExecuteReader will return flattened recordsets. At the end what I need is a DataTable which…
Cannon
  • 2,725
  • 10
  • 45
  • 86
1
2 3
…
8 9