Re: response xml query

[Sloan Seaman]

Microsoft in particular does not send back valid XML...   If you are dealing with Microsoft XML/A you may want to check out www.sourceforge.net/projects/xmlaprocessor which is a project I wrote to deal with XML/A.   It stores the results in a true multidimential data structure of cubes, dimentions, and members.  It does not use Axis because of speed reasons (writing the connection and soap handlers myself saved over 40 seconds on the queries I was doing... 10+ megs of XML returned)   Take a look at it.. it sounds like it is what you need... -- Sloan   ----- Original Message ----- From: Sumeet Satish Agarkar To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:53 AM Subject: RE: response xml query Thank you Mike. I’ll check up on the link you have sent. I have tried sending three MDX queries to get the data from OLAP using msxisapi.dll Each time depending on the data I want to fetch <Axis Info name=”Axis0”> for the columns <Axis Info name=”Axis1”> for the rows and <Axis Info name=”SlicerAxis”> for the values as elements. The child elements vary according to the amount of data. I wanted to know if there is a specific relationship between the query I send the response XMLA I get.  Thanks.   Regards, Sumeet Agarkar Software Engineer MAC Infosys Technologies Limited® Bangalore. Extn:55936 mailto:[EMAIL PROTECTED]   -----Original Message----- From: Mike Burati [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 8:14 PM To: '[EMAIL PROTECTED]' Subject: RE: response xml query     AxisInfo is specific to XMLA, not to Apache AXIS - it's just a coincidence that the names are similar.   Our web services guy with XMLA expertise is out of the office, otherwise I could probably give you a link to XMLA info, but you can probably find more via google / altavista...   Note, from various notes I've seen ( http://www.dbforums.com/t676822.html  and others), not all XMLA providers are sending back valid XML and/or valid SOAP envelopes (eg, wrong namespace prefix and/or wrong xsi:type info), so your mileage may vary... -----Original Message----- From: Sumeet Satish Agarkar [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:56 AM To: [EMAIL PROTECTED] Subject: response xml query Hi, I have got a response from OLAP in form of xmla. Can u tell me the meaning of the tags like <AxisInfo><Axisinfo name="Axis0">...... Else can u tell me of a link which explains this? thnx   Regards, Sumeet Agarkar Software Engineer MAC Infosys Technologies Limited® Bangalore. Extn:55936 mailto:[EMAIL PROTECTED]   ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________