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
0
votes
0 answers

Integrating DAX query in an XMLA request in c#

I would like to integrate a DAX query in an xmla and run it on an azure analysis service. The folowing XMLA can be run in management studio successfully:
Kaja
  • 2,962
  • 18
  • 63
  • 99
0
votes
1 answer

Script to create database xmla file

I'm looking for an automatic method for generating the file that is created in the first screenshot to see if it can be done: It is an xmla file detailing the structure of the tables within the database. Preferably a solution in C# or PowerShell,…
CDWatson
  • 41
  • 4
0
votes
1 answer

powerBI XMLA Error deploying metadata changes

I'm using Visual Studio (SSDT) to modeling and deploy my model to PowerBI Premium Workspace and create my report in PowerBI desktop, however now I've added new tables and applied changes on that and I'm not able to deploy it again. Tabular Model…
Marlon Batista
  • 1
  • 2
0
votes
1 answer

Sending XMLA DISCOVER_XML_METADATA to SSAS from an SQL query

I am trying to issue an XMLA statement for "discover" to an Analysis Services Instance. Sending the XMLA from an XMLA window in Management Studio works fine and returns the desired result, so I am confident I got the basic syntax right. Wraping it…
Ralf
  • 538
  • 1
  • 6
  • 17
0
votes
1 answer

How to use python to run an xmla query

My requirement is to use python to connect to Analysis Services server, run an xmla query, such as MDSCHEMA_CUBES …
pyguypy
  • 29
  • 4
0
votes
1 answer

Error when importing tables from Power BI Premium into Azure Analysis Services

I have recently created an Azure Analysis Services model and created a connection with my power BI premium model. This PBI model has the XMLA set to read/write. I have successfully managed to create a connection between the two models using the PBI…
VITOR SILLOS ALONSO
  • 3
  • 1
0
votes
0 answers

PowerShell: How to return positive ErrorCode for SSAS XMLA scripts

I am executing a power-shell script using Control-M tool using below command. powershell -command "& { F:\SAS01\Scripts\Powershell\Medicare} Powershell Script: Invoke-ASCmd -Server:Hostname -InputFile:"F:\SAS01\Scripts\Powershell\Medicare.xmla"…
Mohan.V
  • 141
  • 1
  • 1
  • 10
0
votes
3 answers

SSAS XMLA DISCOVER: how to get list of roles in SSAS database

I am trying to get a list of roles existing in an SSAS DB using XMLA. I need only roles, not other information. I know there is a DISCOVER_XML_METADATA: …
Igor Zhilin
  • 11
  • 3
0
votes
0 answers

Execute XMLA against SSAS

I'm using below function to execute my xmla file against a SSAS instance. $Xmla is a file that creates a db. When i execute this function, the script runs but towards the end it just opens this $Xmla file and does nothing. Also the machine running…
Tag
  • 209
  • 1
  • 3
  • 7
0
votes
2 answers

Opensource or free online Oracle OLAP Server or Offline Oracle Cube file

Is there any free online Oracle OLAP servers available for testing? or Is there any offline cube available for Oracle like (.cub) in SSAS.
Prince Ashitaka
  • 8,623
  • 12
  • 48
  • 71
0
votes
1 answer

How to get a list of partition inside a MeasuresGroup

Is there any way to get a list of partitions inside a MeasuresGroup ? And how can I process them with specific conditions on there name ? Thanks for your help.
Hamza Lahbabi
  • 29
  • 1
  • 9
0
votes
1 answer

SSAS - check if the user has a role assigned

I'm trying to create a way to partially automate creation of roles and role permissions in SSAS multidimensional cube. Due to some restrictions on my side this can only be done with using T-SQL to generate XMLA scripts and sending them to SSAS…
Alex_404
  • 399
  • 2
  • 12
0
votes
1 answer

Class is inaccessible due to its protection level in DLL reference

I've seen this error in C# before when referencing a class with private properties, but I'm at a loss here, as this class has public properties. It's actually a microsoft .dll I'm creating a new object: XmlaClient clnt = new XmlaClient(); But that's…
coinbird
  • 1,202
  • 4
  • 24
  • 44
0
votes
2 answers

How to discover existing partition names in ssas tabular model-2017

How to find existing partition names in cube. I would like to check dynamically whether a partition exist or not using loop in SQL Linked server.
saij
  • 57
  • 2
  • 7
0
votes
0 answers

Getting Error as The JSON DDL request failed with the following error: Cannot de-serialize Partition. The JSON input is not properly formed

I have been getting below error when I try to execute procedure after concatenated ID parameter in XMLA cube partition code. OLE DB provider "MSOLAP" for linked server "SSAS" returned message "The JSON DDL request failed with the following error:…
saij
  • 57
  • 2
  • 7
1 2 3
…
11 12