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

How to create a stored procedure in SQL Server which creates dynamic partitions and process for the tabular model

How to create a stored procedure in SQL Server which creates dynamic partitions and process? I have below code which creates a partition every time, and does process at one time in liked server. Using below code I would like to create dynamic…
saij
  • 57
  • 2
  • 7
0
votes
1 answer

Unable to connect to XMLA/Mondrian using olap4j

I'm trying to connect to XMLA webservice through the java api (olap4j) in order to execute MDX queries over Mondrian cube which is sit in BI tool hosted in localhost. This is my code below : try { …
Brahim SLIMANI
  • 310
  • 1
  • 8
0
votes
1 answer

Creating a role in SSAS

I have a role that has been working fine for a while. The only user added to that role was a local user set up on the server called Cube. However all of a sudden the membername for that user against the role is the SID not the value…
Chris Sparkes
  • 33
  • 5
0
votes
1 answer

How does SSAS populate the LEVEL_TYPE information in MDSCHEMA_LEVELS rowset

I ran the following DMV query on SSAS. SELECT [HIERARCHY_UNIQUE_NAME], [LEVEL_NAME], [LEVEL_NUMBER], [LEVEL_CARDINALITY], [LEVEL_TYPE] from $system.mdschema_levels where [DIMENSION_UNIQUE_NAME] = '[DATE]' AND [CUBE_NAME] = 'Adventure Works' …
rshetye
  • 667
  • 1
  • 8
  • 21
0
votes
1 answer

SSAS tabular model - processing history

I'm looking for a clever solution to store information about the tabular model model processing history. I tried to use extended events tracking for that but don't know how to find a model name in that logs. Any ideas would be really helpful. Thx…
PietkaSmig
  • 1
0
votes
1 answer

Olap exception : Mondrian XML : :No function matches signature 'Exists(, )'

if there anyone who already get this type of error: OlapException: XMLA provider gave exception: SOAP-ENV:Client.00HSBD01 XMLA MDX parse failed Mondrian…
CrazySearcher
  • 3
  • 3
0
votes
1 answer

How to convert Xmla file to Xml format

I am working on ER diagram for a tabular model(SSAS), so converted my model to XMLA file, but my ER diagram tool is accepting only xml format files. So, I need info how to convert my xmla file to xml.
k5656
  • 85
  • 10
0
votes
0 answers

How to get Cube Data Source View Last Schema Update value

SQL Server Analysis Services Is there a way to get the data source view last schema update value as seen on the properties dialog box? If I use the DMV syntax: SELECT * FROM $System.MDSCHEMA_CUBES It will list all the measures and dimensions used in…
Willie P
  • 1
  • 5
0
votes
0 answers

Xamarin app deployment

I am wondering how I can actually download the app I created from Xamarin onto my phone (iOS). I am not sure if I have to publish it on the app store or if there is a medium that I take it through so I can use the App? I am new to coding and made a…
Alex Fields
  • 67
  • 2
  • 11
0
votes
0 answers

How to write xmla query to process tabular cube tables sequentially?

We have a tabular cube with quite a few tables in it and we have a sql job that runs multiple times a day to process the tables in the cube. Recently we added a couple of new tables and the sql job that runs continually fails because of an out of…
MattyKluch
  • 11
  • 1
  • 10
0
votes
1 answer

SSAS creating cubes dynamically from XMLA

Is it possible to create cubes from XMLA just by replacing the the database and table names? What I mean is that when you generate from one cube the script to create it, just replace all the related references to tables and database and change the…
user1054844
  • 922
  • 5
  • 17
  • 34
0
votes
1 answer

Multiple Root XML - SQL Server

I have the following XML code and I'm trying to generate the xml shown after the code - tried several approaches but no success. There are 2 tables: [meiForecasting].[dbo].george_mdx has the data shown below and the data for the other follows. I'm…
George Appiah Sarfo
  • 105
  • 2
  • 12
0
votes
1 answer

How do I connect to a Mondrian cube(XMLA) using IBM Cognos

I want to connect to a Mondrian cube that I've developed using IBM Cognos. On the Cognose framework I can't see the XMLA datasource on the list, the datasource connection should be an ODBO. How can I made the ODBO connection…
Monwabisa
  • 1
  • 3
0
votes
1 answer

python xsd within soap response

I'm using spyne for generating web services in the server side with python to communicate with an excel client (xmla plugin), and I have some difficulties to generate a soap response that match with the client request, what I want is a soap response…
Mouadh Kaabachi
  • 3
  • 3
0
votes
1 answer

SSAS Tabular - Process model but only specific partition

We process our tabular model each night using a SQL Server Analysis Services Command in a SQL job step. The type if ProcessFull. As our data has grown, our processing time has also increased. So, we're looking at partitioning our large tables to…
buck
  • 207
  • 2
  • 9
1 2 3
…
11 12