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

Is OLAP4J dead and is there a replacement equivalent?

Is OLAP4J (Java library for connecting to XMLA services) dead? The things that suggest it is are: The web site hasn't been updated since 2013. The last message on the dev mailling list was in May 2016. The last available release build was 1.2.0, in…
jon hanson
  • 8,722
  • 2
  • 37
  • 61
2
votes
1 answer

How to give Perspective access without Cube access?

in a Cube, I have a calculated measure [Nb>4] depending on a measure [Nb], filtering only the values above 4. We don't want users to see the underlying measure [Nb], so I defined a perspective which hides it using -[Measures].[Nb] I am looking for a…
Bertrand Miot
  • 929
  • 5
  • 12
2
votes
0 answers

Pentaho reports with OLAP data source and SAP BW - poor performance

I have few BEx queries (OLAP cubes for third-party client) and .prpt reports in Pentaho that uses these BEx via OLAP data source (OLAP4J, MDX). When I execute these BEx in SAP BW or even directly as SOAP service (XML/A execute command via SoapUI),…
semenchikus
  • 730
  • 8
  • 17
2
votes
1 answer

icCube - XMLA authentication/authorization not working as expected

I am trying to limit user to see only one schema over XMLA. For that i have done: created separate role without full access check Created separate role without full access check In Applications tab checked only XMLA In Schemas tab selected…
Oleksandr Voytsekhovskyy
  • 176
  • 1
  • 6
2
votes
1 answer

olap4j. MDX (XMLA) query takes too long

I have simple MDX query. It takes less than 1 second to execute it: SELECT NON EMPTY { } ON COLUMNS, NON EMPTY {[Z_OP].[LEVEL01].MEMBERS * [Z_NV].[LEVEL01].MEMBERS * [Z_DT].[LEVEL01].MEMBERS } ON ROWS FROM [Z_TEST/Z_TEST_REQ] However…
Aries
  • 433
  • 7
  • 17
2
votes
1 answer

icCube: wsdl document for the xmla layer

Is there available an URL to a WSDL document which describes the icCube XMLA services? How to access them and how to use its methods? Thanks in advance!
Zoltán Antal
  • 21
  • 1
2
votes
1 answer

JPivot pivot table by XMLA not working in mondrian

I installed the mondrian in my centos. http://localhost:8080/mondrian/ is shows Mondrian examples: JPivot pivot table JPivot pivot table by XMLA JPivot with 4 hierarchies JPivot with role 'California Manager' set JPivot with arrows JPivot with…
devendra singh
  • 219
  • 3
  • 15
2
votes
0 answers

Pentaho BI data source for custom OLAP (XML/A) provider

I need to be able to create simple ad-hoc reports on Pentaho BI using plugins like Pivot4j or Saiku. My data provider is SAP with XML/A interface. So the question is how could I create an OLAP data source that based on XMLA protocol? Or it is…
semenchikus
  • 730
  • 8
  • 17
2
votes
1 answer

Connecting through XMLA using JDBC

I'm trying to connect to SpagoBI using a XMLA data source. This is my JDBC URL: jdbc:xmla:Server=http://localhost/olap/msmdpump.dll; And I'm using this driver: com.microsoft.sqlserver.jdbc.SQLServerDriver I'm trying to connect to a SSAS cube.…
Alvaro VS
  • 203
  • 1
  • 5
  • 15
2
votes
1 answer

border.background image fixed

I'm starting in WPF and I'm developing an application that has a background (.png) applied as follow: '' '' '' No problems until here. My problem is…
Reginardo Tribuzi Lula Júnior
  • 73
  • 1
  • 7
2
votes
1 answer

Pentaho Mondrian OLAP Schema Roles

I have a Mondrian server webapp up and running to handle MDX queries, fetch data from the OLAP cubes defined in our Mondrian Schema, and return the XMLA required by the front-end GUI application to show the queried data. That all works, but now I'm…
Aventil
  • 31
  • 5
2
votes
2 answers

What is Write Back?

When I process a cube in SSMS and script to XMLA, I notice the following element: UseExisting What is the writeback table creation feature, and what does it mean for SSAS to UseExisting?
stevebot
  • 23,275
  • 29
  • 119
  • 181
1
vote
1 answer

How to get the list of databases in an analysis services using xmlaclient in c#

I connected to a particular server in c# using xmlaClient object. Now i want to list out the all databases in that particaular server. how to implement that. Please help me. Thanks
Mihir
  • 8,696
  • 18
  • 56
  • 87
1
vote
1 answer

MDX query creating verbose xml style field names in dataset in SSRS

I just pasted a query (which works in SSMS) into a new dataset in VS.net/BIDS However, the field/column names returned are all showing values…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
1
vote
1 answer

How can i get Server Name,ID in XMLA file?

I want to create a Dynamic XMLA file where i want to process the cubes on different servers . This is the script i have generated from Mangement studio. but i could not able to see the Server node in the XMLA file ( , ) How can i get this from…
user1049198
  • 13
  • 1
  • 4
1 2
3
…
11 12