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
3
votes
1 answer

icCube XMLA request documentation

Is there any documentation on how to formulate a request to the XMLA? The icCube XMLA endpoint for me is: http://localhost:8282/icCube/xmla I want to make a demo call to the endpoint using postman or something similar, but I am not sure which…
Ryan27
  • 453
  • 4
  • 16
3
votes
1 answer

How to use a PostgreSQL DB as XMLA datasource?

Basis: PostgreSQL database with normal and reporting data Downloaded the Mondrian zip from here I have a client pivot grid component (DevExtreme Web) As i understand it so far, i have to use a OLAP-server that functions as connector between MDX…
Spenhouet
  • 6,556
  • 12
  • 51
  • 76
3
votes
1 answer

icCube connecting to Excel 2016

I get the following warning when I open a xlsx spreadsheet, connected to iccube, in Excel 2016. It works in Excel 2013 but not 2016. Excel cannot connect to your database with the driver you specified in your data source. The driver does not…
Paul
  • 31
  • 1
3
votes
1 answer

Add new users in SSAS security

I want to add users in SSAS security using following XMLA script. DECLARE @CreateUserInSsasXMLA VARCHAR(MAX) = ' …
Mukund
  • 1,679
  • 1
  • 11
  • 20
3
votes
1 answer

python olap.xmla mdx queries returning single value?

I am always getting a single value in MDX query using python. I am connecting to icCube which has xmla support. provider = xmla.XMLAProvider() con = provider.connect(location='conn_str',username='q1',password='q2') cmd="""WITH MEMBER Measures.[Avg…
Animesh Saxena
  • 449
  • 4
  • 11
3
votes
1 answer

XML/A not connecting to Jaspersoft

I setup my XML/A connection using this link. I can connect to it through remote machines via SSRS and MS-Excel. But when I am trying to create a XML/A connection in Jaspersoft Studio or iReport, It doesnt show the cubes at all. I am using SQL Server…
KrazzyNefarious
  • 3,202
  • 3
  • 20
  • 32
3
votes
1 answer

Configure proactive caching in Analysis Services with XMLA or C#

I am configuring proactive caching with MSSQL management studio using a wizard (please look at the attached screenshoots below). It works fine, but I have to configure the same from code (C#, XMLA or any other way). I cannot find enough information…
Dmitrii Tarasov
  • 414
  • 2
  • 13
3
votes
1 answer

How to configure Mondrian embedded sample for XMLA communication

I downloaded and installed the the Mondrian 3.4.1 stable community release with the embedded derby database instance. I have many of the examples up and running on a local tomcat instance, but I cannot get the XMLA examples to work, and I am unable…
jesse
  • 51
  • 4
3
votes
0 answers

OLAP Solution for MySQL

I'm developing a project on .NET and I need to include an OLAP-based reporting module. What is the better OLAP solution for the large MySQL DB(each month there will be about 10 millions new rows), that supports XML for Analysis (XMLA)? I've already…
Alexander
  • 497
  • 3
  • 9
  • 23
2
votes
2 answers

Creating ssas cube in xmla structure

I want to create a cube by using xmla structure, with out using the BIDS. How to do that. What dll or references are required to get the cube. Thanks In advance for your help Mihir
Mihir
  • 8,696
  • 18
  • 56
  • 87
2
votes
1 answer

IcCube Excel Xmla opens one session (connection) per PivotTable

We have produced some Excel files using Xmla Pivot Tables against Iccube schemas. Everything is working well except the fact that we noticed : Each Pivot Table on a single file (even single worksheet tab) triggers a connection to the server. Thus,…
Bertrand Miot
  • 929
  • 5
  • 12
2
votes
1 answer

Execute XMLA script on Azure VM using powershell

I have generated a XMLA script from on premise SSAS cube , i need to execute this XMLA script in a automated way on Azure VM using powershell , the script should be idempotent in a way that if the cube/database already exists on azure vm dont…
RRR
  • 41
  • 3
2
votes
0 answers

How can I use SQL in XMLA for SSAS?

I have a problem with usage of SQL in XMLA for SSAS. It is required for Python library that interacts with SSAS server using SOAP protocol. There are 2 ways to reach data: MDX (multidimentional mode) and SQL (tabular mode). I have a simple task to…
Sergei Batishchev
  • 21
  • 1
2
votes
1 answer

TMSL Xmla Creating Tables on Existing Database - Tabular Model Scripting Language - Azure Analysis Services

My question is: What would be the correct syntax to add 2 or more tables to an existing database using xmla file and SSMS? I have a model deployed to Azure Analysis Services server. So the database is already created. I want to create or replace…
user12525899
  • 133
  • 1
  • 10
2
votes
1 answer

facing error Non-static method requires a target in SSAS TabularTMSL, Power Shell Refresh Script

I am trying to refresh the SSAS tabular Cube hosted on Azure using Power Shell TMSL Script using Azure Runbooks For larger partitions i am getting following error, I have tried increasing the timeout for Invoke-ASCmd , even with unlimited time out i…
kanna
  • 31
  • 2
1
2
3
…
11 12