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

Creating a request for XMLA for Azure Analysis Services

My goal is to exectue a DAX query in Azure Analysis Services using python in linux. I have tried many solutions and now I am facing this. I want to create HTTP POST to xmla endpoint. Is it even possible? The following request returns 400 Bad…
Mozgawa
  • 115
  • 9
0
votes
0 answers

Power BI - Is it possible to trigger a refresh of all tables, with all partitions refreshed at once?

We have incremental loads on several tables within our PBI EDW dataset. Due to a bug in our transformation tool, when I carry out a PBI deployment, I need to fully reload all partitions of all tables. Currently we perform a regular refresh (current…
Toasty
  • 51
  • 4
0
votes
0 answers

Azure Data Factory Webhook with JSON query as parameter

I've just created an ADF pipeline that allow me to refresh different partition of an Analysis Services Model (PBI XMLA) using a json script that I have to pass as parameter to my Webhook. In the lookup I retrieve the partition to refresh and inside…
GianLuca Colaiacomo
  • 1
  • 1
0
votes
1 answer

Creating XMLA file from tabular editor 2 with Powershell not working

According to the documentation of tabular editor 2, it should be possible to create an xmla file which you can use for later deployments. But the -X argument never give any results. Using the -X argument does not give any results. I have tried the…
djva
  • 1
  • 1
0
votes
1 answer

Error running the PowerShell script in Runbooks

Any help is appreciated. I am getting the error below when trying to execute the PowerShell script in Runbooks. Invoke-ASCmd : The term 'Invoke-ASCmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the…
Joel G
  • 1
  • 1
0
votes
0 answers

Unable to delete trace in SSAS

I created a trace in SSAS but I'm unable to delete it. Fairly new to SSAS and not really sure how to get around this. Version: 14.0.249.83 Tried deleting it with this:
ppomki
  • 1
0
votes
0 answers

Check and process a SSAS cube when it's not already processing

I have an application that is driven by a Microsoft Analysis Services Multidimensional Cube. Users access the application and load data periodically to the underlying SQL database. The cube is processed fully over night so users may see updated…
warrenk
  • 119
  • 1
  • 7
0
votes
1 answer

Get error trying to create SQL Server Agent Job with XMLA command

I am trying to run an XMLA command that kicks off an Xevent trace as a SQL Agent Job. (below) The command works fine in SSMS as an XMLA query. When I try to save this step as an SSAS Command in an agent job, it throws an exception - An exception…
Bill Park
  • 3
  • 2
0
votes
1 answer

XMLA endpoint certificate based SP for Power BI CI/CD with Tabular editor

I am trying to create a CI/CD pipeline in Azure DevOps for PowerBi models. I am facing issue with Tabular editor when trying to connect to Premium workspace using SP on powershell taks. SP is certificate based. Any idea how should I create…
choka
  • 30
  • 5
0
votes
1 answer

Microsoft Analysis Services over TCP encryption

I try to connect to MS-SQL-Analysis-Services via TCP, and looking for information, how encryption is actually done. I've found…
Daniel
  • 42,087
  • 4
  • 55
  • 81
0
votes
1 answer

Is there a way to build TMSL scripts programatically on the same way that XMLA tools create it (like Tabular editor) from an existent tabular db?

I am wondering how is possible to create a TMSL script from an tabular database (power bi service or SSAS) using some programing language. These kind of scripts are available in several tools, like SSMS or Tabular Editor: Example of the menu to…
A Echague
  • 3
  • 1
0
votes
1 answer

-Credential parameter not working with Invoke-ASCmd

I'm using SqlServer module for powershell( https://www.powershellgallery.com/packages/SqlServer/21.1.18256) and I'm trying to use Invoke-ASCmd with -Credential parameter. The problem is, -Credential parameter is ignored and the current user for whom…
BB2
  • 1
  • 2
0
votes
1 answer

MDX filtering by member property on SAP BW

I'm trying to filter members on axis by their name or unique name and I cannot get MDX below working on SAP BW (over XMLA). SELECT {Filter([Z_PRODUCT].AllMembers, ([Z_PRODUCT].CurrentMember.Properties("MEMBER_NAME") = ""))} DIMENSION PROPERTIES…
vrata
  • 33
  • 2
  • 5
0
votes
1 answer

Process Add XMLA measure group SSIS

Is it possible to execute process add on measure cube in SSIS? I tried to look for the XMLA script but I don't see anything for it. I need to run the script several times with different where parameter (Add processing will need to be added to for…
user14861333
0
votes
1 answer

Creating SSAS partitions from an XML file

I have a requirement to create new partitions in a cube using stored procedures. I have seen solutions using C#/VB/ but nothing for SP's I have generated the CREATE XMLA but have no idea how to hand that off to SSAS to create the partiton Any help…
Matt
  • 1
  • 1
1 2 3
…
11 12