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

Running SSAS XMLA queries in parallel

I have two xmla queries (to process SSAS Cubes) that have been embedded in two separate SQL Server scheduled jobs. These jobs get triggered by some code at random time and there may be a time when both of the jobs get triggered at the same time. In…
Suresh
  • 156
  • 1
  • 11
1
vote
1 answer

SSAS/AMO: How to get list of members of an attribute

I need to retrieve list of members for particular dimension/attribute using AMO (Microsoft.AnalysisService.dll) in .NET 4 project. How do I do that? I can connect to the server, open the database and see the dimensions, but the Hierarchies…
Ivan Krivyakov
  • 1,898
  • 1
  • 17
  • 27
1
vote
1 answer

JasperReports: "Invalid field mapping" / "line 1:1: unexpected token: [Measures]" error XML-A datasource (Olap)

I'm building a Java service that generates reports (with the JasperReports 4.0.5 library), with olap datasource (XML-A server). On iReport I write XMLA-MDX query and I visualize correctly the preview. But when I run it in Java, I get error "line…
T. Phanelly
  • 189
  • 5
  • 17
1
vote
0 answers

Can msmdpump be used for connecting to local cubes?

I am trying to configure IIS to connect to a local cube(.CUB file) through msmdpump so I can query the local cube using XMLA. I changed msmdpump.ini to look like this: "C:\Adventure Works.cub" …
user2574274
  • 11
  • 1
1
vote
2 answers

Add attribute to cube and reprocess without original database

Every year we keep a historical copy of one of our cubes. This year someone decided they wanted to pay us money to add an attribute to the cube which did not previously exists. Fine, I like money, but the issue is we don't have a backup of the…
stevebot
  • 23,275
  • 29
  • 119
  • 181
1
vote
1 answer

XMLA Discover unparse results error (in Mondrian on Windows 7)

I setup Mondrian and it is working fine but I am unable to make it the XMLA provider. ie., http://localhost:8080/mondrian works fine but http://localhost:8080/mondrian/xmla.jsp returns the below error :-
ilight
  • 1,622
  • 2
  • 22
  • 44
1
vote
2 answers

Deploying SSAS cube to environments

We are using BIDS 2008 locally (on our workstations) to develop our OLAP objects/cube. Come the time of promotion to Development we can deploy via BIDS. However when a hands-off deployment is required (eg. to UAT or Live) we are generating an XMLA…
Travis Ingram
  • 387
  • 5
  • 21
1
vote
1 answer

Determine hardware specs and OS version of SSAS box using XMLA or a DMV?

At my current project, SSAS is running on a standalone server and I'd like to know the hardware specs (CPU, Memory, etc) and OS version. The catch is I don't have access to the OS (or even remote access to perfmon or eventvwr) and the DBA's have…
Bill Anton
  • 2,920
  • 17
  • 23
0
votes
1 answer

How to process the cube by using xmla in c# coding

I have list of analysis services databases, and their cubes and dimensions. Now i want to process the selected cube in c# by using linq to xml? how to give the instruction to process. Please help me. Thanks
Mihir
  • 8,696
  • 18
  • 56
  • 87
0
votes
1 answer

Process cube from TSQL

What is the way in TSQL to run the XMLA code to process a cube XMLA: Adventure Works DW ProcessFull …
ob213
  • 494
  • 1
  • 8
  • 19
0
votes
2 answers

Connect to TM1 using XMLA

I'd like to connect to a IBM Cognos TM1 using XMLA, in particular using Adomd.Net. Accoring to http://en.wikipedia.org/wiki/Comparison_of_OLAP_Servers#APIs_and_query_languages TM1 supports XMLA/MDX, but I can't find any documentation about…
Colin
  • 96
  • 1
  • 5
0
votes
0 answers

Object Level Security update using TMLS on the power bi service dataset

I am trying to set the object level security of an table in my power bi service dataset to none using TMSL. Below mentioned MS doc says it could done with basic TMSL command. But it throws error saying "Data at root level is invalid" "roles": [ …
Mohit Leekha
  • 61
  • 11
0
votes
1 answer

Retrieving Partition Properties Script from SQL Server DB

I am attempting to catalogue a set of olap-cubes from a SQL Server DB. In the analysis services (SSMS), I can right click a measure_group/table, click partitions, properties, and then use "Script Action to New Query Window". This yields me a script…
James
  • 463
  • 4
  • 13
0
votes
1 answer

Ideas on how to consume data from a XMLA Endpoint

We have a scenario where we will be given access to a Power BI dataset (XMLA Endpoint). We will need to import data from there into our on-premise "data warehouse" database (which is a normal MS-SQL database on SQL 2016), and this has to run as a…
AhmedHuq
  • 459
  • 1
  • 4
  • 13
0
votes
0 answers

Update Shared Expression (Dataset parameter) with Tabular Editor command line / Powershell

I'm using Tabular Editor to deploy Power BI datsets to Power BI via Azure DevOps Pipelines. During the deployment process i'm succesfully updating the dataset parameters via an UpdateParameters.csx script. Right now I have the requirement to update…
Bosmeneer
  • 1
  • 2
1 2 3
…
11 12