We help IT Professionals succeed at work.

Mdx query to xml

Medium Priority
625 Views
Last Modified: 2012-05-07
Hi,
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.
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Hope this helps:

https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23276895.html

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

Author

Commented:
I have gone through this, can you provide me one sample example and is it possible with mysql
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Ok, Thanks
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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

Commented:
Thanks,

I resolve the issue.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.