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

I created Analysis services databases by xmla scripts. But I can't show the values in table. e.g. run DAX 'evaluate table_name',there presents nothing

I want to create many Analysis Services Databases, but don't want to create Analysis Services Tabular Projects manually. So I run some xmla scripts. The databases are constructed After running, but I can't show or use the values in the table. when I…
Tobey
  • 1
  • 2
-1
votes
1 answer

Google analitycs API. Get data by xmla

Whether there is a possibility of obtaining data and metadata via xmla? I want to connect to xmla server via olap4j and visualize data from google.
-1
votes
2 answers

Editing an XMLA File Through Powershell using Get and Set-Content

I have been tasked at work to automate the monthly maintenance. Basically I need to edit the date values in an xmla file to the next month. This is the relevant section in the XMLA file:
-1
votes
1 answer

trouble running xmla script

I am following a guide learning SSIS and i am running some xmla-script before the actual ssis-work begin. the xmla-script runs against sample Analysis DB AdventureWorksDW2008R2. The script:
daniel_aren
  • 1,714
  • 3
  • 24
  • 41
-2
votes
1 answer

Can't recreate deleted SSAS database

I didn't like the DatabaseID of my SSAS database, so I decide to delete/create it. I generated a create script, and then a delete script. I changed the ID in the create script to the one I want. I ran the delete script. It ran successfully. …
Tab Alleman
  • 31,483
  • 7
  • 36
  • 52
1 2 3
11
12