Stack Overflow
Stack Overflow

Questions tagged [xmla]

XML for Analysis is an industry standard for data access in analytical systems, such as OLAP and data mining.

XML for Analysis is an industry standard for data access in analytical systems, such as OLAP and data mining.

XMLA is based on other industry standards such as XML, SOAP and HTTP. XMLA is maintained by XMLA Council with Microsoft, Hyperion and SAS being the official XMLA Council founder members. See Wikipedia article for more details.

With the acquisition of Hyperion in 2007, Oracle now supports XML for Analysis as well.

XMLA is the native protocol for Microsoft SQL Server 2005 Analysis Services (SSAS), used for all interaction between a client application and an instance of Analysis Services. Analysis Services fully supports XML for Analysis 1.1, and also provides extensions to support metadata management, session management, and locking capabilities. Both Analysis Management Objects (AMO) and ADOMD.NET use the XMLA protocol when communicating with an instance of Analysis Services. See Microsoft TechNet for more details.

170 questions
14
votes
2 answers

What options do I have for creating OLAP cubes with Postgres and making it accessible via .net webservices/wcf?

We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from this (updated daily) to run reports off of. To make this more flexible (as lots of different users require different…
Mr Shoubs
  • 14,629
  • 17
  • 68
  • 107
13
votes
1 answer

R clients to OLAP MDX servers

Has anyone tried to access an OLAP server offering a XMLA API (such as Mondrian) from R? I'd love to run MDX queries from R against Mondrian and retrieve result sets.
Xavier Guardiola
  • 2,699
  • 3
  • 19
  • 11
9
votes
4 answers

Query OLAP Mondrian (MDX, XMLA) with a Python interface?

Actually I'm using R + Python with RPY2 to manipulate data and ggplot to create beautiful graphics.. I have some data in a PostgreSQL database, and I'm using psycopg2 to query data. I'm starting a thesis, and in the future I need an OLAP cube to…
reyman64
  • 523
  • 4
  • 34
  • 73
8
votes
3 answers

Connect to Power BI XMLA endpoint with Python

Since the announcement about XMLA endpoints, I've been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] as an SSAS OLAP cube via Python, but I haven't gotten anything to work. I have a…
Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
4
votes
1 answer

Receive XMLA from ruby

I have a ruby server side program that uses a specific library to send request to an olap server and receives the result dataset from the same library. For some reason, I don't want to call the library methods for receiving result dataset and I…
Elaheh kamaliha
  • 753
  • 2
  • 8
  • 17
4
votes
1 answer

Error reopening connection to Power BI XMLA endpoint with Python

I have the following python code which works fine on run of the function but fails on second run. import adodbapi def connect_and_print(input_str): print("Function starting...", input_str) conna = adodbapi.connect(""" Provider=MSOLAP; …
Mike
  • 144
  • 10
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

.xmla deployment to SQL using C#

I use Invoke-ASCmd in PowerShell right now to create a database in SQL Server, like this: Invoke-ascmd -Query $MyScript -Server $ASServer Where $MyScript is a string holding the contents of an .xmla file that I read in previously. This works great.…
coinbird
  • 1,202
  • 4
  • 24
  • 44
4
votes
1 answer

Query Analysis Services Cubes in java without using msmdpump.dll

I am currently tasked to build some kind of healthcheck-application, which is later to be included in a jboss environment. But first things first. I need to access 3 different types of databases: MS SQL relational, TM1 and MS SQL Analysis Servies.…
Thomas Tschernich
  • 1,264
  • 15
  • 29
3
votes
2 answers

Is client-side OLAP (e.g. client-side MDX construction plus xmla4js) bad for security?

I'm working on a public-facing web project that will be powered in part by an OLAP server. I wanted to compare a couple ways of doing this from a security perspective: My initial idea was to pass some representation of the user's intent to the web…
Chris
  • 9,986
  • 8
  • 48
  • 56
3
votes
2 answers

Discovering partition names SSAS

Is there a way I can dynamically discover if a partition with a specific name already exists in my cube using DMV or XMLA? Thanks
Maxui
  • 210
  • 1
  • 3
  • 15
3
votes
1 answer

SSAS sync with XMLA in C# - broken with SQL 2017

I have some C# code using the undocumented Microsoft.AnalysisServices.Xmla.dll library which has been working fine for SQL 2016 SSAS. I generate the XMLA script, and then do: XmlaClient clnt = new…
PLK
  • 389
  • 2
  • 13
3
votes
2 answers

XMLA/TMSL from .Net Core

As the rest of the Azure world migrates to .Net Core it seems Azure Analysis Services is stuck on the .Net Framework. Is there a way to execute TMSL or XMLA against a SSAS Cube using frameworks available on .Net Core? This means AMO clients and…
CodeMonkey
  • 3,418
  • 4
  • 30
  • 53
3
votes
1 answer

Connect to SSAS OLAP Cube Using Python

Looking for resources to learn how to connect and fetch data from SSAS OLAP Cube. Found I can do it with XMLA lib, but found no resources to explore and learn.
user3001015
  • 49
  • 1
  • 1
  • 8
3
votes
3 answers

Processing SSAS tabular model fails in sql agent

I have a new SSAS 2016 tabular model (1200 compatibility level). I am trying to set up a SQL Agent job to process the model daily. However, when the job runs, it is throwing the following error: XmlaException. The { text node at line 7, column…
cmn
  • 93
  • 2
  • 8
1
2 3
…
11 12