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
1
vote
0 answers

SQL Server Agent Job step Processing Power BI Service Model through SSIS package (Analysis Services Processing Task) not working

I want to use a SQL Server Agent job on SQL Server 2017 (on premise) to update an XMLA Power BI dataset. In order to do so, I have created an SSIS package with an Analysis Services Processing Task where I connect to the Power BI api: Data…
Sven Erik Håberg
  • 61
  • 5
1
vote
1 answer

Connect to Power BI XMLA endpoint of dataset using Python

Is there a library to connect to a dataset using Python. I have uploaded blob as dataset in Powerbi. I want to access that dataset using XMLA endpoint. I tried using adodbapi but it isn't showing the tables I want. Thanks!
softwareDeveloperInProgress
  • 41
  • 5
1
vote
1 answer

Trying to connect to SSAS to connect to a PBI workspace in SSMS

Trying to connect to sql server analysis server for the first time to view datasets under a workspace but when i'm setting up my connection with Active Directory - Universal with MFA support authentification i'm getting the following error…
Roger Steinberg
  • 1,554
  • 2
  • 18
  • 46
1
vote
2 answers

Process Tabular cube from stored procedure

I have a stored procedure which populates a few tables in a db which is the data source for a tabular SSAS cube. I want to process the cube as a final step in the stored procedure when I am done loading the tables. I found this code: DECLARE @XMLA…
Programnik
  • 1,449
  • 1
  • 9
  • 13
1
vote
1 answer

XMLA server-side library?

I'm looking for a well documentated implementation of the XMLA protocole (proposed by Microsoft for OLAP engines). I'm looking for the server side implementation. I found this JAVA library: olap4j, it's not maintained. And it uses servelet. I…
Hamza EL KAROUI
  • 69
  • 7
1
vote
1 answer

Authenticate Azure Blob Storage Account in cloud using a runbook

In AZURE ANALYSIS SERVICES Tabular model (with compatibility level 1400) I imported a Blob storage account as a Data Source. It's Authentication Kind is Key kind of authentication. The key is a Static Key. But while refreshing the Tabular using a…
JSS Sravan Chandra
  • 11
  • 1
1
vote
2 answers

Schema-agnostic OLAP-like tool?

Do there exist any (ideally free or open-source) tools for performing OLAP analyses on arbitrary tables in a relational database, without requiring any advance specification of dimensional hierarchies, cardinalities, or any other meta-information…
goodside
  • 4,429
  • 2
  • 22
  • 32
1
vote
1 answer

JSON DDL request failed - pipeline rowset is missing

Objective Refresh a partition using a query (override). Using these as a…
Nick
  • 7,103
  • 2
  • 21
  • 43
1
vote
2 answers

SSIS Task: Process SSAS Cube and Parametrize Connection Strings

I want to process an SSAS Cube in SSIS. Is there a way to parametrize connection strings for Datamart SQL Server data source? I want to be able to set/configure SQL Server Connecting strings for our SSAS Dev, Test, and Production Environments in…
user11325615
1
vote
2 answers

SSAS programmatically back up metadata only

We have a set of SSAS 2005 databases that are maintained by various employees. The metadata/schema including format strings, etc. have evolved to represent a significant amount of work and they change periodically. We've tried having the business…
Penny
  • 347
  • 4
  • 12
1
vote
1 answer

SSAS Deployment Via Powershell Corrupting Format String

I am having a problem when deploying cubes via PowerShell that I don’t know how to fix. In my solution I have some measures with FormatString: \£ #,##0;-\£ #,##0. If I deploy them normally via Visual Studio, the XMLA I pull from the SSAS server…
cm1085
  • 33
  • 6
1
vote
0 answers

SSAS 2016 and XMLA: retrieving “MDSCHEMA_ACTIONS” Rowsets under specific scenario

I'm developing a Web client that uses XMLA over HTTP calls to communicate with a SSAS 2016 Cube. When my client's user clicks on a cell in a pivot grid that is based on this cube, I would like to show him a list of available SSAS "Actions" to…
Israel
  • 1,184
  • 2
  • 13
  • 26
1
vote
1 answer

SSAS webservice msmdpump.dll return error on 'OPTIONS'

I am having trouble getting a response from SSAS web service "http://localhost/OLAP/msmdpump.dll" in kendo pivot grid. The thrown error is
Amir Paziraee
  • 86
  • 2
  • 8
1
vote
1 answer

Processing Cube with datasource on another server

I have a Cube which is hosted on Server1. Then, in SSMS I do this: Right click -> Script Database As -> Create to -> New Query Editor Window. Then copy resulted XMLA. Then open XMLS query window on Server2, paste, run. Cube copied. I right click…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
1
vote
1 answer

Alter cube dimension by using XMLA

By using XMLA how to access WriteEnabled dimension property and modify it? Here is a sample I'm using for that …
mbigun
  • 1,304
  • 4
  • 19
  • 46
1 2 3
…
11 12