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

Adding a node at a specific location in XML

How would I go about adding a tag with its value in the following xmla file (xmla = Microsoft Analysis Services) as a sub element in ? This simply adds it to the end of the file, not under . $ns = New-Object…
dirtyw0lf
  • 1,899
  • 5
  • 35
  • 63
0
votes
1 answer

XMLA Cube Synchronization location

I have the following script to synchronize my OLAP cube. It works fine but it stores data in default location at my destination server. I know the < Locations > tag can be used to specify the location of the destination. Can anyone cite an…
0
votes
0 answers

SSAS - CUBE data getting deleted while running XMLA based job

I have two CUBEs which internally use few common dimensions. The CUBEs itself are having partitions based on the year of the data. Also, I have the following two jobs set-up to refresh the latest year partitions of each CUBE. Problem: Once the first…
peakit
  • 28,597
  • 27
  • 63
  • 80
0
votes
2 answers

How to apply Hierarchize and Order by with MDX Query

I need to order Dimension with respect to descending order. without using HIERARCHIZE key word everything works fine. here i need HIERARCHIZE in order to order hierarchy level data. Select NON EMPTY({[Measures].[Internet Sales Amount]}) dimension…
TAMILARASU
  • 27
  • 7
0
votes
1 answer

dim.xml and cub.xml are corrupted

After restart my server outputs the following error massages: Errors in the metadata manager. An error occurred when loading the Unicube cube, from the file, '\\?\E:\DB\Unicube.0.db\ClientBase.3966.cub.xml'. Errors in the metadata…
user1464922
  • 371
  • 1
  • 3
  • 10
0
votes
1 answer

Java XMLA proxy class

I need to write an XMLA proxy class on Java, which communicates with the cube (Mondrian or MS SSAS) on one side and Kendo UI PivotGrid on another. It must do 2 things: make autorization on OLAP server translate queries from UI to OLAP Cube and…
Javasick
  • 2,753
  • 1
  • 23
  • 35
0
votes
1 answer

Passing a parameter in XMLA

I have the following XMLA Script to add domain Users to a specific SSAS membership role. It works fine, but I need to work that in a loop. A table with all the Users will be filled from Active Directory. The question is how can I generate the tab…
Pirvu Georgian
  • 657
  • 1
  • 12
  • 37
0
votes
2 answers

Process dimension and cube via XMLA script ignoring Dimension Key errors

In SSAS, there is an option of ignoring Dimension key errors when we manually process dimension from Visual Studio. But I did not see equivalent of it in XMLA script despite lots of binging and googling. If it is possible, kindly help.
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42
0
votes
1 answer

SSAS Prossessing using XMLA Script

When I deploy my SSAS solution using BIDS, it works perfectly. Now, I want to deploy my solution using XMLA script (because I don't have have BIDS installed on the prod server) I generated the XMLA script from the SSAS database Now, I executed the…
ihebiheb
  • 3,673
  • 3
  • 46
  • 55
0
votes
1 answer

How to query (xmla) the size of an OLAP catalog in MSAS2008?

I would like to be able to query against an SSAS2008 instance and get a listing of all the catalogs that exist in it, as well as their respective storage sizes. In Management Studio, I can right click on the catalog and go to its properties, which…
Burg
  • 1,988
  • 1
  • 18
  • 22
0
votes
1 answer

Check is tabular model has loaded latest data

We've a few tabular models on 2012 server. We have queries running to find if the processing of these was successful and that's about it. Most of the times processing is successful but it does not have the latest data. Can I run some MDX XMLA to…
CeeVei
  • 95
  • 2
  • 13
0
votes
1 answer
0
votes
2 answers

SSIS 2008 String Variable with Analysis Services XMLA Command

I'm having an issue whereby I'm attempting to build up an XMLA command within an SSIS 2008 variable so that I can create/process Analysis Services 2008 partitions dynamically. The issue I'm facing is the XMLA command contains double quotes and I…
0
votes
1 answer

xmla / mdx script to define measure display folder

I have an SSAS DB that was automatically generated by an application i use. This DB has a lot of measures and I would like to define 'display folder' to the measures so the cube will be more user friendly in Excel. I want an xmla/mdx ( script that…
0
votes
1 answer

XML/A error response: what is the standard?

I maintain a library that provides XML/A access trhough javascript: https://github.com/rpbouman/xmla4js Mostly it works ok, but I would like to improve handling of error responses. As far as I understand the XML/A spec corectly, error responses take…
Roland Bouman
  • 31,125
  • 6
  • 66
  • 67