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
2 answers

Get the relations between dimensions and measure groups

There is the "Show fields related to:" feature in Excel: I want something like this, but return in the following form: MeasureGroup1: Dimension1, Dimension2, Dimesion3 MeasureGroup2: Dimension2, Dimesion3 ... Can't find out how Excel retrieve this…
Danylo Korostil
  • 1,464
  • 2
  • 10
  • 19
1
vote
2 answers

SSAS - Is it possible to add an attribute to an existing dimension w/o redeploying the entire cube

I have a dimension Entity with just Key and Value attributes. We need to add a new attribute, IsSpecial with a default member of [False]. When I try to run the xmla, I get the following error: Errors in the metadata manager. The cube with the ID…
Scott Weinstein
  • 18,890
  • 14
  • 78
  • 115
1
vote
1 answer

How to execute xmla command on iccube?

Seing cube_management page, I see we can execute xmla commands like LIST_SCHEMA_BACKUP Seing xmla page, I see we can connect to xmla using http://localhost:8282/icCube/xmla in a navigator Is there a way to execute directly commands from a navigator…
Bertrand Miot
  • 929
  • 5
  • 12
1
vote
1 answer

Define timeout for XMLA requests in iccube

Is there a way to define a timeout for xmla requests in IcCube ? Very long requests may use all the resources and should be killed to avoid that...
Bertrand Miot
  • 929
  • 5
  • 12
1
vote
0 answers

XML/A HTTP MDX access to Sql Server Columnstore index

I have a software component (the DevExtreme PivotGrid) that supports being bound to an XML/A HTTP endpoint it does MDX queries against, and that's the only remote binding it supports. A nice thing about this kind of binding is that Excel also can…
John
  • 6,693
  • 3
  • 51
  • 90
1
vote
2 answers

Run xmla file (Analysis Services) from command line

I'm looking for tool or a easy way to run xmla script (example for create or delete cube). I used to make exe file using Inno Setup program and there I can write command which can run another exe file just like in command line. I found that there is…
Monic
  • 726
  • 10
  • 31
1
vote
1 answer

XMLA/SOAP command from a bash shell

I need to call the management API from icCube from withing a bash shell. What is the easiest way for sending a SOAP command like :
ic3
  • 7,917
  • 14
  • 67
  • 115
1
vote
0 answers

New mondrian cube not available in XMLA pentaho

I have a mondrian cub xml schema file. I have used it a a basis for an Analysis DataSource. I can query the thing file with Saiku, and everthing works fine. However, when I use olap4j and try to connect to it via the xmla connetor, it does not…
mmaceachran
  • 3,178
  • 7
  • 53
  • 102
1
vote
1 answer

icCube usage from Libreoffice

http://www.iccube.com/support/documentation/user_guide/integration/integration.php This works in excel, but being a mac user I would prefer it works in Libreoffice. I have no plans of installing Mac Excel also. Is there any tool in libreoffice to…
coffeequant
  • 425
  • 3
  • 6
  • 19
1
vote
1 answer

XML for Analysis (XML/A) format of member names?

I have two different XML/A providers, Mondrian and icCube. The tuples for a time dimension contain the unique name for the member, but the format of the member name is different: Mondrian:…
Roland Bouman
  • 31,125
  • 6
  • 66
  • 67
1
vote
1 answer

Mondrian XML/A server errors (app works fine with Olap4J API)

I have set up Mondrian on JBoss and it works fine when running an MDX statement via the Olap4J API. But when I set up Mondrian as XML/A server, I get the exception below (in the server console) when trying to connect with Warehouse Explorer (aka…
ps0604
  • 1,227
  • 23
  • 133
  • 330
1
vote
0 answers

The xml for analysis request timed ,when trying to connect ssas cube from Excel

There are workbook connections in excel sheet, which connects to an analysis service cube. All connections connects to same cube on same server. only One of the connection keep giving the following error message!!! Data could not be retrieved from…
user1254579
  • 3,901
  • 21
  • 65
  • 104
1
vote
0 answers

Infragistics ADOMD ClassCastException when connecting to ActivePivot's XMLA server

I am trying to edit the Infragistics WPF PivotGrid Sample so that it will connect to the ActivePivot Sandbox Server. ActivePivot supports XMLA and I can connect to the same Sandbox Server using the 'From Analysis Services' DataSource option in MS…
doc
  • 765
  • 1
  • 6
  • 24
1
vote
1 answer

Is it possible to manually remove a Time Dimension entry in SSAS?

Wondering if it's possible to remove a Time Dimension entry such as "DEC-2014" from SSAS cube after it's processed. An Oracle lookup table provides Time dimension values, but data for each corresponding month might not be available yet. Would like…
user2966445
  • 1,267
  • 16
  • 39
1
vote
2 answers

Prevent Visual Studio Web Test from changing request details

I have a service that accepts Xmla queries for Analysis services, often times those queries themselves will have a string that contains a fragment that looks something like {{[Time].[Year].[All]}} Recording these requests works fine but when I try…
keithwarren7
  • 14,094
  • 8
  • 53
  • 74
1 2 3
…
11 12