Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today. |
|
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience. Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements? Download Free Report! |
I need some additionals details about create a XML file from Cube data.
I don't see any examples that use ADODB.StreamXML method in the 2.7 version. What version of the library you use?
In adition, I have a doubt; This method write all the existing data in the cube into a XML file?
I appreciate all the info that you can send my.
Thanks a lot,
Gabriel
In order to use the .StreamXML method, you must use the 2.8 version of MDAC which is available at http://www.microsoft.com/data
Your observation about the size of the XML file is well warranted. The XML file will contain only the cellset of the current intersection of the cube that is requested on behalf of the user by the application. While this is not the whole cube, caution must be taken to ensure that the cellset is not large enough to cause disk contention, or slow downloads.
Hope that helps!