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
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
  • 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.
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!


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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
push and Pull replication 31 46
query analyser in sql server 2016 express edition 2 25
SQL Add Parameter in Variable 4 21
Related to SQL Query 5 20
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

756 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