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

Refreshing SSAS Cube with XMLA script

I am trying to refresh a SSAS cube running on my local machine, that gets its data from the server. I have reviewed a few websites such as http://technet.microsoft.com/en-us/library/ff929186.aspx for assistance but it doesnt seem to help. Below is…
Silentdarkness
  • 461
  • 1
  • 10
  • 30
0
votes
1 answer

How can I find and increment datestrings in an XML file?

I have an XML file (actually XMLA) which will be used to dynamically drop and create partitions in MS Analysis Services on a rolling basis. My requirement is that I have to edit the file in unix as the file will be consumed and sent over to the AS…
bigbadfisher
  • 3
  • 2
0
votes
0 answers

Is there a limit on the size on an XMLA query?

I have an xmla query that is 10.8 megs, to generate a full SSAS DB with partitions. After a certain size the editor stops working, I cannot copy paste from/to it, I get memory errors when trying to save and when I try to execute the query, nothing…
A.G.
  • 2,089
  • 3
  • 30
  • 52
0
votes
0 answers

JasperReports: fillReport in Java with XML-A datasource (Olap)

I have a Java service that I generates reports with the JasperReports 4.0.5 library. It works well with standard JDBC datasource. Now I am trying to run it on olap datasource, then connecting me to a XML-A server. In the design phase with iReport,…
T. Phanelly
  • 189
  • 5
  • 17
0
votes
1 answer

Why I can not connect to my SSAS cube via XML/A in SSMS?

I have a question on my configuration when connect to SSAS with SSMS. Here comes my action: Follow the official tutorial(http://msdn.microsoft.com/en-us/library/gg492140.aspx) to config my SQL Server 2008 R2 and IIS 7.5 on Windows 2008 R2. Follow…
RobinMin
  • 373
  • 1
  • 4
  • 12
0
votes
1 answer

Excel, cannot connect to XMLA Webservice

I try to create connection to a XMLA Web Service in Excel. I'm using Analysis Services connection assistant. I fill the first mask with web service url and credentials. Then I get 10 DISCOVER_PROPERTIES and one DISCOVER_SCHEMA_ROWSETS requests on…
sergej.dobryak
  • 11
  • 1
0
votes
1 answer

Full Process cube in SSIS

I have a XMLA script like below to process (full process) the cube Adventure Works DW Standard Edition Adventure Works DW ProcessFull …
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
0
votes
1 answer

Which web services should we use to send MDX queries to ActivePivot?

In our company, users already query activepivot through standard front-end (Excel). But we would like to build a custom MDX application in Java to query ActivePivot. The goal is to be able to subscribe to several specific views and to retrieve…
JBE
  • 11,917
  • 7
  • 49
  • 51
0
votes
2 answers

Automate deployment of XMLA / documentation on Microsoft.AnalysisServices.Xmla

I'm looking to automate the deployment of XMLA scripts. I've come across an article that gives a small demo, but I'm hoping to find more info. Specifically, where is the documentation for Microsoft.AnalysisServices.Xmla.XmlaClient and what is the…
Scott Weinstein
  • 18,890
  • 14
  • 78
  • 115
0
votes
1 answer

SQL Integration Services: XMLA or SSIS to Load CSV

Is it better to use XMLA or SSIS to load/import CSV data into a database? My sys admin recommends using XMLA + DDL to load the data instead of traditional SSIS. To me it sounds like SSIS is the preferred way. Any suggestions will help greatly.
Arcadian
  • 4,312
  • 12
  • 64
  • 107
0
votes
1 answer

Crystal Reports against OLAP / XMLA / SimbaO2X-server

I'm trying to convert some old Excel-reports to Crystal Reports. The excel sheets uses OLAP-cubes and connects to a database using a XMLA connection over a SimbaO2X driver. I just can't figure out which connection settings to use in Crystal Reports…
LapplandsCohan
  • 706
  • 4
  • 13
  • 29
0
votes
1 answer

xmla4js I keep getting Origin null is not allowed by Access-Control-Allow-Origin ajax header

I am using XMLA4JS library. The url of the xmla service is on another domain. I keep getting error message: Origin null is not allowed by Access-Control-Allow-Origin ajax header I have not modified any of their code and I am using their samples. I…
InfoLearner
  • 14,952
  • 20
  • 76
  • 124
0
votes
1 answer

Data Source Connection 'Use Windows Authentication' not applying from XMLA script

I am executing an XMLA script which creates a database. The Data Source object in the database is created successfully. When I view the connection string of the data source, the radio button for 'Use SQL Server Authentication' is selected (with…
Ouananiche
  • 579
  • 5
  • 12
-1
votes
1 answer

Updating cube (writeback) via MDX on SAP BW

Does anybody know if SAP BW supports UPDATE CUBE statement in MDX query? (connection to server established via XMLA) It returns some generic error and I cannot find any documentation... Same syntax works well for other providers. Or is there any…
vrata
  • 33
  • 2
  • 5
-1
votes
3 answers

Use Results of an XMLA query in Integration Services

I have an XMLA query which returns the State and Last Processed date of an Analysis Services cube as XML, like so: Query: DISCOVER_XML_METADATA …
Nathan Griffiths
  • 12,277
  • 2
  • 34
  • 51
1 2 3
…
11
12