Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Mdx query to xml

Posted on 2009-07-05
Last Modified: 2012-05-07
I have the same requirement, I need to put the mdx resultset to xml so that I can use it in flex.

As post suggest to create a stored procedure with universal table, I didnt not understand this comment, if possible can post the code for the stored procedure to create the xml using any sample example, it would be great help.
Question by:parveenh_123
  • 4
  • 3
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24792296
Hope this helps:


Just encapsulate the SELECT query to a procedure so that the procedure creates an XML output.

Author Comment

ID: 24792431
I have gone through this, can you provide me one sample example and is it possible with mysql
LVL 57

Accepted Solution

Raja Jegan R earned 500 total points
ID: 24792496
I thought you are referring to SQL Server and I am not sure with MySQL.
Some other expert might help you out on this.
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.


Author Comment

ID: 24811642
Ok, Thanks
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24811687
Kindly click on Request Attention button to request moderators to Include MySQL in your Question Zone, so that some other experts will visit this question and try helping you..

Author Comment

ID: 24820173

I resolve the issue.
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24820326
You can post the solution here so that others who might visit this question will be benefited.

Kindly close this question accordingly since the issues is resolved.

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql, case when & top 1 14 27
SQL Group By Question 4 19
SQL Find Carriage Return and Delete it. 3 13
Testing for Null in Stored Proc Return Value 5 15
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question